Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
12.1.1
-
Ubuntu 20.04 x86-64, docker image mariadb:12.1.1
-
Not for Release Notes
Description
PoC:
SELECT ( WITH x ( x ) AS ( SELECT 1 ) SELECT * FROM x WHERE x IN ( SELECT ( WITH x AS ( SELECT 1 ) SELECT x FROM x GROUP BY x IN ( SELECT x FROM x ) ) FROM ( SELECT 'x' ) x ) ) x |
docker log:
#0 0x64d876e9cd79 (_ZN4JOIN14optimize_innerEv+0x5ac9)
|
#1 0x64d876e8af8b (_ZN4JOIN8optimizeEv+0x13b)
|
#2 0x64d876dcfeac (_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0x69c)
|
#3 0x64d876e8b303 (_ZN4JOIN15optimize_stage2Ev+0x283)
|
#4 0x64d876e99fab (_ZN4JOIN14optimize_innerEv+0x2cfb)
|
#5 0x64d876e8af8b (_ZN4JOIN8optimizeEv+0x13b)
|
#6 0x64d876dcfeac (_ZN13st_select_lex31optimize_unflattened_subqueriesEb+0x69c)
|
#7 0x64d876e940d1 (_ZN4JOIN15optimize_stage2Ev+0x9051)
|
#8 0x64d876e99fab (_ZN4JOIN14optimize_innerEv+0x2cfb)
|
#9 0x64d876e8af8b (_ZN4JOIN8optimizeEv+0x13b)
|
#10 0x64d876e80c04 (_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x514)
|
#11 0x64d876e80635 (_Z13handle_selectP3THDP3LEXP13select_resulty+0x265)
|
#12 0x64d876e20fc8 (_ZL21execute_sqlcom_selectP3THDP10TABLE_LIST+0x698)
|
#13 0x64d876e17095 (_Z21mysql_execute_commandP3THDb+0x3f65)
|
#14 0x64d876e0c485 (_Z11mysql_parseP3THDPcjP12Parser_state+0x345)
|
#15 0x64d876e089d1 (_Z16dispatch_command19enum_server_commandP3THDPcjb+0x16b1)
|
#16 0x64d876e0ccd1 (_Z10do_commandP3THDb+0x4b1)
|
#17 0x64d877042b74 (_Z24do_handle_one_connectionP7CONNECTb+0x2a4)
|
#18 0x64d8770427a3 (handle_one_connection+0xd3)
|
#19 0x64d87770b0b4 (pfs_spawn_thread+0x104)
|
#20 0x725838e5b609 (start_thread+0xd9)
|
#21 0x725838b7d353 (clone+0x43)
|
Attachments
Issue Links
- duplicates
-
MDEV-30756 Crash in get_sort_by_table / make_join_statistics / update_depend_map_for_order, various UBSAN pointer issues
-
- Stalled
-