Details

      Description

      Note: The test case is strange and fragile, contains some seemingly unrelated statements and structures; I removed everything I could, but the rest seems necessary, at least for reproducing the problem on my builds. So, while the current test case doesn't crash on 10.0 build, I think it's still likely that the problem present there as well, so I'm setting Fix Version to 10.0 as well – please update it if you find out that it's a 5.5-only bug.

      Stack trace from 5.5 revno 4433

      #3  <signal handler called>
      #4  0x00000000006e67f1 in st_select_lex_unit::cleanup (this=0x7f371e9d3128) at 5.5/sql/sql_union.cc:887
      #5  0x000000000069945d in free_underlaid_joins (thd=0x7f371f950060, select=0x7f371f953a60) at 5.5/sql/sql_select.cc:21825
      #6  0x0000000000618acd in mysql_insert (thd=0x7f371f950060, table_list=0x7f371ea87190, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at 5.5/sql/sql_insert.cc:992
      #7  0x0000000000636ef1 in mysql_execute_command (thd=0x7f371f950060) at 5.5/sql/sql_parse.cc:2974
      #8  0x000000000063ec8e in mysql_parse (thd=0x7f371f950060, rawbuf=0x7f371ea87078 "INSERT INTO `view_AA` ( `i` ) VALUES (3)", length=40, parser_state=0x7f371f3b5620) at 5.5/sql/sql_parse.cc:5909
      #9  0x00000000006328d1 in dispatch_command (command=COM_QUERY, thd=0x7f371f950060, packet=0x7f371fa07061 "INSERT INTO `view_AA` ( `i` ) VALUES (3)", packet_length=40) at 5.5/sql/sql_parse.cc:1079
      #10 0x0000000000631a5d in do_command (thd=0x7f371f950060) at 5.5/sql/sql_parse.cc:793
      #11 0x00000000007340ea in do_handle_one_connection (thd_arg=0x7f371f950060) at 5.5/sql/sql_connect.cc:1266
      #12 0x0000000000733ba9 in handle_one_connection (arg=0x7f371f950060) at 5.5/sql/sql_connect.cc:1181
      #13 0x0000000000b6c2cd in pfs_spawn_thread (arg=0x7f371f971ca0) at 5.5/storage/perfschema/pfs.cc:1015
      #14 0x00007f3725b44b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
      #15 0x00007f3723dfa70d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112

      Test case

      SET sql_mode = ONLY_FULL_GROUP_BY;
       
      CREATE TABLE A (
       i INT,
       i1 INT,
       i2 INT,
       d1 DATE,
       d2 DATE,
       col_time_nokey1 TIME,
       col_time_nokey2 TIME,
       col_datetime_nokey1 DATETIME,
       col_datetime_nokey2 DATETIME,
       col_varchar_nokey1 VARCHAR(1),
       col_varchar_nokey2 VARCHAR(1)
      ) ENGINE=MyISAM;
       
      CREATE VIEW view_A AS SELECT * FROM A;
       
      CREATE TABLE B (
       col_varchar_nokey VARCHAR(1)
      ) ENGINE=MyISAM;
       
      CREATE TABLE AA (
       i INT,
       i1 INT,
       i2 INT,
       d1 DATE,
       d2 DATE,
       col_time_nokey1 TIME,
       col_time_nokey2 TIME,
       col_datetime_nokey1 DATETIME,
       col_datetime_nokey2 DATETIME,
       col_varchar_nokey1 VARCHAR(1),
       col_varchar_nokey2 VARCHAR(1)
      ) ENGINE=MyISAM;
       
      CREATE VIEW view_AA AS SELECT * FROM AA;
       
      CREATE TABLE DD (
       i INT,
       i1 INT,
       i2 INT,
       d1 DATE,
       d2 DATE,
       col_time_nokey1 TIME,
       col_time_nokey2 TIME,
       col_datetime_nokey1 DATETIME,
       col_datetime_nokey2 DATETIME,
       col_varchar_nokey1 VARCHAR(1),
       col_varchar_nokey2 VARCHAR(1)
      ) ENGINE=MyISAM;
       
      CREATE VIEW view_DD AS SELECT * FROM DD;
       
      CREATE TRIGGER tr1 BEFORE INSERT ON `AA` FOR EACH ROW INSERT INTO `view_A` SELECT * FROM `view_AA` LIMIT 0 ; 
      CREATE TRIGGER tr2 BEFORE INSERT ON `B` FOR EACH ROW INSERT INTO `D` SELECT * FROM `A` LIMIT 0 ; 
       
      INSERT INTO `view_AA` ( `i` ) VALUES (1);
      INSERT INTO `AA` ( `i` ) VALUES (2);
      DELETE FROM `B`;
      INSERT INTO `view_DD` ( `i` ) VALUES (1);
      INSERT INTO `view_AA` ( `i` ) VALUES (3);

      cmake . -DCMAKE_BUILD_TYPE=Debug && make

        Attachments

          Activity

            People

            • Assignee:
              monty Michael Widenius
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: