HeidiSQL
HeidiSQL copied to clipboard
HeidiSQL
Freezing creating a trigger in MariaDB
When creating a trigger HeidiSQL freezes with a spinning blue wheel.
https://www.heidisql.com/forum.php?t=39140#p39141
Heidi SQL version 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.
Related to another forum thread: https://www.heidisql.com/forum.php?t=39040 There is already a long attempt to find a valid reproduction recipe. I just tried with yours, creating a new trigger, typing "INSERT " plus some random stuff. And I could reproduce the hanging, but only once in 10 attempts. I suspected the auto-uppercase feature to cause it, but then again the other 9 attempts did not hang. Also the new highlight feature in v12.0 (highlight same word as selection) is quite suspicious. Are you able to reproduce the freeze or is it just happening once in a while?
same problem with mysql, it happens when i type something like new. I think this is related to completer
I ended up reverting back to version 11.x until this freeze bug is fixed.
Same bug with mariadb on creation/editing triggers or functions. Mostly experienced on triggers editing when try to call suggestion menu by pressing Ctrl+space while type command.
I think it's the auto-complete or Intellisense or whatever it's called with the bug.
On 5/12/2022 3:13 PM, RiddlerX2 wrote:
Same bug with mariadb on creation/editing triggers or functions. Mostly experienced on triggers editing when try to call suggestion menu by pressing Ctrl+space while type command.
— Reply to this email directly, view it on GitHub https://github.com/HeidiSQL/HeidiSQL/issues/1568#issuecomment-1125336062, or unsubscribe https://github.com/notifications/unsubscribe-auth/AITWNACCOS4DFMYIQT5NBN3VJVJ7LANCNFSM5TPMHAPQ. You are receiving this because you commented.Message ID: @.***>
--
Thanks, and have a great day!
Michael J. Babcock, MCP, ITIL v3 President/CEO MB Software Solutions, LLC
/"Let us help you work smarter--not harder--with MB Software Solutions!”/
phone: 717.350.2759
website: http://mbsoftwaresolutions.com
remote support: https://get.teamviewer.com/worksmarter
facebook: https://www.facebook.com/MBSoftwareSolutions
twitter: @MBSS_Smart (https://twitter.com/MBSS_Smart) https://twitter.com/MBSS_Smart
linkedin: https://www.linkedin.com/in/michael-j-babcock-33286
Please consider the environment before printing this email.
The freeze happens every time, and quickly. I gave it maybe 10 attempts. Are there settings to remove the text formatting that you'd like me to test?
Get BlueMail for Android
On 15 Apr 2022, 6:50 pm, at 6:50 pm, Ansgar Becker @.***> wrote:
Related to another forum thread: https://www.heidisql.com/forum.php?t=39040 There is already a long attempt to find a valid reproduction recipe. I just tried with yours, creating a new trigger, typing "INSERT " plus some random stuff. And I could reproduce the hanging, but only once in 10 attempts. I suspected the auto-uppercase feature to cause it, but then again the other 9 attempts did not hang. Also the new highlight feature in v12.0 (highlight same word as selection) is quite suspicious. Are you able to reproduce the freeze or is it just happening once in a while?
-- Reply to this email directly or view it on GitHub: https://github.com/HeidiSQL/HeidiSQL/issues/1568#issuecomment-1099973667 You are receiving this because you authored the thread.
Message ID: @.***>
Please update to the latest nightly build and re-check if the freeze is now fixed. I can no longer reproduce it, but it was anyway not 100% reproducible here.
@jimsrobot any feedback for the latest build would be appreciated. You may also test disabling the both preference features I highlighted in the screenshot:
- uncheck auto-uppercase, 2. set fg and bg color of "brace matching color" to "None"
