dbeaver: Ctrl + Enter not running code

System information:

Operating system (distribution) and version: Windows 10 Enterprise
DBeaver version: 22.0.2
Additional extensions: none

Connection specification:

Database name and version: Netezza 7.2.0.6
Driver name: JDBC
Do you use tunnels or proxies (SSH, SOCKS, etc)? No

Describe the problem you’re observing:

When I run ctrl + enter on a script with multiple statements (separated by ;) or hit the execute SQL statement button ▶️ it just runs ; and shows:

This started happening with the latest upgrade from 22.0.1 to 22.0.2 today. My settings have not changed and show:

Steps to reproduce:

These only run correctly if I highlight the text for the query I want to run before hitting ctrl + enter or the run SQL button ▶️

select * from _v_table
;

select * from _v_session
;

Include any warning/errors/backtraces from the logs

About this issue

Original URL
State: closed
Created 2 years ago
Comments: 21 (8 by maintainers)

Most upvoted comments

Please check the “Script delimiter redefiner” connection setting in the “Advanced parameters”. Set it to empty if it’s not. I hope it helps.

2022-04-15 12_21_54-Window

LonwoLonwo on Apr 15, 2022

Is this because we’re running a version from the future?? 😄

joshcsmith13 on Apr 8, 2022

2 lines is all it takes to reproduce this. the only way to get this to run is to highlight the select line, without the “;”, and execute.

I am connected to Netezza. DBeaver Version 22.0.2.202204041542

I don’t see any new packages since 2022-04-04, in Prod or EA. When was this hotfix posted? Shouldn’t it have a new version number?

joshcsmith13 on Apr 8, 2022

@serge-rider @ShadelessFox I am still having this issue. I tried installing from both https://dbeaver.io/files/ea/ (Early access) and https://dbeaver.io/download/ (Prod)

I see version 22.0.2.2022 04 04 1542 (windows 64) and Check for Updates says there are no new versions. Is there another place I should download this from or maybe the 🐛 is still here?

rjake on Apr 7, 2022

It happens when you have a semicolon on a separate line after a query. E.g.

select * from tableA
;

Workaround is to put semicolon in the end of query.

This bug was already fixed. Hotfix patch was applied to version 22.0.2, you can re-download it from dbeaver.io website or from GitHub.

serge-rider on Apr 5, 2022