HeidiSQL hangs / not responding creating triggers

Hello.

I am using version 12.0.0.6468 trying to create a trigger against a MariaDB server. Every time I attempt to do so, HeidiSQL hangs and Windows reports NOT RESPONDING.

Right-click on a database and Create Trigger.

Fill in whatever we need in the Options section. All different kinds of settings seem to hang HeidiSQL.

The Statement defaults to

BEGIN

END

Start coding inside BEGIN and END and in a few characters HeidiSQL hangs.

I did like so

BEGIN
    INSERT
END

Pressing SPACE after INSERT hangs.

Thank you.

LR

Yes, I'm getting the same issue with 12.0.0.6470

Select Version() query gives me 10.3.30-MariaDB-1:10.3.30+maria~stretch-log

I can type a few words into the Create Trigger, then get a spinning blue wheel and Heidi hangs. For example "UPDATE stock SET st" then it hangs until I force close.

I'm getting the freeze/hang too every time HeidiSQL tries to use "intellisense" to show me the list of applicable values for the alias in question. This happens repeatedly today when I'm trying to write a new function.

Got the same report from some other users, as well as issue #1568. Apart from myself yet - for some reasons I cannot reproduce that hanging/freezing. So please try to narrow it down, probably post a screen of the settings in Tools > Preferences > SQL.

I'll try to narrow it down but in the meantime, my SQL settings are attached.

Thank you.

I could not yet reproduce the issue again. So, anyone encountering this issue more often, please testwise disable

• the autocompletion
• and the uppercase feature,

to test if one of these is the cause for the freeze.

Please disable only one of them at one time, then test. Do not disable both at the same time, otherwise you don't know which of these is the cause.

Hello.

To touch base on this, I've not had this issue for several weeks. No hangs, no pauses, no slowdowns of any sort. These are my settings.

Same for me - no hanging at all in the last month. I wish I could reproduce it so I could fix it.

Had a couple of days getting a "Not responding" trying to edit the sql for a view. Its got complex set of nested replace functions which seem to have been created as lower case. The Auto Uppercase reserve words was turned on. Turning of that feature seems to have resolved my issue. Thought it might help someone.