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

Assertion `join->best_read < double(1.79...15e+308L)' or server crash in JOIN::fix_all_splittings_in_plan

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3(EOL)
    • 10.3.5
    • Optimizer
    • None

    Description

      Note: might be related to MDEV-15017.

      CREATE TABLE t1 (f INT PRIMARY KEY) ENGINE=MyISAM;
      		 
      CREATE VIEW v1 AS SELECT a.* FROM t1 AS a STRAIGHT_JOIN t1 AS b;
      		 
      CREATE VIEW v2 AS SELECT f FROM v1 GROUP BY f;
      		 
      SELECT * FROM v1 JOIN v2 USING (f);

      10.3 ec32c050726 debug

      		 
      mysqld: /data/src/10.3/sql/sql_select.cc:7939: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
      		 
      180122  3:28:40 [ERROR] mysqld got signal 6 ;
      		 
       
      		 
      #7  0x00007f5a78156ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      		 
      #8  0x00005568de26c606 in greedy_search (join=0x7f5a60149db0, remaining_tables=6, search_depth=62, prune_level=1, use_cond_selectivity=1) at /data/src/10.3/sql/sql_select.cc:7939
      		 
      #9  0x00005568de26ba70 in choose_plan (join=0x7f5a60149db0, join_tables=6) at /data/src/10.3/sql/sql_select.cc:7509
      		 
      #10 0x00005568de2647b1 in make_join_statistics (join=0x7f5a60149db0, tables_list=..., keyuse_array=0x7f5a6014a0a0) at /data/src/10.3/sql/sql_select.cc:5008
      		 
      #11 0x00005568de259815 in JOIN::optimize_inner (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1959
      		 
      #12 0x00005568de2580e1 in JOIN::optimize (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1544
      		 
      #13 0x00005568de26189c in mysql_select (thd=0x7f5a60000b00, tables=0x7f5a60014e48, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f5a60149d90, unit=0x7f5a60004890, select_lex=0x7f5a60004fe8) at /data/src/10.3/sql/sql_select.cc:4236
      		 
      #14 0x00005568de25388a in handle_select (thd=0x7f5a60000b00, lex=0x7f5a600047c8, result=0x7f5a60149d90, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
      		 
      #15 0x00005568de21e956 in execute_sqlcom_select (thd=0x7f5a60000b00, all_tables=0x7f5a60014e48) at /data/src/10.3/sql/sql_parse.cc:6524
      		 
      #16 0x00005568de215040 in mysql_execute_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:3745
      		 
      #17 0x00005568de2222aa in mysql_parse (thd=0x7f5a60000b00, rawbuf=0x7f5a60014c38 "SELECT * FROM v1 JOIN v2 USING (f)", length=34, parser_state=0x7f5a723c55f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7981
      		 
      #18 0x00005568de20faef in dispatch_command (command=COM_QUERY, thd=0x7f5a60000b00, packet=0x7f5a6000b141 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
      		 
      #19 0x00005568de20e523 in do_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:1370
      		 
      #20 0x00005568de375768 in do_handle_one_connection (connect=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1401
      		 
      #21 0x00005568de3754f5 in handle_one_connection (arg=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1307
      		 
      #22 0x00005568de8130b8 in pfs_spawn_thread (arg=0x5568e1c896b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      		 
      #23 0x00007f5a79e2d494 in start_thread (arg=0x7f5a723c6700) at pthread_create.c:333
      		 
      #24 0x00007f5a7821393f in clone () from /lib/x86_64-linux-gnu/libc.so.6

      10.3 e15f4af4d non-debug

      		 
      #2  <signal handler called>
      		 
      #3  JOIN::fix_all_splittings_in_plan (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/opt_split.cc:1125
      		 
      #4  0x000055d1e8aa1dd0 in JOIN::get_best_combination (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:9472
      		 
      #5  0x000055d1e8ac25de in JOIN::optimize_stage2 (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1993
      		 
      #6  0x000055d1e8ac5541 in JOIN::optimize_inner (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1972
      		 
      #7  0x000055d1e8ac573f in JOIN::optimize (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1544
      		 
      #8  0x000055d1e8ac7b20 in mysql_select (thd=thd@entry=0x7f60b80009a8, tables=0x7f60b8011770, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f60b80ad838, unit=0x7f60b8004570, select_lex=0x7f60b8004cc8) at /data/src/10.3/sql/sql_select.cc:4236
      		 
      #9  0x000055d1e8ac7ce7 in handle_select (thd=thd@entry=0x7f60b80009a8, lex=lex@entry=0x7f60b80044a8, result=result@entry=0x7f60b80ad838, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.3/sql/sql_select.cc:379
      		 
      #10 0x000055d1e89a9f90 in execute_sqlcom_select (thd=0x7f60b80009a8, all_tables=0x7f60b8011770) at /data/src/10.3/sql/sql_parse.cc:6524
      		 
      #11 0x000055d1e8a75972 in mysql_execute_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:3745
      		 
      #12 0x000055d1e8a77fa9 in mysql_parse (thd=0x7f60b80009a8, rawbuf=<optimized out>, length=34, parser_state=0x7f60c9340630, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_parse.cc:7981
      		 
      #13 0x000055d1e8a7a868 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f60b80009a8, packet=packet@entry=0x7f60b80091f9 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=packet_length@entry=34, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.3/sql/sql_parse.cc:1826
      		 
      #14 0x000055d1e8a7b0ed in do_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:1370
      		 
      #15 0x000055d1e8b4ca94 in do_handle_one_connection (connect=connect@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1401
      		 
      #16 0x000055d1e8b4cc34 in handle_one_connection (arg=arg@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1307
      		 
      #17 0x000055d1e8e43584 in pfs_spawn_thread (arg=0x55d1ec26e488) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      		 
      #18 0x00007f60d0daa494 in start_thread (arg=0x7f60c9341700) at pthread_create.c:333
      		 
      #19 0x00007f60cf19093f in clone () from /lib/x86_64-linux-gnu/libc.so.6

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15017 Server crashes in in st_join_table::fix_splitting

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            elenst Elena Stepanova created issue -
            elenst Elena Stepanova made changes -
            Field Original Value New Value
            Description All similar bug reports are closed at the moment, but the problem exists.

            https://api.travis-ci.org/v3/job/329539116/log.txt
            {noformat:title=bb-10.3-temporal 755367d6b43fb60705d21c7435f2f1cdebab81c8}
            mysqld: /home/travis/src/sql/sql_select.cc:7939: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
            180118 7:06:26 [ERROR] mysqld got signal 6 ;

            Some pointers may be invalid and cause the dump to abort.
            Query (0x7f618001f9e8): SELECT alias1.`col_datetime` AS field1 FROM B AS alias1 LEFT JOIN G AS alias2 ON alias1.`col_int` = alias2.`col_int_key` RIGHT JOIN C AS alias3 LEFT JOIN E AS alias4 RIGHT JOIN view_A AS alias5 ON alias4.`pk` = alias5.`pk` RIGHT JOIN E AS alias6 ON alias5.`pk` = alias6.`pk` LEFT OUTER JOIN G AS alias7 ON alias5.`col_int_key` = alias7.`pk` LEFT JOIN view_F AS alias8 ON alias7.`pk` = alias8.`pk` RIGHT JOIN view_A AS alias9 ON alias7.`col_int_key` = alias9.`col_int_key` LEFT JOIN H AS alias10 RIGHT JOIN view_F AS alias11 ON alias10.`col_int_key` = alias11.`pk` ON alias4.`col_int_key` = alias10.`col_int_key` ON alias3.`pk` = alias7.`col_int_key` ON alias2.`col_varchar_10_latin1` = alias6.`col_varchar_10_utf8_key` LEFT OUTER JOIN view_G AS alias12 RIGHT JOIN view_E AS alias13 ON alias12.`pk` = alias13.`col_int_key` ON alias4.`col_varchar_1024_utf8_key` = alias13.`col_varchar_1024_latin1_key` WHERE alias4.`col_varchar_10_latin1_key` NOT IN ('z', 'b') OR alias8.`col_varchar_1024_utf8_key` >= 'y' AND alias8.`col_varchar_1024_utf8_key` <= 'z' /* QNO 30839 CON_ID 19 */
            Connection ID (thread ID): 19
            Status: NOT_KILLED
            {noformat}
            {noformat}
            Thread 1 (Thread 0x7f61d0057700 (LWP 7515)):
            #0 0x00007f61d399e611 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
            #1 0x0000564d6c20ddad in my_write_core (sig=6) at /home/travis/src/mysys/stacktrace.c:481
            #2 0x0000564d6ba29ab8 in handle_fatal_signal (sig=6) at /home/travis/src/sql/signal_handler.cc:305
            #3 <signal handler called>
            #4 0x00007f61d2ddec37 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
            #5 0x00007f61d2de2028 in __GI_abort () at abort.c:89
            #6 0x00007f61d2dd7bf6 in __assert_fail_base (fmt=0x7f61d2f2c058 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x564d6c2dc060 "join->best_read < double(1.79769313486231570815e+308L)", file=file@entry=0x564d6c2db3b0 "/home/travis/src/sql/sql_select.cc", line=line@entry=7939, function=function@entry=0x564d6c2de8e0 <greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int)::__PRETTY_FUNCTION__> "bool greedy_search(JOIN*, table_map, uint, uint, uint)") at assert.c:92
            #7 0x00007f61d2dd7ca2 in __GI___assert_fail (assertion=0x564d6c2dc060 "join->best_read < double(1.79769313486231570815e+308L)", file=0x564d6c2db3b0 "/home/travis/src/sql/sql_select.cc", line=7939, function=0x564d6c2de8e0 <greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int)::__PRETTY_FUNCTION__> "bool greedy_search(JOIN*, table_map, uint, uint, uint)") at assert.c:101
            #8 0x0000564d6b796134 in greedy_search (join=0x7f6180261ed0, remaining_tables=8191, search_depth=62, prune_level=1, use_cond_selectivity=1) at /home/travis/src/sql/sql_select.cc:7939
            #9 0x0000564d6b7955a8 in choose_plan (join=0x7f6180261ed0, join_tables=8191) at /home/travis/src/sql/sql_select.cc:7509
            #10 0x0000564d6b78e35c in make_join_statistics (join=0x7f6180261ed0, tables_list=..., keyuse_array=0x7f61802621c0) at /home/travis/src/sql/sql_select.cc:5008
            #11 0x0000564d6b7833bb in JOIN::optimize_inner (this=0x7f6180261ed0) at /home/travis/src/sql/sql_select.cc:1959
            #12 0x0000564d6b781c9f in JOIN::optimize (this=0x7f6180261ed0) at /home/travis/src/sql/sql_select.cc:1544
            #13 0x0000564d6b78b44d in mysql_select (thd=0x7f618000b430, tables=0x7f6180020478, wild_num=0, fields=..., conds=0x7f61801a42d8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7f6180261eb0, unit=0x7f618000f1c0, select_lex=0x7f618000f918) at /home/travis/src/sql/sql_select.cc:4236
            #14 0x0000564d6b77d432 in handle_select (thd=0x7f618000b430, lex=0x7f618000f0f8, result=0x7f6180261eb0, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:379
            #15 0x0000564d6b748532 in execute_sqlcom_select (thd=0x7f618000b430, all_tables=0x7f6180020478) at /home/travis/src/sql/sql_parse.cc:6536
            #16 0x0000564d6b73eb5a in mysql_execute_command (thd=0x7f618000b430) at /home/travis/src/sql/sql_parse.cc:3750
            #17 0x0000564d6b74be53 in mysql_parse (thd=0x7f618000b430, rawbuf=0x7f618001f9e8 "SELECT alias1.`col_datetime` AS field1 FROM B AS alias1 LEFT JOIN G AS alias2 ON alias1.`col_int` = alias2.`col_int_key` RIGHT JOIN C AS alias3 LEFT JOIN E AS alias4 RIGHT JOIN view_A AS alias5 ON ali"..., length=1076, parser_state=0x7f61d0056600, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7993
            #18 0x0000564d6b739627 in dispatch_command (command=COM_QUERY, thd=0x7f618000b430, packet=0x7f61800176d1 " SELECT alias1.`col_datetime` AS field1 FROM B AS alias1 LEFT JOIN G AS alias2 ON alias1.`col_int` = alias2.`col_int_key` RIGHT JOIN C AS alias3 LEFT JOIN E AS alias4 RIGHT JOIN view_A AS alias5 ON al"..., packet_length=1078, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1826
            #19 0x0000564d6b738067 in do_command (thd=0x7f618000b430) at /home/travis/src/sql/sql_parse.cc:1370
            #20 0x0000564d6b89ff24 in do_handle_one_connection (connect=0x564d6f862640) at /home/travis/src/sql/sql_connect.cc:1401
            #21 0x0000564d6b89fcb1 in handle_one_connection (arg=0x564d6f862640) at /home/travis/src/sql/sql_connect.cc:1307
            #22 0x00007f61d3999184 in start_thread (arg=0x7f61d0057700) at pthread_create.c:312
            #23 0x00007f61d2ea603d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
            {noformat}
            		All similar bug reports are closed at the moment, but the problem exists.

            https://api.travis-ci.org/v3/job/329539116/log.txt
            {noformat:title=bb-10.3-temporal 755367d6b43fb60705d21c7435f2f1cdebab81c8}
            mysqld: /home/travis/src/sql/sql_select.cc:7939: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
            180118 7:06:26 [ERROR] mysqld got signal 6 ;

            Some pointers may be invalid and cause the dump to abort.
            Query (0x7f618001f9e8): SELECT alias1.`col_datetime` AS field1 FROM B AS alias1 LEFT JOIN G AS alias2 ON alias1.`col_int` = alias2.`col_int_key` RIGHT JOIN C AS alias3 LEFT JOIN E AS alias4 RIGHT JOIN view_A AS alias5 ON alias4.`pk` = alias5.`pk` RIGHT JOIN E AS alias6 ON alias5.`pk` = alias6.`pk` LEFT OUTER JOIN G AS alias7 ON alias5.`col_int_key` = alias7.`pk` LEFT JOIN view_F AS alias8 ON alias7.`pk` = alias8.`pk` RIGHT JOIN view_A AS alias9 ON alias7.`col_int_key` = alias9.`col_int_key` LEFT JOIN H AS alias10 RIGHT JOIN view_F AS alias11 ON alias10.`col_int_key` = alias11.`pk` ON alias4.`col_int_key` = alias10.`col_int_key` ON alias3.`pk` = alias7.`col_int_key` ON alias2.`col_varchar_10_latin1` = alias6.`col_varchar_10_utf8_key` LEFT OUTER JOIN view_G AS alias12 RIGHT JOIN view_E AS alias13 ON alias12.`pk` = alias13.`col_int_key` ON alias4.`col_varchar_1024_utf8_key` = alias13.`col_varchar_1024_latin1_key` WHERE alias4.`col_varchar_10_latin1_key` NOT IN ('z', 'b') OR alias8.`col_varchar_1024_utf8_key` >= 'y' AND alias8.`col_varchar_1024_utf8_key` <= 'z' /* QNO 30839 CON_ID 19 */
            Connection ID (thread ID): 19
            Status: NOT_KILLED
            {noformat}
            {noformat}
            Thread 1 (Thread 0x7f61d0057700 (LWP 7515)):
            #0 0x00007f61d399e611 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
            #1 0x0000564d6c20ddad in my_write_core (sig=6) at /home/travis/src/mysys/stacktrace.c:481
            #2 0x0000564d6ba29ab8 in handle_fatal_signal (sig=6) at /home/travis/src/sql/signal_handler.cc:305
            #3 <signal handler called>
            #4 0x00007f61d2ddec37 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
            #5 0x00007f61d2de2028 in __GI_abort () at abort.c:89
            #6 0x00007f61d2dd7bf6 in __assert_fail_base (fmt=0x7f61d2f2c058 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x564d6c2dc060 "join->best_read < double(1.79769313486231570815e+308L)", file=file@entry=0x564d6c2db3b0 "/home/travis/src/sql/sql_select.cc", line=line@entry=7939, function=function@entry=0x564d6c2de8e0 <greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int)::__PRETTY_FUNCTION__> "bool greedy_search(JOIN*, table_map, uint, uint, uint)") at assert.c:92
            #7 0x00007f61d2dd7ca2 in __GI___assert_fail (assertion=0x564d6c2dc060 "join->best_read < double(1.79769313486231570815e+308L)", file=0x564d6c2db3b0 "/home/travis/src/sql/sql_select.cc", line=7939, function=0x564d6c2de8e0 <greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int)::__PRETTY_FUNCTION__> "bool greedy_search(JOIN*, table_map, uint, uint, uint)") at assert.c:101
            #8 0x0000564d6b796134 in greedy_search (join=0x7f6180261ed0, remaining_tables=8191, search_depth=62, prune_level=1, use_cond_selectivity=1) at /home/travis/src/sql/sql_select.cc:7939
            #9 0x0000564d6b7955a8 in choose_plan (join=0x7f6180261ed0, join_tables=8191) at /home/travis/src/sql/sql_select.cc:7509
            #10 0x0000564d6b78e35c in make_join_statistics (join=0x7f6180261ed0, tables_list=..., keyuse_array=0x7f61802621c0) at /home/travis/src/sql/sql_select.cc:5008
            #11 0x0000564d6b7833bb in JOIN::optimize_inner (this=0x7f6180261ed0) at /home/travis/src/sql/sql_select.cc:1959
            #12 0x0000564d6b781c9f in JOIN::optimize (this=0x7f6180261ed0) at /home/travis/src/sql/sql_select.cc:1544
            #13 0x0000564d6b78b44d in mysql_select (thd=0x7f618000b430, tables=0x7f6180020478, wild_num=0, fields=..., conds=0x7f61801a42d8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7f6180261eb0, unit=0x7f618000f1c0, select_lex=0x7f618000f918) at /home/travis/src/sql/sql_select.cc:4236
            #14 0x0000564d6b77d432 in handle_select (thd=0x7f618000b430, lex=0x7f618000f0f8, result=0x7f6180261eb0, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:379
            #15 0x0000564d6b748532 in execute_sqlcom_select (thd=0x7f618000b430, all_tables=0x7f6180020478) at /home/travis/src/sql/sql_parse.cc:6536
            #16 0x0000564d6b73eb5a in mysql_execute_command (thd=0x7f618000b430) at /home/travis/src/sql/sql_parse.cc:3750
            #17 0x0000564d6b74be53 in mysql_parse (thd=0x7f618000b430, rawbuf=0x7f618001f9e8 "SELECT alias1.`col_datetime` AS field1 FROM B AS alias1 LEFT JOIN G AS alias2 ON alias1.`col_int` = alias2.`col_int_key` RIGHT JOIN C AS alias3 LEFT JOIN E AS alias4 RIGHT JOIN view_A AS alias5 ON ali"..., length=1076, parser_state=0x7f61d0056600, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7993
            #18 0x0000564d6b739627 in dispatch_command (command=COM_QUERY, thd=0x7f618000b430, packet=0x7f61800176d1 " SELECT alias1.`col_datetime` AS field1 FROM B AS alias1 LEFT JOIN G AS alias2 ON alias1.`col_int` = alias2.`col_int_key` RIGHT JOIN C AS alias3 LEFT JOIN E AS alias4 RIGHT JOIN view_A AS alias5 ON al"..., packet_length=1078, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1826
            #19 0x0000564d6b738067 in do_command (thd=0x7f618000b430) at /home/travis/src/sql/sql_parse.cc:1370
            #20 0x0000564d6b89ff24 in do_handle_one_connection (connect=0x564d6f862640) at /home/travis/src/sql/sql_connect.cc:1401
            #21 0x0000564d6b89fcb1 in handle_one_connection (arg=0x564d6f862640) at /home/travis/src/sql/sql_connect.cc:1307
            #22 0x00007f61d3999184 in start_thread (arg=0x7f61d0057700) at pthread_create.c:312
            #23 0x00007f61d2ea603d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
            {noformat}

            {noformat:title=experimental ca750c313df92ab38a8f6a26d5dc865675851719}
            perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1516258924 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --debug --grammar=conf/optimizer/range_access.yy --gendata=conf/optimizer/range_access.zz --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/home/travis/logs/vardir1_3
            {noformat}
            elenst Elena Stepanova made changes -
            Affects Version/s N/A [ 14700 ]
            elenst Elena Stepanova made changes -
            elenst Elena Stepanova made changes -
            Component/s Optimizer [ 10200 ]
            Fix Version/s 10.3 [ 22126 ]
            Affects Version/s 10.3 [ 22126 ]
            Affects Version/s N/A [ 14700 ]
            Description All similar bug reports are closed at the moment, but the problem exists.

            https://api.travis-ci.org/v3/job/329539116/log.txt
            {noformat:title=bb-10.3-temporal 755367d6b43fb60705d21c7435f2f1cdebab81c8}
            mysqld: /home/travis/src/sql/sql_select.cc:7939: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
            180118 7:06:26 [ERROR] mysqld got signal 6 ;

            Some pointers may be invalid and cause the dump to abort.
            Query (0x7f618001f9e8): SELECT alias1.`col_datetime` AS field1 FROM B AS alias1 LEFT JOIN G AS alias2 ON alias1.`col_int` = alias2.`col_int_key` RIGHT JOIN C AS alias3 LEFT JOIN E AS alias4 RIGHT JOIN view_A AS alias5 ON alias4.`pk` = alias5.`pk` RIGHT JOIN E AS alias6 ON alias5.`pk` = alias6.`pk` LEFT OUTER JOIN G AS alias7 ON alias5.`col_int_key` = alias7.`pk` LEFT JOIN view_F AS alias8 ON alias7.`pk` = alias8.`pk` RIGHT JOIN view_A AS alias9 ON alias7.`col_int_key` = alias9.`col_int_key` LEFT JOIN H AS alias10 RIGHT JOIN view_F AS alias11 ON alias10.`col_int_key` = alias11.`pk` ON alias4.`col_int_key` = alias10.`col_int_key` ON alias3.`pk` = alias7.`col_int_key` ON alias2.`col_varchar_10_latin1` = alias6.`col_varchar_10_utf8_key` LEFT OUTER JOIN view_G AS alias12 RIGHT JOIN view_E AS alias13 ON alias12.`pk` = alias13.`col_int_key` ON alias4.`col_varchar_1024_utf8_key` = alias13.`col_varchar_1024_latin1_key` WHERE alias4.`col_varchar_10_latin1_key` NOT IN ('z', 'b') OR alias8.`col_varchar_1024_utf8_key` >= 'y' AND alias8.`col_varchar_1024_utf8_key` <= 'z' /* QNO 30839 CON_ID 19 */
            Connection ID (thread ID): 19
            Status: NOT_KILLED
            {noformat}
            {noformat}
            Thread 1 (Thread 0x7f61d0057700 (LWP 7515)):
            #0 0x00007f61d399e611 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
            #1 0x0000564d6c20ddad in my_write_core (sig=6) at /home/travis/src/mysys/stacktrace.c:481
            #2 0x0000564d6ba29ab8 in handle_fatal_signal (sig=6) at /home/travis/src/sql/signal_handler.cc:305
            #3 <signal handler called>
            #4 0x00007f61d2ddec37 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
            #5 0x00007f61d2de2028 in __GI_abort () at abort.c:89
            #6 0x00007f61d2dd7bf6 in __assert_fail_base (fmt=0x7f61d2f2c058 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x564d6c2dc060 "join->best_read < double(1.79769313486231570815e+308L)", file=file@entry=0x564d6c2db3b0 "/home/travis/src/sql/sql_select.cc", line=line@entry=7939, function=function@entry=0x564d6c2de8e0 <greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int)::__PRETTY_FUNCTION__> "bool greedy_search(JOIN*, table_map, uint, uint, uint)") at assert.c:92
            #7 0x00007f61d2dd7ca2 in __GI___assert_fail (assertion=0x564d6c2dc060 "join->best_read < double(1.79769313486231570815e+308L)", file=0x564d6c2db3b0 "/home/travis/src/sql/sql_select.cc", line=7939, function=0x564d6c2de8e0 <greedy_search(JOIN*, unsigned long long, unsigned int, unsigned int, unsigned int)::__PRETTY_FUNCTION__> "bool greedy_search(JOIN*, table_map, uint, uint, uint)") at assert.c:101
            #8 0x0000564d6b796134 in greedy_search (join=0x7f6180261ed0, remaining_tables=8191, search_depth=62, prune_level=1, use_cond_selectivity=1) at /home/travis/src/sql/sql_select.cc:7939
            #9 0x0000564d6b7955a8 in choose_plan (join=0x7f6180261ed0, join_tables=8191) at /home/travis/src/sql/sql_select.cc:7509
            #10 0x0000564d6b78e35c in make_join_statistics (join=0x7f6180261ed0, tables_list=..., keyuse_array=0x7f61802621c0) at /home/travis/src/sql/sql_select.cc:5008
            #11 0x0000564d6b7833bb in JOIN::optimize_inner (this=0x7f6180261ed0) at /home/travis/src/sql/sql_select.cc:1959
            #12 0x0000564d6b781c9f in JOIN::optimize (this=0x7f6180261ed0) at /home/travis/src/sql/sql_select.cc:1544
            #13 0x0000564d6b78b44d in mysql_select (thd=0x7f618000b430, tables=0x7f6180020478, wild_num=0, fields=..., conds=0x7f61801a42d8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=551903562496, result=0x7f6180261eb0, unit=0x7f618000f1c0, select_lex=0x7f618000f918) at /home/travis/src/sql/sql_select.cc:4236
            #14 0x0000564d6b77d432 in handle_select (thd=0x7f618000b430, lex=0x7f618000f0f8, result=0x7f6180261eb0, setup_tables_done_option=0) at /home/travis/src/sql/sql_select.cc:379
            #15 0x0000564d6b748532 in execute_sqlcom_select (thd=0x7f618000b430, all_tables=0x7f6180020478) at /home/travis/src/sql/sql_parse.cc:6536
            #16 0x0000564d6b73eb5a in mysql_execute_command (thd=0x7f618000b430) at /home/travis/src/sql/sql_parse.cc:3750
            #17 0x0000564d6b74be53 in mysql_parse (thd=0x7f618000b430, rawbuf=0x7f618001f9e8 "SELECT alias1.`col_datetime` AS field1 FROM B AS alias1 LEFT JOIN G AS alias2 ON alias1.`col_int` = alias2.`col_int_key` RIGHT JOIN C AS alias3 LEFT JOIN E AS alias4 RIGHT JOIN view_A AS alias5 ON ali"..., length=1076, parser_state=0x7f61d0056600, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:7993
            #18 0x0000564d6b739627 in dispatch_command (command=COM_QUERY, thd=0x7f618000b430, packet=0x7f61800176d1 " SELECT alias1.`col_datetime` AS field1 FROM B AS alias1 LEFT JOIN G AS alias2 ON alias1.`col_int` = alias2.`col_int_key` RIGHT JOIN C AS alias3 LEFT JOIN E AS alias4 RIGHT JOIN view_A AS alias5 ON al"..., packet_length=1078, is_com_multi=false, is_next_command=false) at /home/travis/src/sql/sql_parse.cc:1826
            #19 0x0000564d6b738067 in do_command (thd=0x7f618000b430) at /home/travis/src/sql/sql_parse.cc:1370
            #20 0x0000564d6b89ff24 in do_handle_one_connection (connect=0x564d6f862640) at /home/travis/src/sql/sql_connect.cc:1401
            #21 0x0000564d6b89fcb1 in handle_one_connection (arg=0x564d6f862640) at /home/travis/src/sql/sql_connect.cc:1307
            #22 0x00007f61d3999184 in start_thread (arg=0x7f61d0057700) at pthread_create.c:312
            #23 0x00007f61d2ea603d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
            {noformat}

            {noformat:title=experimental ca750c313df92ab38a8f6a26d5dc865675851719}
            perl /home/travis/rqg/runall-new.pl --duration=350 --threads=6 --seed=1516258924 --reporters=Backtrace,ErrorLog,Deadlock --validators=TransformerNoComparator --transformers=ConvertSubqueriesToViews,ConvertTablesToDerived,Count,DisableOptimizations,Distinct,EnableOptimizations,ExecuteAsCTE,ExecuteAsDeleteReturning,ExecuteAsDerived,ExecuteAsExcept,ExecuteAsExecuteImmediate,ExecuteAsInsertSelect,ExecuteAsIntersect,ExecuteAsSelectItem,ExecuteAsUnion,ExecuteAsUpdateDelete,ExecuteAsView,ExecuteAsWhereSubquery,Having,InlineSubqueries,InlineVirtualColumns,LimitRowsExamined,OrderBy,StraightJoin,ExecuteAsPreparedTwice,ExecuteAsTrigger,ExecuteAsSPTwice,ExecuteAsFunctionTwice --redefine=conf/mariadb/general-workarounds.yy --mysqld=--log_output=FILE --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin --mysqld=--max-statement-time=30 --mysqld=--loose-debug_assert_on_not_freed_memory=0 --views --redefine=conf/mariadb/versioning.yy --basedir=/home/travis/server --debug --grammar=conf/optimizer/range_access.yy --gendata=conf/optimizer/range_access.zz --engine=MyISAM --mysqld=--default-storage-engine=MyISAM --vardir=/home/travis/logs/vardir1_3
            {noformat}             		_Note: might be related to MDEV-14994._

            {code:sql}
            CREATE TABLE t1 (f INT PRIMARY KEY);
            CREATE VIEW v1 AS SELECT a.* FROM t1 AS a STRAIGHT_JOIN t1 AS b;
            CREATE VIEW v2 AS SELECT f FROM v1 GROUP BY f;
            SELECT * FROM v1 JOIN v2 USING (f);
            {code}

            {noformat:title=10.3 ec32c050726 debug}
            mysqld: /data/src/10.3/sql/sql_select.cc:7939: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
            180122 3:28:40 [ERROR] mysqld got signal 6 ;

            #7 0x00007f5a78156ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
            #8 0x00005568de26c606 in greedy_search (join=0x7f5a60149db0, remaining_tables=6, search_depth=62, prune_level=1, use_cond_selectivity=1) at /data/src/10.3/sql/sql_select.cc:7939
            #9 0x00005568de26ba70 in choose_plan (join=0x7f5a60149db0, join_tables=6) at /data/src/10.3/sql/sql_select.cc:7509
            #10 0x00005568de2647b1 in make_join_statistics (join=0x7f5a60149db0, tables_list=..., keyuse_array=0x7f5a6014a0a0) at /data/src/10.3/sql/sql_select.cc:5008
            #11 0x00005568de259815 in JOIN::optimize_inner (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1959
            #12 0x00005568de2580e1 in JOIN::optimize (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1544
            #13 0x00005568de26189c in mysql_select (thd=0x7f5a60000b00, tables=0x7f5a60014e48, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f5a60149d90, unit=0x7f5a60004890, select_lex=0x7f5a60004fe8) at /data/src/10.3/sql/sql_select.cc:4236
            #14 0x00005568de25388a in handle_select (thd=0x7f5a60000b00, lex=0x7f5a600047c8, result=0x7f5a60149d90, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
            #15 0x00005568de21e956 in execute_sqlcom_select (thd=0x7f5a60000b00, all_tables=0x7f5a60014e48) at /data/src/10.3/sql/sql_parse.cc:6524
            #16 0x00005568de215040 in mysql_execute_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:3745
            #17 0x00005568de2222aa in mysql_parse (thd=0x7f5a60000b00, rawbuf=0x7f5a60014c38 "SELECT * FROM v1 JOIN v2 USING (f)", length=34, parser_state=0x7f5a723c55f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7981
            #18 0x00005568de20faef in dispatch_command (command=COM_QUERY, thd=0x7f5a60000b00, packet=0x7f5a6000b141 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
            #19 0x00005568de20e523 in do_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:1370
            #20 0x00005568de375768 in do_handle_one_connection (connect=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1401
            #21 0x00005568de3754f5 in handle_one_connection (arg=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1307
            #22 0x00005568de8130b8 in pfs_spawn_thread (arg=0x5568e1c896b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #23 0x00007f5a79e2d494 in start_thread (arg=0x7f5a723c6700) at pthread_create.c:333
            #24 0x00007f5a7821393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            {noformat}

            {noformat:title=10.3 e15f4af4d non-debug}
            #2 <signal handler called>
            #3 JOIN::fix_all_splittings_in_plan (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/opt_split.cc:1125
            #4 0x000055d1e8aa1dd0 in JOIN::get_best_combination (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:9472
            #5 0x000055d1e8ac25de in JOIN::optimize_stage2 (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1993
            #6 0x000055d1e8ac5541 in JOIN::optimize_inner (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1972
            #7 0x000055d1e8ac573f in JOIN::optimize (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1544
            #8 0x000055d1e8ac7b20 in mysql_select (thd=thd@entry=0x7f60b80009a8, tables=0x7f60b8011770, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f60b80ad838, unit=0x7f60b8004570, select_lex=0x7f60b8004cc8) at /data/src/10.3/sql/sql_select.cc:4236
            #9 0x000055d1e8ac7ce7 in handle_select (thd=thd@entry=0x7f60b80009a8, lex=lex@entry=0x7f60b80044a8, result=result@entry=0x7f60b80ad838, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.3/sql/sql_select.cc:379
            #10 0x000055d1e89a9f90 in execute_sqlcom_select (thd=0x7f60b80009a8, all_tables=0x7f60b8011770) at /data/src/10.3/sql/sql_parse.cc:6524
            #11 0x000055d1e8a75972 in mysql_execute_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:3745
            #12 0x000055d1e8a77fa9 in mysql_parse (thd=0x7f60b80009a8, rawbuf=<optimized out>, length=34, parser_state=0x7f60c9340630, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_parse.cc:7981
            #13 0x000055d1e8a7a868 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f60b80009a8, packet=packet@entry=0x7f60b80091f9 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=packet_length@entry=34, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.3/sql/sql_parse.cc:1826
            #14 0x000055d1e8a7b0ed in do_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:1370
            #15 0x000055d1e8b4ca94 in do_handle_one_connection (connect=connect@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1401
            #16 0x000055d1e8b4cc34 in handle_one_connection (arg=arg@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1307
            #17 0x000055d1e8e43584 in pfs_spawn_thread (arg=0x55d1ec26e488) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #18 0x00007f60d0daa494 in start_thread (arg=0x7f60c9341700) at pthread_create.c:333
            #19 0x00007f60cf19093f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            {noformat}
            Summary [Draft] Assertion `join->best_read < double(1.79...+308L)' failed in greedy_search Server crash in JOIN::fix_all_splittings_in_plan
            elenst Elena Stepanova made changes -
            Summary Server crash in JOIN::fix_all_splittings_in_plan Assertion `join->best_read < double(1.79...15e+308L)' or server crash in JOIN::fix_all_splittings_in_plan
            elenst Elena Stepanova made changes -
            Assignee Elena Stepanova [ elenst ] Alice Sherepa [ alice ]
            alice Alice Sherepa added a comment -

            reproducible with MyISAM, not with InnoDB, after commit c5ac1f953bf6d4279967f03a8343303f715ad7aa

            alice Alice Sherepa added a comment - reproducible with MyISAM, not with InnoDB, after commit c5ac1f953bf6d4279967f03a8343303f715ad7aa
            alice Alice Sherepa made changes -
            Description _Note: might be related to MDEV-14994._

            {code:sql}
            CREATE TABLE t1 (f INT PRIMARY KEY);
            CREATE VIEW v1 AS SELECT a.* FROM t1 AS a STRAIGHT_JOIN t1 AS b;
            CREATE VIEW v2 AS SELECT f FROM v1 GROUP BY f;
            SELECT * FROM v1 JOIN v2 USING (f);
            {code}

            {noformat:title=10.3 ec32c050726 debug}
            mysqld: /data/src/10.3/sql/sql_select.cc:7939: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
            180122 3:28:40 [ERROR] mysqld got signal 6 ;

            #7 0x00007f5a78156ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
            #8 0x00005568de26c606 in greedy_search (join=0x7f5a60149db0, remaining_tables=6, search_depth=62, prune_level=1, use_cond_selectivity=1) at /data/src/10.3/sql/sql_select.cc:7939
            #9 0x00005568de26ba70 in choose_plan (join=0x7f5a60149db0, join_tables=6) at /data/src/10.3/sql/sql_select.cc:7509
            #10 0x00005568de2647b1 in make_join_statistics (join=0x7f5a60149db0, tables_list=..., keyuse_array=0x7f5a6014a0a0) at /data/src/10.3/sql/sql_select.cc:5008
            #11 0x00005568de259815 in JOIN::optimize_inner (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1959
            #12 0x00005568de2580e1 in JOIN::optimize (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1544
            #13 0x00005568de26189c in mysql_select (thd=0x7f5a60000b00, tables=0x7f5a60014e48, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f5a60149d90, unit=0x7f5a60004890, select_lex=0x7f5a60004fe8) at /data/src/10.3/sql/sql_select.cc:4236
            #14 0x00005568de25388a in handle_select (thd=0x7f5a60000b00, lex=0x7f5a600047c8, result=0x7f5a60149d90, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
            #15 0x00005568de21e956 in execute_sqlcom_select (thd=0x7f5a60000b00, all_tables=0x7f5a60014e48) at /data/src/10.3/sql/sql_parse.cc:6524
            #16 0x00005568de215040 in mysql_execute_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:3745
            #17 0x00005568de2222aa in mysql_parse (thd=0x7f5a60000b00, rawbuf=0x7f5a60014c38 "SELECT * FROM v1 JOIN v2 USING (f)", length=34, parser_state=0x7f5a723c55f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7981
            #18 0x00005568de20faef in dispatch_command (command=COM_QUERY, thd=0x7f5a60000b00, packet=0x7f5a6000b141 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
            #19 0x00005568de20e523 in do_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:1370
            #20 0x00005568de375768 in do_handle_one_connection (connect=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1401
            #21 0x00005568de3754f5 in handle_one_connection (arg=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1307
            #22 0x00005568de8130b8 in pfs_spawn_thread (arg=0x5568e1c896b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #23 0x00007f5a79e2d494 in start_thread (arg=0x7f5a723c6700) at pthread_create.c:333
            #24 0x00007f5a7821393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            {noformat}

            {noformat:title=10.3 e15f4af4d non-debug}
            #2 <signal handler called>
            #3 JOIN::fix_all_splittings_in_plan (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/opt_split.cc:1125
            #4 0x000055d1e8aa1dd0 in JOIN::get_best_combination (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:9472
            #5 0x000055d1e8ac25de in JOIN::optimize_stage2 (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1993
            #6 0x000055d1e8ac5541 in JOIN::optimize_inner (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1972
            #7 0x000055d1e8ac573f in JOIN::optimize (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1544
            #8 0x000055d1e8ac7b20 in mysql_select (thd=thd@entry=0x7f60b80009a8, tables=0x7f60b8011770, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f60b80ad838, unit=0x7f60b8004570, select_lex=0x7f60b8004cc8) at /data/src/10.3/sql/sql_select.cc:4236
            #9 0x000055d1e8ac7ce7 in handle_select (thd=thd@entry=0x7f60b80009a8, lex=lex@entry=0x7f60b80044a8, result=result@entry=0x7f60b80ad838, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.3/sql/sql_select.cc:379
            #10 0x000055d1e89a9f90 in execute_sqlcom_select (thd=0x7f60b80009a8, all_tables=0x7f60b8011770) at /data/src/10.3/sql/sql_parse.cc:6524
            #11 0x000055d1e8a75972 in mysql_execute_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:3745
            #12 0x000055d1e8a77fa9 in mysql_parse (thd=0x7f60b80009a8, rawbuf=<optimized out>, length=34, parser_state=0x7f60c9340630, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_parse.cc:7981
            #13 0x000055d1e8a7a868 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f60b80009a8, packet=packet@entry=0x7f60b80091f9 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=packet_length@entry=34, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.3/sql/sql_parse.cc:1826
            #14 0x000055d1e8a7b0ed in do_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:1370
            #15 0x000055d1e8b4ca94 in do_handle_one_connection (connect=connect@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1401
            #16 0x000055d1e8b4cc34 in handle_one_connection (arg=arg@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1307
            #17 0x000055d1e8e43584 in pfs_spawn_thread (arg=0x55d1ec26e488) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #18 0x00007f60d0daa494 in start_thread (arg=0x7f60c9341700) at pthread_create.c:333
            #19 0x00007f60cf19093f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            {noformat}             		_Note: might be related to MDEV-15017._

            {code:sql}
            CREATE TABLE t1 (f INT PRIMARY KEY);
            CREATE VIEW v1 AS SELECT a.* FROM t1 AS a STRAIGHT_JOIN t1 AS b;
            CREATE VIEW v2 AS SELECT f FROM v1 GROUP BY f;
            SELECT * FROM v1 JOIN v2 USING (f);
            {code}

            {noformat:title=10.3 ec32c050726 debug}
            mysqld: /data/src/10.3/sql/sql_select.cc:7939: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
            180122 3:28:40 [ERROR] mysqld got signal 6 ;

            #7 0x00007f5a78156ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
            #8 0x00005568de26c606 in greedy_search (join=0x7f5a60149db0, remaining_tables=6, search_depth=62, prune_level=1, use_cond_selectivity=1) at /data/src/10.3/sql/sql_select.cc:7939
            #9 0x00005568de26ba70 in choose_plan (join=0x7f5a60149db0, join_tables=6) at /data/src/10.3/sql/sql_select.cc:7509
            #10 0x00005568de2647b1 in make_join_statistics (join=0x7f5a60149db0, tables_list=..., keyuse_array=0x7f5a6014a0a0) at /data/src/10.3/sql/sql_select.cc:5008
            #11 0x00005568de259815 in JOIN::optimize_inner (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1959
            #12 0x00005568de2580e1 in JOIN::optimize (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1544
            #13 0x00005568de26189c in mysql_select (thd=0x7f5a60000b00, tables=0x7f5a60014e48, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f5a60149d90, unit=0x7f5a60004890, select_lex=0x7f5a60004fe8) at /data/src/10.3/sql/sql_select.cc:4236
            #14 0x00005568de25388a in handle_select (thd=0x7f5a60000b00, lex=0x7f5a600047c8, result=0x7f5a60149d90, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
            #15 0x00005568de21e956 in execute_sqlcom_select (thd=0x7f5a60000b00, all_tables=0x7f5a60014e48) at /data/src/10.3/sql/sql_parse.cc:6524
            #16 0x00005568de215040 in mysql_execute_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:3745
            #17 0x00005568de2222aa in mysql_parse (thd=0x7f5a60000b00, rawbuf=0x7f5a60014c38 "SELECT * FROM v1 JOIN v2 USING (f)", length=34, parser_state=0x7f5a723c55f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7981
            #18 0x00005568de20faef in dispatch_command (command=COM_QUERY, thd=0x7f5a60000b00, packet=0x7f5a6000b141 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
            #19 0x00005568de20e523 in do_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:1370
            #20 0x00005568de375768 in do_handle_one_connection (connect=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1401
            #21 0x00005568de3754f5 in handle_one_connection (arg=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1307
            #22 0x00005568de8130b8 in pfs_spawn_thread (arg=0x5568e1c896b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #23 0x00007f5a79e2d494 in start_thread (arg=0x7f5a723c6700) at pthread_create.c:333
            #24 0x00007f5a7821393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            {noformat}

            {noformat:title=10.3 e15f4af4d non-debug}
            #2 <signal handler called>
            #3 JOIN::fix_all_splittings_in_plan (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/opt_split.cc:1125
            #4 0x000055d1e8aa1dd0 in JOIN::get_best_combination (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:9472
            #5 0x000055d1e8ac25de in JOIN::optimize_stage2 (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1993
            #6 0x000055d1e8ac5541 in JOIN::optimize_inner (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1972
            #7 0x000055d1e8ac573f in JOIN::optimize (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1544
            #8 0x000055d1e8ac7b20 in mysql_select (thd=thd@entry=0x7f60b80009a8, tables=0x7f60b8011770, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f60b80ad838, unit=0x7f60b8004570, select_lex=0x7f60b8004cc8) at /data/src/10.3/sql/sql_select.cc:4236
            #9 0x000055d1e8ac7ce7 in handle_select (thd=thd@entry=0x7f60b80009a8, lex=lex@entry=0x7f60b80044a8, result=result@entry=0x7f60b80ad838, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.3/sql/sql_select.cc:379
            #10 0x000055d1e89a9f90 in execute_sqlcom_select (thd=0x7f60b80009a8, all_tables=0x7f60b8011770) at /data/src/10.3/sql/sql_parse.cc:6524
            #11 0x000055d1e8a75972 in mysql_execute_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:3745
            #12 0x000055d1e8a77fa9 in mysql_parse (thd=0x7f60b80009a8, rawbuf=<optimized out>, length=34, parser_state=0x7f60c9340630, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_parse.cc:7981
            #13 0x000055d1e8a7a868 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f60b80009a8, packet=packet@entry=0x7f60b80091f9 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=packet_length@entry=34, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.3/sql/sql_parse.cc:1826
            #14 0x000055d1e8a7b0ed in do_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:1370
            #15 0x000055d1e8b4ca94 in do_handle_one_connection (connect=connect@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1401
            #16 0x000055d1e8b4cc34 in handle_one_connection (arg=arg@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1307
            #17 0x000055d1e8e43584 in pfs_spawn_thread (arg=0x55d1ec26e488) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #18 0x00007f60d0daa494 in start_thread (arg=0x7f60c9341700) at pthread_create.c:333
            #19 0x00007f60cf19093f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            {noformat}
            alice Alice Sherepa made changes -
            Status Open [ 1 ] Confirmed [ 10101 ]
            alice Alice Sherepa made changes -
            Assignee Alice Sherepa [ alice ] Igor Babaev [ igor ]
            elenst Elena Stepanova added a comment -

            You are right, sorry about that. I've now added explicit MyISAM to the test case.

            elenst Elena Stepanova added a comment - You are right, sorry about that. I've now added explicit MyISAM to the test case.
            elenst Elena Stepanova made changes -
            Description _Note: might be related to MDEV-15017._

            {code:sql}
            CREATE TABLE t1 (f INT PRIMARY KEY);
            CREATE VIEW v1 AS SELECT a.* FROM t1 AS a STRAIGHT_JOIN t1 AS b;
            CREATE VIEW v2 AS SELECT f FROM v1 GROUP BY f;
            SELECT * FROM v1 JOIN v2 USING (f);
            {code}

            {noformat:title=10.3 ec32c050726 debug}
            mysqld: /data/src/10.3/sql/sql_select.cc:7939: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
            180122 3:28:40 [ERROR] mysqld got signal 6 ;

            #7 0x00007f5a78156ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
            #8 0x00005568de26c606 in greedy_search (join=0x7f5a60149db0, remaining_tables=6, search_depth=62, prune_level=1, use_cond_selectivity=1) at /data/src/10.3/sql/sql_select.cc:7939
            #9 0x00005568de26ba70 in choose_plan (join=0x7f5a60149db0, join_tables=6) at /data/src/10.3/sql/sql_select.cc:7509
            #10 0x00005568de2647b1 in make_join_statistics (join=0x7f5a60149db0, tables_list=..., keyuse_array=0x7f5a6014a0a0) at /data/src/10.3/sql/sql_select.cc:5008
            #11 0x00005568de259815 in JOIN::optimize_inner (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1959
            #12 0x00005568de2580e1 in JOIN::optimize (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1544
            #13 0x00005568de26189c in mysql_select (thd=0x7f5a60000b00, tables=0x7f5a60014e48, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f5a60149d90, unit=0x7f5a60004890, select_lex=0x7f5a60004fe8) at /data/src/10.3/sql/sql_select.cc:4236
            #14 0x00005568de25388a in handle_select (thd=0x7f5a60000b00, lex=0x7f5a600047c8, result=0x7f5a60149d90, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
            #15 0x00005568de21e956 in execute_sqlcom_select (thd=0x7f5a60000b00, all_tables=0x7f5a60014e48) at /data/src/10.3/sql/sql_parse.cc:6524
            #16 0x00005568de215040 in mysql_execute_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:3745
            #17 0x00005568de2222aa in mysql_parse (thd=0x7f5a60000b00, rawbuf=0x7f5a60014c38 "SELECT * FROM v1 JOIN v2 USING (f)", length=34, parser_state=0x7f5a723c55f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7981
            #18 0x00005568de20faef in dispatch_command (command=COM_QUERY, thd=0x7f5a60000b00, packet=0x7f5a6000b141 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
            #19 0x00005568de20e523 in do_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:1370
            #20 0x00005568de375768 in do_handle_one_connection (connect=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1401
            #21 0x00005568de3754f5 in handle_one_connection (arg=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1307
            #22 0x00005568de8130b8 in pfs_spawn_thread (arg=0x5568e1c896b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #23 0x00007f5a79e2d494 in start_thread (arg=0x7f5a723c6700) at pthread_create.c:333
            #24 0x00007f5a7821393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            {noformat}

            {noformat:title=10.3 e15f4af4d non-debug}
            #2 <signal handler called>
            #3 JOIN::fix_all_splittings_in_plan (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/opt_split.cc:1125
            #4 0x000055d1e8aa1dd0 in JOIN::get_best_combination (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:9472
            #5 0x000055d1e8ac25de in JOIN::optimize_stage2 (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1993
            #6 0x000055d1e8ac5541 in JOIN::optimize_inner (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1972
            #7 0x000055d1e8ac573f in JOIN::optimize (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1544
            #8 0x000055d1e8ac7b20 in mysql_select (thd=thd@entry=0x7f60b80009a8, tables=0x7f60b8011770, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f60b80ad838, unit=0x7f60b8004570, select_lex=0x7f60b8004cc8) at /data/src/10.3/sql/sql_select.cc:4236
            #9 0x000055d1e8ac7ce7 in handle_select (thd=thd@entry=0x7f60b80009a8, lex=lex@entry=0x7f60b80044a8, result=result@entry=0x7f60b80ad838, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.3/sql/sql_select.cc:379
            #10 0x000055d1e89a9f90 in execute_sqlcom_select (thd=0x7f60b80009a8, all_tables=0x7f60b8011770) at /data/src/10.3/sql/sql_parse.cc:6524
            #11 0x000055d1e8a75972 in mysql_execute_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:3745
            #12 0x000055d1e8a77fa9 in mysql_parse (thd=0x7f60b80009a8, rawbuf=<optimized out>, length=34, parser_state=0x7f60c9340630, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_parse.cc:7981
            #13 0x000055d1e8a7a868 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f60b80009a8, packet=packet@entry=0x7f60b80091f9 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=packet_length@entry=34, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.3/sql/sql_parse.cc:1826
            #14 0x000055d1e8a7b0ed in do_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:1370
            #15 0x000055d1e8b4ca94 in do_handle_one_connection (connect=connect@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1401
            #16 0x000055d1e8b4cc34 in handle_one_connection (arg=arg@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1307
            #17 0x000055d1e8e43584 in pfs_spawn_thread (arg=0x55d1ec26e488) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #18 0x00007f60d0daa494 in start_thread (arg=0x7f60c9341700) at pthread_create.c:333
            #19 0x00007f60cf19093f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            {noformat}             		_Note: might be related to MDEV-15017._

            {code:sql}
            CREATE TABLE t1 (f INT PRIMARY KEY) ENGINE=MyISAM;
            CREATE VIEW v1 AS SELECT a.* FROM t1 AS a STRAIGHT_JOIN t1 AS b;
            CREATE VIEW v2 AS SELECT f FROM v1 GROUP BY f;
            SELECT * FROM v1 JOIN v2 USING (f);
            {code}

            {noformat:title=10.3 ec32c050726 debug}
            mysqld: /data/src/10.3/sql/sql_select.cc:7939: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
            180122 3:28:40 [ERROR] mysqld got signal 6 ;

            #7 0x00007f5a78156ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
            #8 0x00005568de26c606 in greedy_search (join=0x7f5a60149db0, remaining_tables=6, search_depth=62, prune_level=1, use_cond_selectivity=1) at /data/src/10.3/sql/sql_select.cc:7939
            #9 0x00005568de26ba70 in choose_plan (join=0x7f5a60149db0, join_tables=6) at /data/src/10.3/sql/sql_select.cc:7509
            #10 0x00005568de2647b1 in make_join_statistics (join=0x7f5a60149db0, tables_list=..., keyuse_array=0x7f5a6014a0a0) at /data/src/10.3/sql/sql_select.cc:5008
            #11 0x00005568de259815 in JOIN::optimize_inner (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1959
            #12 0x00005568de2580e1 in JOIN::optimize (this=0x7f5a60149db0) at /data/src/10.3/sql/sql_select.cc:1544
            #13 0x00005568de26189c in mysql_select (thd=0x7f5a60000b00, tables=0x7f5a60014e48, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f5a60149d90, unit=0x7f5a60004890, select_lex=0x7f5a60004fe8) at /data/src/10.3/sql/sql_select.cc:4236
            #14 0x00005568de25388a in handle_select (thd=0x7f5a60000b00, lex=0x7f5a600047c8, result=0x7f5a60149d90, setup_tables_done_option=0) at /data/src/10.3/sql/sql_select.cc:379
            #15 0x00005568de21e956 in execute_sqlcom_select (thd=0x7f5a60000b00, all_tables=0x7f5a60014e48) at /data/src/10.3/sql/sql_parse.cc:6524
            #16 0x00005568de215040 in mysql_execute_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:3745
            #17 0x00005568de2222aa in mysql_parse (thd=0x7f5a60000b00, rawbuf=0x7f5a60014c38 "SELECT * FROM v1 JOIN v2 USING (f)", length=34, parser_state=0x7f5a723c55f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7981
            #18 0x00005568de20faef in dispatch_command (command=COM_QUERY, thd=0x7f5a60000b00, packet=0x7f5a6000b141 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=34, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1826
            #19 0x00005568de20e523 in do_command (thd=0x7f5a60000b00) at /data/src/10.3/sql/sql_parse.cc:1370
            #20 0x00005568de375768 in do_handle_one_connection (connect=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1401
            #21 0x00005568de3754f5 in handle_one_connection (arg=0x5568e1c6ded0) at /data/src/10.3/sql/sql_connect.cc:1307
            #22 0x00005568de8130b8 in pfs_spawn_thread (arg=0x5568e1c896b0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #23 0x00007f5a79e2d494 in start_thread (arg=0x7f5a723c6700) at pthread_create.c:333
            #24 0x00007f5a7821393f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            {noformat}

            {noformat:title=10.3 e15f4af4d non-debug}
            #2 <signal handler called>
            #3 JOIN::fix_all_splittings_in_plan (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/opt_split.cc:1125
            #4 0x000055d1e8aa1dd0 in JOIN::get_best_combination (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:9472
            #5 0x000055d1e8ac25de in JOIN::optimize_stage2 (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1993
            #6 0x000055d1e8ac5541 in JOIN::optimize_inner (this=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1972
            #7 0x000055d1e8ac573f in JOIN::optimize (this=this@entry=0x7f60b80ad858) at /data/src/10.3/sql/sql_select.cc:1544
            #8 0x000055d1e8ac7b20 in mysql_select (thd=thd@entry=0x7f60b80009a8, tables=0x7f60b8011770, wild_num=1, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f60b80ad838, unit=0x7f60b8004570, select_lex=0x7f60b8004cc8) at /data/src/10.3/sql/sql_select.cc:4236
            #9 0x000055d1e8ac7ce7 in handle_select (thd=thd@entry=0x7f60b80009a8, lex=lex@entry=0x7f60b80044a8, result=result@entry=0x7f60b80ad838, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/src/10.3/sql/sql_select.cc:379
            #10 0x000055d1e89a9f90 in execute_sqlcom_select (thd=0x7f60b80009a8, all_tables=0x7f60b8011770) at /data/src/10.3/sql/sql_parse.cc:6524
            #11 0x000055d1e8a75972 in mysql_execute_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:3745
            #12 0x000055d1e8a77fa9 in mysql_parse (thd=0x7f60b80009a8, rawbuf=<optimized out>, length=34, parser_state=0x7f60c9340630, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_parse.cc:7981
            #13 0x000055d1e8a7a868 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7f60b80009a8, packet=packet@entry=0x7f60b80091f9 "SELECT * FROM v1 JOIN v2 USING (f)", packet_length=packet_length@entry=34, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.3/sql/sql_parse.cc:1826
            #14 0x000055d1e8a7b0ed in do_command (thd=0x7f60b80009a8) at /data/src/10.3/sql/sql_parse.cc:1370
            #15 0x000055d1e8b4ca94 in do_handle_one_connection (connect=connect@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1401
            #16 0x000055d1e8b4cc34 in handle_one_connection (arg=arg@entry=0x55d1ec2358a8) at /data/src/10.3/sql/sql_connect.cc:1307
            #17 0x000055d1e8e43584 in pfs_spawn_thread (arg=0x55d1ec26e488) at /data/src/10.3/storage/perfschema/pfs.cc:1862
            #18 0x00007f60d0daa494 in start_thread (arg=0x7f60c9341700) at pthread_create.c:333
            #19 0x00007f60cf19093f in clone () from /lib/x86_64-linux-gnu/libc.so.6
            {noformat}
            igor Igor Babaev (Inactive) made changes -
            Status Confirmed [ 10101 ] In Progress [ 3 ]
            igor Igor Babaev (Inactive) added a comment -

            A fix for this bug was pushed into the 10.3 tree.

            igor Igor Babaev (Inactive) added a comment - A fix for this bug was pushed into the 10.3 tree.
            igor Igor Babaev (Inactive) made changes -
            Fix Version/s 10.3.5 [ 22905 ]
            Fix Version/s 10.3 [ 22126 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 84953 ] MariaDB v4 [ 153597 ]

            People

              igor Igor Babaev (Inactive)
              elenst Elena Stepanova
              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.