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

Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed in greedy_search

    XMLWordPrintable

Details

    • Bug
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4
    • 10.4
    • None
    • None

    Description

      Repeatable on 10.4 with MyIsam, not with InnoDB.

      CREATE TABLE t1 (c2 varchar(10), i1 int, KEY (c2), KEY (i1)) ENGINE=MyISAM;
       
      CREATE TABLE t2 (i1 int, c1 varchar(10), c2 varchar(10) , pk int, KEY (i1), KEY (c1(10)), KEY (c2)) ENGINE=MyISAM;
      INSERT INTO t2 VALUES (-174260224,'ixqy','NPCSX',1);
       
      SELECT 1
      FROM t2 AS tt22
      RIGHT JOIN t2
      LEFT JOIN t1 AS tt1
      LEFT JOIN t1
      JOIN t2 AS tt2 ON t1.c2 = tt2.c2 ON tt1.i1 = t1.i1 ON t2.pk = tt1.i1 ON tt22.c1 = tt2.c1;
       
      drop table t1,t2;
      

      10.4 514b305dfb2839c619a

      /10.4/sql/sql_select.cc:8555: bool greedy_search(JOIN*, table_map, uint, uint, uint): Assertion `join->best_read < double(1.79769313486231570815e+308L)' failed.
       
      #5  0x00007f878e55202a in __GI_abort () at abort.c:89
      #6  0x00007f878e548bd7 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x563754d11510 "join->best_read < double(1.79769313486231570815e+308L)", file=file@entry=0x563754d10398 "/10.4/sql/sql_select.cc", line=line@entry=8555, function=function@entry=0x563754d14840 <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  0x00007f878e548c82 in __GI___assert_fail (assertion=0x563754d11510 "join->best_read < double(1.79769313486231570815e+308L)", file=0x563754d10398 "/10.4/sql/sql_select.cc", line=8555, function=0x563754d14840 <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  0x00005637540d88ee in greedy_search (join=0x7f873006c440, remaining_tables=5, search_depth=62, prune_level=1, use_cond_selectivity=4) at /10.4/sql/sql_select.cc:8555
      #9  0x00005637540d7c44 in choose_plan (join=0x7f873006c440, join_tables=5) at /10.4/sql/sql_select.cc:8110
      #10 0x00005637540cfe47 in make_join_statistics (join=0x7f873006c440, tables_list=..., keyuse_array=0x7f873006c760) at /10.4/sql/sql_select.cc:5465
      #11 0x00005637540c3eca in JOIN::optimize_inner (this=0x7f873006c440) at /10.4/sql/sql_select.cc:2174
      #12 0x00005637540c19d6 in JOIN::optimize (this=0x7f873006c440) at /10.4/sql/sql_select.cc:1551
      #13 0x00005637540cc9fe in mysql_select (thd=0x7f8730000a98, tables=0x7f8730039da0, wild_num=0, fields=..., conds=0x0, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f873006c3e0, unit=0x7f87300049d0, select_lex=0x7f873003af10) at /10.4/sql/sql_select.cc:4571
      #14 0x00005637540bcede in handle_select (thd=0x7f8730000a98, lex=0x7f8730004908, result=0x7f873006c3e0, setup_tables_done_option=0) at /10.4/sql/sql_select.cc:424
      #15 0x00005637540856c4 in execute_sqlcom_select (thd=0x7f8730000a98, all_tables=0x7f8730039da0) at /10.4/sql/sql_parse.cc:6601
      #16 0x000056375407a79e in mysql_execute_command (thd=0x7f8730000a98) at /10.4/sql/sql_parse.cc:3889
      #17 0x000056375408961c in mysql_parse (thd=0x7f8730000a98, rawbuf=0x7f873008b580 "SELECT 1\nFROM t2 AS tt22\nRIGHT JOIN t2\nLEFT JOIN t1 AS tt1\nLEFT JOIN t1\nJOIN t2 AS tt2 ON t1.c2 = tt2.c2 ON tt1.i1 = t1.i1 ON t2.pk = tt1.i1 ON tt22.c1 = tt2.c1", length=160, parser_state=0x7f8788072ff0, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:8154
      #18 0x00005637540748ec in dispatch_command (command=COM_QUERY, thd=0x7f8730000a98, packet=0x7f8730009da9 "SELECT 1\nFROM t2 AS tt22\nRIGHT JOIN t2\nLEFT JOIN t1 AS tt1\nLEFT JOIN t1\nJOIN t2 AS tt2 ON t1.c2 = tt2.c2 ON tt1.i1 = t1.i1 ON t2.pk = tt1.i1 ON tt22.c1 = tt2.c1", packet_length=160, is_com_multi=false, is_next_command=false) at /10.4/sql/sql_parse.cc:1832
      #19 0x0000563754073080 in do_command (thd=0x7f8730000a98) at /10.4/sql/sql_parse.cc:1365
      #20 0x00005637541f2f1b in do_handle_one_connection (connect=0x5637579b0938) at /10.4/sql/sql_connect.cc:1398
      #21 0x00005637541f2c59 in handle_one_connection (arg=0x5637579b0938) at /10.4/sql/sql_connect.cc:1301
      #22 0x0000563754b81227 in pfs_spawn_thread (arg=0x5637579651c8) at /10.4/storage/perfschema/pfs.cc:1862
      #23 0x00007f878f3916ba in start_thread (arg=0x7f8788074700) at pthread_create.c:333
      #24 0x00007f878e62241d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:109
      
      

      Attachments

        Issue Links

          Activity

            People

              psergei Sergei Petrunia
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.