Query execution ends with an error due to a parsing error

dbeaver / dbeaver

Free universal database tool and SQL client

https://dbeaver.io

Apache License 2.0

39.45k stars 3.42k forks source link

Query execution ends with an error due to a parsing error #34406

Open premyslc opened 3 months ago

premyslc commented 3 months ago

Description

When i execute a select statement on Oracle DB and statement contains "end" word with semicolon at the end. Execution will fail.

DBeaver Version

24.0.1

Operating System

Linux, Windows

Database and driver

Oracle 12, Oracle JDBC Driver, 11.2.0.3

Steps to reproduce

This is OK: select * from dual some_alias;

This will fail with error ORA-00933: select from dual end_alias; select from dual endalias;

Additional context

No response

E1izabeth commented 3 months ago

I can't reproduce the issue.

Am I doing something not as you do?

https://github.com/dbeaver/dbeaver/assets/28875055/7e03b222-d1de-463f-b620-664d1509e067

premyslc commented 3 months ago

Can you try to select SQL statement manually before execution? Seems that dbeaver doesn't remove trailing semicolon in this case. Maybe "begin ... end;" block handling for Oracle DB.

I can't reproduce the issue.

Am I doing something not as you do?

dbeaver_f13L9YVmg0.mp4

E1izabeth commented 3 months ago

I reproduced the issue. Thank you for bug report.