Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-20516

Assertion `!lex->proc_list.first && !lex->result && !lex->param_list.elements' failed in mysql_create_view

    XMLWordPrintable

    Details

      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

            Activity

              People

              Assignee:
              shulga Dmitry Shulga
              Reporter:
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.