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

TABLE::prune_range_rowid_filters: Conditional jump or move depends on uninitialised value

    Details

      Description

      Setting to Minor because duplicate indexes have been deprecated.

      Run with --valgrind-mysqld:

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (i INT, KEY(i), KEY(i)) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1),(2);
      SELECT * FROM t1 WHERE i != 4;
       
      # Cleanup
      DROP TABLE t1;
      

      10.4 de51acd0

      ==7916== Conditional jump or move depends on uninitialised value(s)
      ==7916==    at 0xAD9A93: TABLE::prune_range_rowid_filters() (rowid_filter.cc:252)
      ==7916==    by 0xAD9EE7: TABLE::init_cost_info_for_usable_range_rowid_filters(THD*) (rowid_filter.cc:403)
      ==7916==    by 0x8EA044: make_join_statistics(JOIN*, List<TABLE_LIST>&, st_dynamic_array*) (sql_select.cc:5369)
      ==7916==    by 0x8DE82B: JOIN::optimize_inner() (sql_select.cc:2174)
      ==7916==    by 0x8DC311: JOIN::optimize() (sql_select.cc:1551)
      ==7916==    by 0x8E739D: mysql_select(THD*, 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*) (sql_select.cc:4571)
      ==7916==    by 0x8D7821: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:424)
      ==7916==    by 0x89FF7C: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:6652)
      ==7916==    by 0x895137: mysql_execute_command(THD*) (sql_parse.cc:3889)
      ==7916==    by 0x8A3EBC: mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) (sql_parse.cc:8205)
      ==7916==    by 0x88F3A0: dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) (sql_parse.cc:1829)
      ==7916==    by 0x88DB86: do_command(THD*) (sql_parse.cc:1358)
      ==7916==    by 0xA0D9CA: do_handle_one_connection(CONNECT*) (sql_connect.cc:1399)
      ==7916==    by 0xA0D73B: handle_one_connection (sql_connect.cc:1302)
      ==7916==    by 0xF27282: pfs_spawn_thread (pfs.cc:1862)
      ==7916==    by 0x4E3F493: start_thread (pthread_create.c:333)
      

        Attachments

          Activity

            People

            • Assignee:
              igor Igor Babaev
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: