mtxr/vscode-sqltools

Add option to return next #N rows when showing table records #365

dnlw07 posted onGitHub

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:

  1. 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 ago

Yeah, 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 ago

You are totally right. Evolving requirements:

Requirements:

  1. 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.
  2. Add an option to ignore this alerts
posted by mtxr about 5 years ago

Done on v0.22. Closing

posted 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 ago

Hi @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 ago

Hi! I'm also not getting the alert, is it fixed yet?

posted by mathief123 over 2 years ago

Is 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 ago

My searches of the codebase didn't find this implemented anywhere. @mtxr did I miss something?

posted by gjsjohnmurray about 2 years ago

Fund this Issue

$0.00
Funded

Pull requests