Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.0.20, 10.1.13, 5.5(EOL), 10.0(EOL), 10.1(EOL)
-
CentOS 6.7
HeidiSQL
-
10.1.18, 10.1.20
Description
I got signal 11 error, when I execute the query through HeidiSQL tool.
But It didn't happen error executing through mysql client in server and toad tool.
I attached my.cnf , mysqld.err log and the query for test.
Why did it happen in HeidiSQL ? This tool version is 9.3.0.4984.
Thanks.
SELECT statements first open tables and lock them, and then they call fix_fields().
Multi-table UPDATE seems to be a special kind of statement, it opens tables, then does fix_fields calls, then calls lock_tables(). I suppose, the reason for doing things in this order is that it needs to figure out which of the tables should be locked for writing.