Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.32, 10.2(EOL), 10.3(EOL)
-
None
-
Ubuntu 20.4
Description
I got a TABLE with an ID two foreign keys then some more columns.
For context it is a sport project with tupels representing each a result of a match between Host and Guest.
SELECT * FROM match t1 WHERE (203, 204) IN ((t1.Host, t1.Guest), (t1.Guest, t1.Host)) |
works as expected
SELECT * FROM match t1, match t2 WHERE (203, t2.hostgoals) IN ((t1.hostgoals, t1.guestgoals), (t1.guestgoals, t1.hostgoals)) |
does, too
SELECT * FROM match t1, match t2 WHERE (203, t2.Host) IN ((t1.Host, t1.Guest), (t1.Guest, t1.Host)) |
crashes the server
SQLSTATE[HY000]: General error: 2006 MySQL server has gone away
|
Also after first occurence seems to have left server in corrupt state so it kept crashing without this query.
Clarifications:
"Host" and "Guest" are foreign keys to another table (same for both).
"hostgoals" and "guestgoals" are just any numbers.
Attachments
Issue Links
- relates to
-
MDEV-24337 Server crash in DTCollation::set_repertoire_from_charset
- Confirmed
-
MDEV-28346 UBSAN: runtime error: downcast of address X which does not point to an object of type 'Item_row' in Item_func_in::get_func_row_mm_tree and load of value X, which is not a valid value for type 'geometry_type' on SELECT
- Confirmed