Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.1(EOL), 11.2, 11.4, 11.3.0, 11.3(EOL), 11.5(EOL)
-
Ubuntu 20.04
Description
Run these queries in debug build:
CREATE TABLE v0 ( v1 INT , v2 INT ) ; |
DELETE FROM v0 ORDER BY COUNT( v2 ) ; |
Will trigger Assertion Failed.
GDB info:
#0 0x00007ffff6c0c00b in raise () from /lib/x86_64-linux-gnu/libc.so.6
|
#1 0x00007ffff6beb859 in abort () from /lib/x86_64-linux-gnu/libc.so.6
|
#2 0x00007ffff6beb729 in ?? () from /lib/x86_64-linux-gnu/libc.so.6
|
#3 0x00007ffff6bfcfd6 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#4 0x0000555557afd502 in Filesort::make_sortorder (this=0x7fffd0e244e0, thd=0x62c0001e0288, join=0x0, first_table_bit=0)
|
at /home/wx/mariadb-11.3.0/sql/filesort.cc:663
|
#5 0x0000555557af94f8 in filesort (thd=0x62c0001e0288, table=0x61900006b908, filesort=0x7fffd0e244e0, tracker=0x6290000f72b8, join=0x0, first_table_bit=0)
|
at /home/wx/mariadb-11.3.0/sql/filesort.cc:230
|
#6 0x00005555570c30fa in Sql_cmd_delete::delete_from_single_table (this=0x6290000f6510, thd=0x62c0001e0288) at /home/wx/mariadb-11.3.0/sql/sql_delete.cc:659
|
#7 0x00005555570ce6fe in Sql_cmd_delete::execute_inner (this=0x6290000f6510, thd=0x62c0001e0288) at /home/wx/mariadb-11.3.0/sql/sql_delete.cc:1800
|
#8 0x00005555573a7f0d in Sql_cmd_dml::execute (this=0x6290000f6510, thd=0x62c0001e0288) at /home/wx/mariadb-11.3.0/sql/sql_select.cc:33350
|
#9 0x00005555571c1637 in mysql_execute_command (thd=0x62c0001e0288, is_called_from_prepared_stmt=false) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:4361
|
#10 0x00005555571d95e2 in mysql_parse (thd=0x62c0001e0288, rawbuf=0x6290000f52a8 "DELETE FROM v0 ORDER BY COUNT( v2 )", length=35, parser_state=0x7fffd0e25870)
|
at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:7734
|
#11 0x00005555571b1237 in dispatch_command (command=COM_QUERY, thd=0x62c0001e0288, packet=0x6290000eb289 "DELETE FROM v0 ORDER BY COUNT( v2 )",
|
packet_length=35, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1893
|
#12 0x00005555571adf7c in do_command (thd=0x62c0001e0288, blocking=true) at /home/wx/mariadb-11.3.0/sql/sql_parse.cc:1406
|
#13 0x000055555768e557 in do_handle_one_connection (connect=0x611000053e08, put_in_cache=true) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1445
|
#14 0x000055555768deb4 in handle_one_connection (arg=0x611000053e08) at /home/wx/mariadb-11.3.0/sql/sql_connect.cc:1347
|
#15 0x00005555582fa350 in pfs_spawn_thread (arg=0x618000006908) at /home/wx/mariadb-11.3.0/storage/perfschema/pfs.cc:2201
|
#16 0x00007ffff7115609 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#17 0x00007ffff6ce8133 in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Attachments
Issue Links
- relates to
-
MDEV-15178 Filesort::make_sortorder: Assertion `pos->field != __null || pos->item != __null' failed | SIGSEGV in sortlength (on optimized builds)
- Closed
-
MDEV-28883 Re-design the upper level of handling UPDATE and DELETE statements
- Closed
-
MDEV-29428 Incorrect result for delete with "order by" clause
- Closed
-
MDEV-33177 Assertion `!order->item[0]->with_sum_func()' failed
- Confirmed