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