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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.1(EOL), 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5
    • N/A
    • Prepared Statements
    • None

    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
      

      Attachments

        Issue Links

          Activity

            People

              shulga Dmitry Shulga
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.