Comments (6)
Hello @skriszo,
from dbeaver.
hi @ShadelessFox,
then I lose the possibility to fetch the records incrementally.
maybe it is a misunderstanding, but when I say "then DBeaver keeps fetching records endlessly", I mean that whenever I scroll down DBeaver fetches a new batch of records, but it never ends.
eg.: the table (or whatever I query from) contains only 25 rows, DBeaver does not stop at 25 (which would be the correct behaviour), but it fetches zillions of records.
from dbeaver.
I believe the RECURSIVE
clause causes this. Try putting the LIMIT
clause in the outer query.
from dbeaver.
@ShadelessFox, this query was just for demonstrative purposes, it behaves like this with simple select * from table
as well.
and also, I am not the one who puts the LIMIT
clause anywhere, but DBeaver. This is what this setting is for:
from dbeaver.
Sorry, I can't reproduce this exact scenario.
By default, DBeaver fetches rows until the entire screen is filled with data. This can be turned off as demonstrated here: #29930 (comment)
To be able to fetch next pages of data, you might need to enable such an option here:
So that you can access it from the toolbar:
from dbeaver.
well, according to my experience DBeaver fetches data until it reaches the record count that is set here (does not depend on window size):
yes, this Fetch Next Page
equals with scrolling down with Auto-fetch next segment
turned on and the issue appears with this as well.
However, I tried the same thing with an Oracle connection and it worked fine, so it is a Teradata related bug. Also what I noticed as a difference:
even with this setting turned on
with an Oracle connection the queries do not get extended with FETCH FIRST x ROWS ONLY
(this is the oracle syntax for LIMIT
)
while with a Teradata connection they do get extended with TOP x
(Teradata syntax for LIMIT
)
from dbeaver.
Related Issues (20)
- generating DDL of reshift table stalls out
- DBeaver freezes due to a non-responding script tab HOT 2
- Selections in context menu hard to see in dark mode HOT 1
- Data editor: show info about current key HOT 1
- java.lang.IndexOutOfBoundsException when handling complex structures in Clickhouse HOT 1
- Auto-SQL format needs improvement (ok, not a bug, but more than an additional feature) HOT 1
- [Oceanbase] Session manager is shown twice in Administer folder
- Launched DBeaver on Laptop without external monitors, top of window and all menu bars were off-screen
- Unable to consistently execute queries HOT 1
- Create index comments HOT 7
- Option to use default cell value viewer based on column type
- An error is reported when dbeaver is on HOT 1
- Add support for "geometry" column type
- How Using Filter->Cell Value right menu option I can select 2 fields?
- DBeaver Community 24.1.0 do not display table Constraints and Indexes (at least for Postgres and Oracle) HOT 1
- Unable to connect to repository https://dbeaver.io/update/debug/latest/content.xml HOT 7
- read-only when try to edit HOT 1
- DBeaver does not display new tables created in DuckDB databases connected via ATTACH
- Use italic font to display comments in the SQL editor.
- Database disconnection and issue to persist data
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from dbeaver.