qlstatements of selected range are erased when syntax error occurs during run selection

carloscastaneda's profile image carloscastaneda posted 6 months ago in Running SQL scripts Permalink

Debian Linux 13, HeidiSQL 12.12.1.208

When some statements of the query tab are selected and run those lines get deleted when a syntax error occurs.

carloscastaneda's profile image carloscastaneda posted 6 months ago Permalink

grafik.png

ansgar's profile image ansgar posted 6 months ago Permalink

Hm I cannot reproduce that (on Ubuntu 22.04 but that should not make a difference here). I have no clue why that happens. Did you perhaps customize the shortcuts for running SQL in some way? Did you use the run button on the toolbar or a keyboard shortcut?

carloscastaneda's profile image carloscastaneda posted 6 months ago Permalink

I think, this might be a repro. Just run the command (offending line #4).

This screenshot has been taken just before ctrl-f9

grafik.png

This screenshot has been take just after running the command. All selected lines disappeared. The command can be recovered by means of ctrl-z after confirming the message box.

grafik.png

carloscastaneda's profile image carloscastaneda posted 6 months ago Permalink

Did you perhaps customize the shortcuts for running SQL in some way? Did you use the run button on the toolbar or a keyboard shortcut? No, I didn't customize any of those settings. I only transferred the settings of my portable version on Windows.

carloscastaneda's profile image carloscastaneda posted 6 months ago Permalink

The answer to the preceding post should be no. I only transfered the setting from the windows portable version.

JeZu's profile image JeZu posted 1 month ago Permalink

Hi! Same issue here. I'm using Lubuntu with I3wm, HeidiSQL 12.15.1.1

Example with a syntax error: imagen.png

imagen.png

I did not customize the shortcuts for running SQL, and it happens even using the button on the toolbar.

But if the error is not a syntax one, it seems like it works well (at least with this example) imagen.png

Greetings! Sorry for my english!

ansgar's profile image ansgar posted 1 month ago Permalink

Thanks, I could suddenly reproduce that removal. And I fixed that for the next builds and releases.

ansgar's profile image ansgar posted 1 month ago Permalink

commit:f5c5f335304e55b07a1f16c64b64819158f2e050

JeZu's profile image JeZu posted 1 month ago Permalink

Thanks, I could suddenly reproduce that removal. And I fixed that for the next builds and releases.

Wow, Amazing! thanks for the reply!

Please login to leave a reply, or register at first.