[MDEV-18977] TABLE::prune_range_rowid_filters: Conditional jump or move depends on uninitialised value Created: 2019-03-20  Updated: 2019-03-20

Status: Confirmed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 10.4
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Igor Babaev
Resolution: Unresolved Votes: 0
Labels: valgrind


 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)


Generated at Thu Feb 08 08:48:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.