MySQL/MariaDB 10.1.8_vivid: Calling Procedure kills server

[expired user #9289]'s profile image [expired user #9289] posted 8 years ago in General Permalink
Hello,

On latest nightly of HeidiSQL and also on the 9.1.4X version of Heidi, we are having the following issue: When running procedures from the GUI, the server will crash silently and the interface returns a lost connection.

It seems to concern only those procedures with a UNION statement in particular. However, standard queries with UNION work just fine.
ansgar's profile image ansgar posted 8 years ago Permalink
Does the server crash also happen when you call those procedures from another client, PHP, or whatever?
[expired user #9289]'s profile image [expired user #9289] posted 8 years ago Permalink
It does not crash when using the direct mysql client or PHP, however we have also noticed this in another GUI client, Querious.
ansgar's profile image ansgar posted 8 years ago Permalink
I'm afraid we need to dive deeper into the code of your procedures if we want to fix something here.

But first, you could probably try another MySQL client, for example MySQL Workbench.

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