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

Order by clause is invalid when using filtering #32926

Open
Sidzangaria opened this issue May 15, 2024 · 0 comments
Open

Order by clause is invalid when using filtering #32926

Sidzangaria opened this issue May 15, 2024 · 0 comments

Comments

@Sidzangaria
Copy link

Description

When you write a sql such as:

Select firstName, lastName, age, city
from test.dbo.person
Order by age desc

After running the query you then apply filter in results window in dbeaver on city column, you get the following error:

SQL Error [1033] [S0001]: The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.

DBeaver Version

24.0.4.202405051837

Operating System

Windows 11

Database and driver

SQL Server 2014
MSSql jdbc 12.4.2

Steps to reproduce

  1. Write a new query in New SQL Script window
  2. Select firstName, lastName, age, city
    from test.dbo.person
    Order by age desc
  3. Run the query
  4. In the results window try to filter on the city column to any value

Additional context

No response

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

3 participants