Skip to content

Problem with SELECT statements without whitespaces #479

Description

@serge-rider

Originally found here - dbeaver/dbeaver#9309

When a query doesn't contain whitespaces (NOT including \r, \n or \t) then driver doesn't return any resultset. I.e. Statement.execute(sql) returns false. Adding a single whitespace character to a query fixes the problem.

No working query:

select
1

Working query:

select 1

The only difference that in first case we use \r\n between select and 1.

It is a not a major issue but in some cases it can make user insane :(

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions