The issue has been closed
Is your feature request related to a problem? Please describe.
Add option to return first 50 rows only, and add button in query result "return next 50 records" and "return all results"
Since we don't want to change the query without his approval, let's add an alert first.
Requirements:
- Show an alert
You are running a select query that has no limit clause, would you like to add it before continue?
before changing the query.
posted by mtxr about 5 years agoYeah, good idea!
By default the alert should be always shown.
However, please consider the option to turn off the alert in settings.
posted by dnlw07 about 5 years agoYou are totally right. Evolving requirements:
Requirements:
- Show an alert
You are running a select query that has no limit clause, would you like to add it before continue?
before changing the query.
- Add an option to ignore this alerts
posted by mtxr about 5 years agoposted by mtxr over 4 years ago @mtxr which version of v0.22 has this? Could not find it in the changelog. I'm currently on v0.22.9 and wondering what the syntax is for enabling this feature. Thanks!
posted by johndevedu over 4 years agoHi @johndevedu , it's the first version, it's enabled by default also so you should be seeing this on any queries resulting in rows number bigger than the limit
posted by mtxr over 4 years ago@mtxr I am not getting the alert when doing a select query on 0.22.9. I have the limit set to:
"sqltools.results": {
"limit": 20
}
posted by johndevedu over 4 years agoHi! I'm also not getting the alert, is it fixed yet?
posted by mathief123 over 2 years agoIs this working? I dont see any alerts. @mtxr @gjsjohnmurray how to auto set limits while running query? can the extension auto set limit to queries?
posted by vibhavagarwal5 about 2 years agoMy searches of the codebase didn't find this implemented anywhere. @mtxr did I miss something?
posted by gjsjohnmurray about 2 years ago