Skip to content

Problem with SELECT statements without whitespaces #479

@serge-rider

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 :(

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions