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

LP:1008487 - virtual bool Item_cache::is_expensive(): Assertion `example' failed.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      mysqld: ./maria-5.5/sql/item.h:3892: virtual bool Item_cache::is_expensive(): Assertion `example' failed.

      Program received signal SIGABRT, Aborted.
      [Switching to Thread 0x7ffff42d3700 (LWP 29894)]
      0x00000030b84330c5 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
      64 return INLINE_SYSCALL (tgkill, 3, pid, selftid, sig);
      (gdb) bt
      #0 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
      #1 in abort () at abort.c:92
      #2 in __assert_fail at assert.c:81
      #3 in Item_cache::is_expensive at ./maria-5.5/sql/item.h:3892
      #4 in make_join_statistics at ./maria-5.5/sql/sql_select.cc:3455
      #5 in JOIN::optimize at ./maria-5.5/sql/sql_select.cc:1195
      #6 in mysql_select at ./maria-5.5/sql/sql_select.cc:3000
      #7 in handle_select at ./maria-5.5/sql/sql_select.cc:311
      #8 in execute_sqlcom_select at ./maria-5.5/sql/sql_parse.cc:4616
      #9 in mysql_execute_command at ./maria-5.5/sql/sql_parse.cc:2184
      #10 in mysql_parse at ./maria-5.5/sql/sql_parse.cc:5731
      #11 in dispatch_command at ./maria-5.5/sql/sql_parse.cc:1055
      #12 in do_command at ./maria-5.5/sql/sql_parse.cc:794
      #13 in do_handle_one_connection at ./maria-5.5/sql/sql_connect.cc:1253
      #14 in handle_one_connection at ./maria-5.5/sql/sql_connect.cc:1168
      #15 in start_thread at pthread_create.c:301
      #16 in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115

      How to repeat:
      ------------------
      #on a debug build:

      drop table if exists `t1`;
      create table `t1`(`a` date,key(`a`))engine=innodb;
      insert into `t1` values ('2012-01-01'),('2012-02-02');
      select 1 from `t1` as `t1_0` inner join `t1` as `t2`
      on (`t1_0`.`a` <=> now()) join `t1` on 1;

      Attachments

        Activity

          People

            timour Timour Katchaounov (Inactive)
            sbester sbester
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.