Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error pop-up - "Start row cannot be less than 0 or greater than the number of rows in the result set (Parameter 'startRow')" #18543

Closed
buckz1lla opened this issue Dec 23, 2024 · 2 comments

Comments

@buckz1lla
Copy link

  • MSSQL Extension Version: MSSQL Extension Version: 1.27.0
  • VSCode Version: VSCode Version: 1.95.1
  • OS Version: OS Version: Windows 11 Enterprise 10.0.22631 Build 22631

Steps to Reproduce:

  1. When running a query that would result in 0 rows returned, I'm getting the following error pop-up:
  2. mssql: Something went wrong getting more rows: Start row cannot be less than 0 or greater than the number of rows in the result set (Parameter 'startRow')

Is this intentional? Is there an option to turn that message off? It doesn't make sense to throw an 'error' just because nothing returns from a query. For context, the query I'm running is to check a Dataset Queue. So there won't always be things in said queue...

@EdCallahan
Copy link

  • MSSQL Extension Version: MSSQL Extension Version: 1.27.0
  • VSCode Version: VSCode Version: 1.95.1
  • OS Version: Win11

Same here, select that doesn't return rows throws error. For instance,

select * 
    from sys.tables
    where 1=0

gets me:

Image

Result pane does look OK though, I get the headers but no data which is appropriate

@cssuh
Copy link
Member

cssuh commented Jan 6, 2025

Hi all, this was fixed in #18535 and will be included in our next release in January.

@cssuh cssuh closed this as completed Jan 6, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants