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

Server crashes in pushdown_cond_for_derived

    XMLWordPrintable

    Details

      Description

      Stack trace from 10.2 1168e2fa54

      #3  <signal handler called>
      #4  0x00007fe1f5c0996d in pushdown_cond_for_derived (thd=0x7fe1ea416070, cond=0x7fe1ea469e50, derived=0x7fe1ea465588) at /data/src/10.2/sql/sql_derived.cc:1182
      #5  0x00007fe1f5c72c71 in JOIN::optimize_inner (this=0x7fe1ea467b28) at /data/src/10.2/sql/sql_select.cc:1264
      #6  0x00007fe1f5c72344 in JOIN::optimize (this=0x7fe1ea467b28) at /data/src/10.2/sql/sql_select.cc:1076
      #7  0x00007fe1f5c7a798 in mysql_select (thd=0x7fe1ea416070, tables=0x7fe1ea464298, wild_num=1, fields=..., conds=0x7fe1ea465ba8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fe1ea467b08, unit=0x7fe1ea419b18, select_lex=0x7fe1ea41a250) at /data/src/10.2/sql/sql_select.cc:3535
      #8  0x00007fe1f5c6fea1 in handle_select (thd=0x7fe1ea416070, lex=0x7fe1ea419a50, result=0x7fe1ea467b08, setup_tables_done_option=0) at /data/src/10.2/sql/sql_select.cc:373
      #9  0x00007fe1f5c3f938 in execute_sqlcom_select (thd=0x7fe1ea416070, all_tables=0x7fe1ea464298) at /data/src/10.2/sql/sql_parse.cc:6345
      #10 0x00007fe1f5c3576e in mysql_execute_command (thd=0x7fe1ea416070) at /data/src/10.2/sql/sql_parse.cc:3376
      #11 0x00007fe1f5c430d7 in mysql_parse (thd=0x7fe1ea416070, rawbuf=0x7fe1ea464088 "SELECT * FROM t WHERE 1 IN ( SELECT * FROM v )", length=46, parser_state=0x7fe1f6b91dd0, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7774
      #12 0x00007fe1f5c314c5 in dispatch_command (command=COM_QUERY, thd=0x7fe1ea416070, packet=0x7fe1ea458071 "SELECT * FROM t WHERE 1 IN ( SELECT * FROM v )", packet_length=46, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1805
      #13 0x00007fe1f5c2fef6 in do_command (thd=0x7fe1ea416070) at /data/src/10.2/sql/sql_parse.cc:1365
      #14 0x00007fe1f5d6b7ba in do_handle_one_connection (connect=0x7fe1f286d410) at /data/src/10.2/sql/sql_connect.cc:1354
      #15 0x00007fe1f5d6b547 in handle_one_connection (arg=0x7fe1f286d410) at /data/src/10.2/sql/sql_connect.cc:1260
      #16 0x00007fe1f6079b26 in pfs_spawn_thread (arg=0x7fe1f28519f0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #17 0x00007fe1f52b40a4 in start_thread (arg=0x7fe1f6b93300) at pthread_create.c:309
      #18 0x00007fe1f346c87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      CREATE TABLE t (i INT) ENGINE=MyISAM;
      CREATE VIEW v AS SELECT 5;
      SELECT * FROM t WHERE 1 IN ( SELECT * FROM v );
      

      The problem started happening after recent merges, but I can't point at the exact commit which caused it.

        Attachments

          Activity

            People

            Assignee:
            igor Igor Babaev
            Reporter:
            elenst Elena Stepanova
            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.