[MDEV-17959] Assertion `opt_bootstrap || mysql_parse_status || thd->lex->select_stack_top == 0' failed in parse_sql upon DELETE HISTORY under ORACLE mode Created: 2018-12-10  Updated: 2018-12-27  Resolved: 2018-12-27

Status: Closed
Project: MariaDB Server
Component/s: Parser
Affects Version/s: 10.4
Fix Version/s: 10.4.2

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Alexander Barkov
Resolution: Fixed Votes: 0
Labels: None


 Description   

SET SQL_MODE= ORACLE;
--error ER_VERS_NOT_VERSIONED
DELETE HISTORY FROM mysql.user;

10.4 8cf7e3459d73

mysqld: /data/src/10.4-travis/sql/sql_parse.cc:10122: bool parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool): Assertion `opt_bootstrap || mysql_parse_status || thd->lex->select_stack_top == 0' failed.
181210 12:34:32 [ERROR] mysqld got signal 6 ;
 
#7  0x00007fc2b0288ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
#8  0x000055e6244161de in parse_sql (thd=0x7fc298000b00, parser_state=0x7fc2aa41a600, creation_ctx=0x0, do_pfs_digest=true) at /data/src/10.4-travis/sql/sql_parse.cc:10121
#9  0x000055e62441121c in mysql_parse (thd=0x7fc298000b00, rawbuf=0x7fc298014db8 "DELETE HISTORY FROM mysql.user", length=30, parser_state=0x7fc2aa41a600, is_com_multi=false, is_next_command=false) at /data/src/10.4-travis/sql/sql_parse.cc:8056
#10 0x000055e6243fe5e6 in dispatch_command (command=COM_QUERY, thd=0x7fc298000b00, packet=0x7fc29800b421 "DELETE HISTORY FROM mysql.user", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.4-travis/sql/sql_parse.cc:1850
#11 0x000055e6243fd00a in do_command (thd=0x7fc298000b00) at /data/src/10.4-travis/sql/sql_parse.cc:1395
#12 0x000055e624568dd6 in do_handle_one_connection (connect=0x55e627b17b90) at /data/src/10.4-travis/sql/sql_connect.cc:1402
#13 0x000055e624568b5a in handle_one_connection (arg=0x55e627b17b90) at /data/src/10.4-travis/sql/sql_connect.cc:1308
#14 0x000055e624a21890 in pfs_spawn_thread (arg=0x55e627c105d0) at /data/src/10.4-travis/storage/perfschema/pfs.cc:1862
#15 0x00007fc2b1d44494 in start_thread (arg=0x7fc2aa41b700) at pthread_create.c:333
#16 0x00007fc2b034593f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Oddly, not reproducible on 10.3.



 Comments   
Comment by Alexander Barkov [ 2018-12-27 ]

The same problem is repeatable with this script:

SET SQL_MODE= ORACLE;
DROP TABLE t1;
CREATE TABLE t1 (a INT);
DELETE HISTORY FROM t1;

Generated at Thu Feb 08 08:40:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.