Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL)
-
None
Description
to reproduce run with --cursor-protocol:
create table t1 (a int); |
create view v1 as select * from t1; |
10.1 0e38cd37c7be46ac2b5 |
#3 <signal handler called>
|
#4 0x00007f271a4b6428 in __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:54
|
#5 0x00007f271a4b802a in __GI_abort () at abort.c:89
|
#6 0x00007f271a4aebd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5639ead5eed0 "!lex->proc_list.first && !lex->result && !lex->param_list.elements", file=file@entry=0x5639ead5ee40 "/10.1/sql/sql_view.cc", line=line@entry=410, function=function@entry=0x5639ead5f460 <mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode)::__PRETTY_FUNCTION__> "bool mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode)") at assert.c:92
|
#7 0x00007f271a4aec82 in __GI___assert_fail (assertion=0x5639ead5eed0 "!lex->proc_list.first && !lex->result && !lex->param_list.elements", file=0x5639ead5ee40 "/10.1/sql/sql_view.cc", line=410, function=0x5639ead5f460 <mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode)::__PRETTY_FUNCTION__> "bool mysql_create_view(THD*, TABLE_LIST*, enum_view_create_mode)") at assert.c:101
|
#8 0x00005639ea4d08e0 in mysql_create_view (thd=0x7f27127f2070, views=0x7f27108fb668, mode=VIEW_CREATE_NEW) at /10.1/sql/sql_view.cc:409
|
#9 0x00005639ea3f0b85 in mysql_execute_command (thd=0x7f27127f2070) at /10.1/sql/sql_parse.cc:5266
|
#10 0x00005639ea79a8e4 in mysql_open_cursor (thd=0x7f27127f2070, result=0x7f2710986528, pcursor=0x7f2710986590) at /10.1/sql/sql_cursor.cc:141
|
#11 0x00005639ea411003 in Prepared_statement::execute (this=0x7f2710986470, expanded_query=0x7f271c938ea0, open_cursor=true) at /10.1/sql/sql_prepare.cc:4342
|
#12 0x00005639ea40ff1f in Prepared_statement::execute_loop (this=0x7f2710986470, expanded_query=0x7f271c938ea0, open_cursor=true, packet=0x7f27147f107a "", packet_end=0x7f27147f107a "") at /10.1/sql/sql_prepare.cc:3994
|
#13 0x00005639ea40dcd0 in mysqld_stmt_execute (thd=0x7f27127f2070, packet_arg=0x7f27147f1071 "\002", packet_length=9) at /10.1/sql/sql_prepare.cc:3023
|
#14 0x00005639ea3e4f94 in dispatch_command (command=COM_STMT_EXECUTE, thd=0x7f27127f2070, packet=0x7f27147f1071 "\002", packet_length=9) at /10.1/sql/sql_parse.cc:1443
|
#15 0x00005639ea3e4060 in do_command (thd=0x7f27127f2070) at /10.1/sql/sql_parse.cc:1131
|
#16 0x00005639ea521d3d in do_handle_one_connection (thd_arg=0x7f27127f2070) at /10.1/sql/sql_connect.cc:1331
|
#17 0x00005639ea521a77 in handle_one_connection (arg=0x7f27127f2070) at /10.1/sql/sql_connect.cc:1242
|
#18 0x00005639eac2fbe8 in pfs_spawn_thread (arg=0x7f2718c15ef0) at /10.1/storage/perfschema/pfs.cc:1861
|
#19 0x00007f271aedd6ba in start_thread (arg=0x7f271c93a700) at pthread_create.c:333
|
#20 0x00007f271a58841d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
|
Attachments
Issue Links
- duplicates
-
MDEV-25941 Assertion `!lex->proc_list.first && !lex->result && !lex->param_list.elements' failed in mysql_create_view
- Closed