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

Assertion `select_lex' failed in LEX::pop_select

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4(EOL)
    • 10.4.5
    • Parser
    • None

    Description

      CREATE TABLE t1 (pk int);
      INSERT INTO t1 VALUES (1),(2),(3);
       
      ((SELECT *  FROM t1 ORDER BY pk) LIMIT 5) UNION (SELECT * FROM t1);
      

      10.4 77109285f918a6b07

      mysqld: /10.4/sql/sql_lex.h:3612: SELECT_LEX* LEX::pop_select(): Assertion `select_lex' failed.
      190430 11:02:24 [ERROR] mysqld got signal 6 ;
       
      linux/raise.c:54(__GI_raise)[0x7f962dee2428]
      stdlib/abort.c:91(__GI_abort)[0x7f962dee402a]
      assert/assert.c:92(__assert_fail_base)[0x7f962dedabd7]
      /lib/x86_64-linux-gnu/libc.so.6(+0x2dc82)[0x7f962dedac82]
      sql/sql_lex.h:3614(LEX::pop_select())[0x55704cf43870]
      sql/sql_lex.cc:9300(LEX::parsed_body_unit_tail(st_select_lex_unit*, Lex_order_limit_lock*))[0x55704cf31efc]
      sql/sql_yacc.yy:9309(MYSQLparse(THD*))[0x55704d5258ca]
      sql/sql_parse.cc:10177(parse_sql(THD*, Parser_state*, Object_creation_ctx*, bool))[0x55704cf98e3d]
      sql/sql_parse.cc:8102(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x55704cf8c436]
      sql/sql_parse.cc:1830(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x55704cf65550]
      sql/sql_parse.cc:1361(do_command(THD*))[0x55704cf6248f]
      sql/sql_connect.cc:1398(do_handle_one_connection(CONNECT*))[0x55704d2d6091]
      sql/sql_connect.cc:1302(handle_one_connection)[0x55704d2d5a5b]
      perfschema/pfs.cc:1864(pfs_spawn_thread)[0x55704e674f27]
      /lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f962ed236ba]
      x86_64/clone.S:111(clone)[0x7f962dfb441d]
      

      Attachments

        Activity

          People

            igor Igor Babaev
            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.