[MDEV-25941] Assertion `!lex->proc_list.first && !lex->result && !lex->param_list.elements' failed in mysql_create_view Created: 2021-06-16  Updated: 2022-01-09  Resolved: 2022-01-09

Status: Closed
Project: MariaDB Server
Component/s: Prepared Statements
Affects Version/s: 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Alice Sherepa Assignee: Dmitry Shulga
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-20516 Assertion `!lex->proc_list.first && !... Closed

 Description   

test fails with --cursor-protocol on 10.1-10.6, not on 5.5,10.0

CREATE TABLE t (b int);
CREATE VIEW v AS SELECT * FROM t;

10.2 35b57c37bbbfa116da4a454

Version: '10.2.39-MariaDB-debug-log' 
mysqld: /10.2/sql/sql_view.cc:413: bool mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode): Assertion `!lex->proc_list.first && !lex->result && !lex->param_list.elements' failed.
210616 13:01:40 [ERROR] mysqld got signal 6 ;
 
linux/raise.c:51(__GI_raise)[0x7f75a528e7bb]
stdlib/abort.c:81(__GI_abort)[0x7f75a5279535]
intl/loadmsgcat.c:1177(_nl_load_domain)[0x7f75a527940f]
/lib/x86_64-linux-gnu/libc.so.6(+0x30102)[0x7f75a5287102]
sql/sql_view.cc:422(mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode))[0x55cb3188c1c7]
sql/sql_parse.cc:5843(mysql_execute_command(THD*))[0x55cb315ec831]
sql/sql_cursor.cc:141(mysql_open_cursor(THD*, select_result*, Server_side_cursor**))[0x55cb31545dc8]
sql/sql_prepare.cc:5032(Prepared_statement::execute(String*, bool))[0x55cb3164aac4]
sql/sql_prepare.cc:4481(Prepared_statement::execute_loop(String*, bool, unsigned char*, unsigned char*))[0x55cb316463b4]
sql/sql_prepare.cc:3465(mysql_stmt_execute_common(THD*, unsigned long, unsigned char*, unsigned char*, unsigned long, bool, bool))[0x55cb3163ff09]
sql/sql_prepare.cc:3255(mysqld_stmt_execute(THD*, char*, unsigned int))[0x55cb3163f23f]
sql/sql_parse.cc:1771(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55cb315cfa88]
sql/sql_parse.cc:1381(do_command(THD*))[0x55cb315cc9cc]
sql/sql_connect.cc:1336(do_handle_one_connection(CONNECT*))[0x55cb3197686a]
sql/sql_connect.cc:1242(handle_one_connection)[0x55cb3197612b]
perfschema/pfs.cc:1871(pfs_spawn_thread)[0x55cb32e17b64]
nptl/pthread_create.c:487(start_thread)[0x7f75a59ccfa3]
x86_64/clone.S:97(clone)[0x7f75a53504cf]
 
Query (0x62b0000328f8): CREATE VIEW v AS SELECT * FROM t



 Comments   
Comment by Elena Stepanova [ 2022-01-09 ]

Same as MDEV-20516

Generated at Thu Feb 08 09:41:33 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.