--source include/have_partition.inc

CREATE TABLE t (a INT) PARTITION BY HASH(a) PARTITIONS 2;

INSERT INTO t VALUES (1),(2);

SELECT * FROM t WHERE a LIKE '1';

# Cleanup

DROP TABLE t;

==1877023== Thread 6:

==1877023== Conditional jump or move depends on uninitialised value(s)

==1877023==    at 0x1013F9C: Item_func_like::get_mm_leaf(RANGE_OPT_PARAM*, Field*, KEY_PART*, Item_func::Functype, Item*) (opt_range.cc:8757)

==1877023==    by 0x1013820: Item_bool_func::get_mm_parts(RANGE_OPT_PARAM*, Field*, Item_func::Functype, Item*) (opt_range.cc:8658)

==1877023==    by 0x1028A08: Item_func_like::get_func_mm_tree(RANGE_OPT_PARAM*, Field*, Item*) (item_cmpfunc.h:2875)

==1877023==    by 0x10125A4: Item_bool_func::get_full_func_mm_tree(RANGE_OPT_PARAM*, Item_field*, Item*) (opt_range.cc:8317)

==1877023==    by 0x9E08D1: Item_bool_func::get_full_func_mm_tree_for_args(RANGE_OPT_PARAM*, Item*, Item*) (item_cmpfunc.h:208)

==1877023==    by 0xB2C2FA: Item_bool_func2::get_mm_tree(RANGE_OPT_PARAM*, Item**) (item_cmpfunc.h:464)

==1877023==    by 0xEB21FD: Item_func_like::get_mm_tree(RANGE_OPT_PARAM*, Item**) (item_cmpfunc.cc:5878)

==1877023==    by 0x1006D9F: prune_partitions(THD*, TABLE*, Item*) (opt_range.cc:3987)

==1877023==    by 0xAD434F: JOIN::optimize_inner() (sql_select.cc:2403)

==1877023==    by 0xAD21D3: JOIN::optimize() (sql_select.cc:1868)

==1877023==    by 0xADE2A6: mysql_select(THD*, TABLE_LIST*, 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:5077)

==1877023==    by 0xACC946: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:559)

==1877023==    by 0xA8999A: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:6285)

==1877023==    by 0xA808D0: mysql_execute_command(THD*, bool) (sql_parse.cc:3961)

==1877023==    by 0xA8E997: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:8050)

==1877023==    by 0xA7A3E4: dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) (sql_parse.cc:1896)

==1877816==WARNING: MemorySanitizer: use-of-uninitialized-value

    #0 0x5649f52a4d8c in Item_func_like::get_mm_leaf(RANGE_OPT_PARAM*, Field*, KEY_PART*, Item_func::Functype, Item*) /data/src/10.6-msan/sql/opt_range.cc:8757:9

    #1 0x5649f52912b6 in Item_bool_func::get_mm_parts(RANGE_OPT_PARAM*, Field*, Item_func::Functype, Item*) /data/src/10.6-msan/sql/opt_range.cc:8658:18

    #2 0x5649f52f9033 in Item_func_like::get_func_mm_tree(RANGE_OPT_PARAM*, Field*, Item*) /data/src/10.6-msan/sql/item_cmpfunc.h:2875:5

    #3 0x5649f529dd1c in Item_bool_func::get_full_func_mm_tree(RANGE_OPT_PARAM*, Item_field*, Item*) /data/src/10.6-msan/sql/opt_range.cc:8317:12

    #4 0x5649f414b9bd in Item_bool_func::get_full_func_mm_tree_for_args(RANGE_OPT_PARAM*, Item*, Item*) /data/src/10.6-msan/sql/item_cmpfunc.h:208:7

    #5 0x5649f4149540 in Item_bool_func2::get_mm_tree(RANGE_OPT_PARAM*, Item**) /data/src/10.6-msan/sql/item_cmpfunc.h:464:22

    #6 0x5649f4d5c671 in Item_func_like::get_mm_tree(RANGE_OPT_PARAM*, Item**) /data/src/10.6-msan/sql/item_cmpfunc.cc:5878:22

    #7 0x5649f528199b in prune_partitions(THD*, TABLE*, Item*) /data/src/10.6-msan/sql/opt_range.cc:3987:22

    #8 0x5649f3ffa1ae in JOIN::optimize_inner() /data/src/10.6-msan/sql/sql_select.cc:2403:9

    #9 0x5649f3fdf8ec in JOIN::optimize() /data/src/10.6-msan/sql/sql_select.cc:1868:10

    #10 0x5649f3fc05f0 in mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*) /data/src/10.6-msan/sql/sql_select.cc:5077:19

    #11 0x5649f3fbf1e6 in handle_select(THD*, LEX*, select_result*, unsigned long) /data/src/10.6-msan/sql/sql_select.cc:559:10

    #12 0x5649f3ef464a in execute_sqlcom_select(THD*, TABLE_LIST*) /data/src/10.6-msan/sql/sql_parse.cc:6285:12

    #13 0x5649f3ece2fe in mysql_execute_command(THD*, bool) /data/src/10.6-msan/sql/sql_parse.cc:3961:12

    #14 0x5649f3eb5d5a in mysql_parse(THD*, char*, unsigned int, Parser_state*) /data/src/10.6-msan/sql/sql_parse.cc:8050:18

    #15 0x5649f3eaa2a0 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool) /data/src/10.6-msan/sql/sql_parse.cc:1896:7

    #16 0x5649f3eb8150 in do_command(THD*, bool) /data/src/10.6-msan/sql/sql_parse.cc:1409:17

    #17 0x5649f44e7e9f in do_handle_one_connection(CONNECT*, bool) /data/src/10.6-msan/sql/sql_connect.cc:1416:11

    #18 0x5649f44e7485 in handle_one_connection /data/src/10.6-msan/sql/sql_connect.cc:1318:5

    #19 0x5649f595c4ca in pfs_spawn_thread /data/src/10.6-msan/storage/perfschema/pfs.cc:2201:3

    #20 0x7fab4f369fd3 in start_thread nptl/./nptl/pthread_create.c:442:8

    #21 0x7fab4f3ea5bb in clone3 misc/../sysdeps/unix/sysv/linux/x86_64/clone3.S:81

  Uninitialized value was created by an allocation of 'prune_param' in the stack frame of function '_Z16prune_partitionsP3THDP5TABLEP4Item'

    #0 0x5649f527fcf0 in prune_partitions(THD*, TABLE*, Item*) /data/src/10.6-msan/sql/opt_range.cc:3930

SUMMARY: MemorySanitizer: use-of-uninitialized-value /data/src/10.6-msan/sql/opt_range.cc:8757:9 in Item_func_like::get_mm_leaf(RANGE_OPT_PARAM*, Field*, KEY_PART*, Item_func::Functype, Item*)

commit 4e9322e2ff25d638013e6e6cf051754084e2f16b

Author: Monty <monty@mariadb.org>

Date:   Wed Sep 20 15:46:55 2023 +0300

    MDEV-32203 Raise notes when an index cannot be used on data type mismatch