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

LP:611625 - Assertion `*item' failed in Expression_cache_tmptable::init()

    XMLWordPrintable

Details

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

    Description

      This query

      SELECT (
      SELECT `col_int_nokey`
      FROM D
      WHERE table1 .`col_varchar_nokey` ) field13
      FROM BB table1 JOIN C table2 ON table2 .`pk`
      ORDER BY field13
      ;

      crashes as follows:

      /lib/libc.so.6(__assert_fail+0xf8) [0x897de8]
      /home/philips/bzr/maria-5.3/sql/mysqld(Expression_cache_tmptable::init()+0x1ac) [0x8496f34]
      /home/philips/bzr/maria-5.3/sql/mysqld(Expression_cache_tmptable::check_value(Item**)+0x51) [0x84974a3]
      /home/philips/bzr/maria-5.3/sql/mysqld(Item_cache_wrapper::check_cache()+0x5e) [0x81c85a6]
      /home/philips/bzr/maria-5.3/sql/mysqld(Item_cache_wrapper::val_int()+0xa2) [0x81c87fe]
      /home/philips/bzr/maria-5.3/sql/mysqld(Item::send(Protocol*, String*)+0x16f) [0x81c60a7]
      /home/philips/bzr/maria-5.3/sql/mysqld(Item_cache_wrapper::send(Protocol*, String*)+0x47) [0x81d15b1]
      /home/philips/bzr/maria-5.3/sql/mysqld(select_send::send_data(List<Item>&)+0x106) [0x8267b7a]
      /home/philips/bzr/maria-5.3/sql/mysqld() [0x831fab2]
      /home/philips/bzr/maria-5.3/sql/mysqld() [0x831dfa6]
      /home/philips/bzr/maria-5.3/sql/mysqld(sub_select(JOIN*, st_join_table*, bool)+0x1ee) [0x831d94d]
      /home/philips/bzr/maria-5.3/sql/mysqld() [0x831cd4c]
      /home/philips/bzr/maria-5.3/sql/mysqld(JOIN::exec()+0x26f1) [0x83031b7]
      /home/philips/bzr/maria-5.3/sql/mysqld(mysql_select(THD*, Item**, TABLE_LIST, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*)+0x34a) [0x83038ea]
      /home/philips/bzr/maria-5.3/sql/mysqld(handle_select(THD*, st_lex*, select_result*, unsigned long)+0x1cf) [0x82fbfb7]
      /home/philips/bzr/maria-5.3/sql/mysqld() [0x829a6d8]
      /home/philips/bzr/maria-5.3/sql/mysqld(mysql_execute_command(THD*)+0x881) [0x82910b8]
      /home/philips/bzr/maria-5.3/sql/mysqld(mysql_parse(THD*, char const*, unsigned int, char const**)+0x248) [0x829c8b9]
      /home/philips/bzr/maria-5.3/sql/mysqld(dispatch_command(enum_server_command, THD*, char*, unsigned int)+0x8c3) [0x828eaea]
      /home/philips/bzr/maria-5.3/sql/mysqld(do_command(THD*)+0x273) [0x828df90]
      /home/philips/bzr/maria-5.3/sql/mysqld(handle_one_connection+0x152) [0x828b0f0]

      EXPLAIN:

      id select_type table type possible_keys key key_len ref rows Extra
      1 PRIMARY table1 system NULL NULL NULL NULL 1
      1 PRIMARY table2 index NULL PRIMARY 4 NULL 20 Using where; Using index
      2 DEPENDENT SUBQUERY NULL NULL NULL NULL NULL NULL NULL Impossible WHERE

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            philipstoev Philip Stoev (Inactive)
            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.