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

Server crashes in COND_EQUAL::copy

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4(EOL)
    • 10.4.4
    • Optimizer
    • None

    Description

      Reproducible on 10.4 with MyIsam/Innodb

      set optimizer_switch='condition_pushdown_from_having=on';
      CREATE TABLE t1 (id int);
      CREATE TABLE t2 (pk int, v varchar(1));
       
      SELECT t2.pk
      FROM (t2, t2 AS dtb, t1)
      WHERE t1.id = 3 OR t2.v = dtb.v AND (t2.pk = 212 AND t2.pk = 95)
      GROUP BY t2.pk 
      HAVING t2.pk = 'x';
      

      10.4 4932aba921755cfbc35

      #3  <signal handler called>
      #4  0x00005561099bb66d in COND_EQUAL::copy (this=0x0, cond_equal=...) at /10.4/sql/item_cmpfunc.h:3237
      #5  0x0000556109b03611 in and_new_conditions_to_optimized_cond (thd=0x7fbd50000a98, cond=0x7fbd50060000, cond_eq=0x7fbd5005f318, new_conds=..., cond_value=0x7fbd5005f1b0, build_cond_equal=true) at /10.4/sql/opt_subselect.cc:5775
      #6  0x000055610996edc7 in JOIN::optimize_inner (this=0x7fbd5005ee70) at /10.4/sql/sql_select.cc:1896
      #7  0x000055610996d6fe in JOIN::optimize (this=0x7fbd5005ee70) at /10.4/sql/sql_select.cc:1508
      #8  0x00005561099786c6 in mysql_select (thd=0x7fbd50000a98, tables=0x7fbd50139bf0, wild_num=0, fields=..., conds=0x7fbd5014a4d0, og_num=1, order=0x0, group=0x7fbd50018360, having=0x7fbd50149e80, proc_param=0x0, select_options=2147748608, result=0x7fbd5013ea00, unit=0x7fbd500049a8, select_lex=0x7fbd50147970) at /10.4/sql/sql_select.cc:4518
      #9  0x0000556109969072 in handle_select (thd=0x7fbd50000a98, lex=0x7fbd500048e0, result=0x7fbd5013ea00, setup_tables_done_option=0) at /10.4/sql/sql_select.cc:423
      #10 0x0000556109931990 in execute_sqlcom_select (thd=0x7fbd50000a98, all_tables=0x7fbd50139bf0) at /10.4/sql/sql_parse.cc:6588
      #11 0x0000556109926841 in mysql_execute_command (thd=0x7fbd50000a98) at /10.4/sql/sql_parse.cc:3825
      #12 0x00005561099358f7 in mysql_parse (thd=0x7fbd50000a98, rawbuf=0x7fbd50141340 "SELECT t2.pk\nFROM (t2, t2 AS dtb, t1)\nWHERE t1.id = 3 OR t2.v = dtb.v AND (t2.pk = 212 AND t2.pk = 95)\nGROUP BY t2.pk \nHAVING t2.pk = 'x'", length=137, parser_state=0x7fbd994a9060, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:8141
      #13 0x0000556109920b98 in dispatch_command (command=COM_QUERY, thd=0x7fbd50000a98, packet=0x7fbd50009af9 "SELECT t2.pk\nFROM (t2, t2 AS dtb, t1)\nWHERE t1.id = 3 OR t2.v = dtb.v AND (t2.pk = 212 AND t2.pk = 95)\nGROUP BY t2.pk \nHAVING t2.pk = 'x'", packet_length=137, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:1820
      #14 0x000055610991f3e8 in do_command (thd=0x7fbd50000a98) at /10.4/sql/sql_parse.cc:1358
      #15 0x0000556109a9abc5 in do_handle_one_connection (connect=0x55610c4f0208) at /10.4/sql/sql_connect.cc:1399
      #16 0x0000556109a9a903 in handle_one_connection (arg=0x55610c4f0208) at /10.4/sql/sql_connect.cc:1302
      #17 0x000055610a4247fd in pfs_spawn_thread (arg=0x55610c424738) at /10.4/storage/perfschema/pfs.cc:1862
      #18 0x00007fbda1e196ba in start_thread (arg=0x7fbd994aa700) at pthread_create.c:333
      #19 0x00007fbda10aa41d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      
      

      Attachments

        Issue Links

          Activity

            People

              shagalla Galina Shalygina (Inactive)
              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.