[MDEV-12736] [Draft] Different results on debug and non-debug build Created: 2017-05-08  Updated: 2023-11-26  Resolved: 2023-11-26

Status: Closed
Project: MariaDB Server
Component/s: Optimizer
Affects Version/s: 5.5, 10.1
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Cannot Reproduce Votes: 0
Labels: None

Attachments: File t4.test.gz    

 Description   

Debug

 
SELECT COUNT(*) FROM ( ( SELECT DISTINCT SQ1_alias1.* FROM ( table1000_aria_latin1 AS SQ1_alias1 INNER JOIN view_table10_innodb_latin1_0 AS SQ1_alias2 ON (SQ1_alias2.`col_smallint_null` = SQ1_alias1.`col_tinyint_null` ) ) WHERE SQ1_alias1.`col_tinyint_unsigned_not_null` <> 0 ) AS alias1, `table20_aria_utf8` AS alias2 ) WHERE alias1.`col_bit_null` IN ( SELECT SQ2_alias1.`col_bigint_not_null` AS SQ2_ifield1 FROM table20_myisam_latin1 AS SQ2_alias1 ) 
;
 
COUNT(*)
 
0

non-debug

 
SELECT COUNT(*) FROM ( ( SELECT DISTINCT SQ1_alias1.* FROM ( table1000_aria_latin1 AS SQ1_alias1 INNER JOIN view_table10_innodb_latin1_0 AS SQ1_alias2 ON (SQ1_alias2.`col_smallint_null` = SQ1_alias1.`col_tinyint_null` ) ) WHERE SQ1_alias1.`col_tinyint_unsigned_not_null` <> 0 ) AS alias1, `table20_aria_utf8` AS alias2 ) WHERE alias1.`col_bit_null` IN ( SELECT SQ2_alias1.`col_bigint_not_null` AS SQ2_ifield1 FROM table20_myisam_latin1 AS SQ2_alias1 ) 
;
 
COUNT(*)
 
1

15f9931f6d2b0eb4006fdc42072c2905fd67c1aa

 Comments   
Comment by Elena Stepanova [ 2021-04-03 ]

Valgrind warnings may indicate an internal corruption:

10.2 fb9d1519 valgrind

 
==211838== Thread 6:
 
==211838== Syscall param pwrite64(buf) points to uninitialised byte(s)
 
==211838==    at 0x4D1ACBF: __libc_pwrite64 (pwrite64.c:29)
 
==211838==    by 0x4D1ACBF: pwrite (pwrite64.c:27)
 
==211838==    by 0x1134A3B: my_pwrite (my_pread.c:159)
 
==211838==    by 0xF48DD9: _ma_nommap_pwrite (ma_dynrec.c:219)
 
==211838==    by 0xF4B050: _ma_write_part_record (ma_dynrec.c:760)
 
==211838==    by 0xF49270: write_dynamic_record (ma_dynrec.c:356)
 
==211838==    by 0xF48FBA: _ma_write_blob_record (ma_dynrec.c:264)
 
==211838==    by 0xFD56F0: maria_write (ma_write.c:284)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838==  Address 0xd05e953 is 1,043 bytes inside a block of size 1,800 alloc'd
 
==211838==    at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
 
==211838==    by 0x113250E: my_malloc (my_malloc.c:101)
 
==211838==    by 0xF48F04: _ma_write_blob_record (ma_dynrec.c:253)
 
==211838==    by 0xFD56F0: maria_write (ma_write.c:284)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838==    by 0x7707BA: sub_select_cache(JOIN*, st_join_table*, bool) (sql_select.cc:18642)
 
==211838==    by 0x7709D2: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18814)
 
==211838==    by 0x7701AC: do_select(JOIN*, Procedure*) (sql_select.cc:18409)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112F52D: ha_key_cmp (my_compare.c:311)
 
==211838==    by 0xFA756E: _ma_bin_search (ma_search.c:312)
 
==211838==    by 0xFA6E0B: _ma_search_no_save (ma_search.c:149)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xF4F211: _ma_check_unique (ma_unique.c:55)
 
==211838==    by 0xFD4EF7: maria_write (ma_write.c:136)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838==    by 0x7707BA: sub_select_cache(JOIN*, st_join_table*, bool) (sql_select.cc:18642)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112F52D: ha_key_cmp (my_compare.c:311)
 
==211838==    by 0xFA756E: _ma_bin_search (ma_search.c:312)
 
==211838==    by 0xFD683E: w_search (ma_write.c:643)
 
==211838==    by 0xFD6272: _ma_ck_real_write_btree (ma_write.c:532)
 
==211838==    by 0xFD60E8: _ma_ck_write_btree_with_log (ma_write.c:498)
 
==211838==    by 0xFD5F35: _ma_ck_write_btree (ma_write.c:456)
 
==211838==    by 0xFD5E94: _ma_ck_write (ma_write.c:441)
 
==211838==    by 0xFD5610: maria_write (ma_write.c:189)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112F52D: ha_key_cmp (my_compare.c:311)
 
==211838==    by 0xFA74FC: _ma_bin_search (ma_search.c:303)
 
==211838==    by 0xFA6E0B: _ma_search_no_save (ma_search.c:149)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xF4F211: _ma_check_unique (ma_unique.c:55)
 
==211838==    by 0xFD4EF7: maria_write (ma_write.c:136)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838==    by 0x7707BA: sub_select_cache(JOIN*, st_join_table*, bool) (sql_select.cc:18642)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112F552: ha_key_cmp (my_compare.c:311)
 
==211838==    by 0xFA756E: _ma_bin_search (ma_search.c:312)
 
==211838==    by 0xFA6E0B: _ma_search_no_save (ma_search.c:149)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xF4F211: _ma_check_unique (ma_unique.c:55)
 
==211838==    by 0xFD4EF7: maria_write (ma_write.c:136)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838==    by 0x7707BA: sub_select_cache(JOIN*, st_join_table*, bool) (sql_select.cc:18642)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0xFA7576: _ma_bin_search (ma_search.c:315)
 
==211838==    by 0xFA6E0B: _ma_search_no_save (ma_search.c:149)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xF4F211: _ma_check_unique (ma_unique.c:55)
 
==211838==    by 0xFD4EF7: maria_write (ma_write.c:136)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838==    by 0x7707BA: sub_select_cache(JOIN*, st_join_table*, bool) (sql_select.cc:18642)
 
==211838==    by 0x7709D2: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18814)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0xFA6E75: _ma_search_no_save (ma_search.c:162)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xF4F211: _ma_check_unique (ma_unique.c:55)
 
==211838==    by 0xFD4EF7: maria_write (ma_write.c:136)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838==    by 0x7707BA: sub_select_cache(JOIN*, st_join_table*, bool) (sql_select.cc:18642)
 
==211838==    by 0x7709D2: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18814)
 
==211838==    by 0x7701AC: do_select(JOIN*, Procedure*) (sql_select.cc:18409)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112F52D: ha_key_cmp (my_compare.c:311)
 
==211838==    by 0xFA74FC: _ma_bin_search (ma_search.c:303)
 
==211838==    by 0xFD683E: w_search (ma_write.c:643)
 
==211838==    by 0xFD6272: _ma_ck_real_write_btree (ma_write.c:532)
 
==211838==    by 0xFD60E8: _ma_ck_write_btree_with_log (ma_write.c:498)
 
==211838==    by 0xFD5F35: _ma_ck_write_btree (ma_write.c:456)
 
==211838==    by 0xFD5E94: _ma_ck_write (ma_write.c:441)
 
==211838==    by 0xFD5610: maria_write (ma_write.c:189)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112F552: ha_key_cmp (my_compare.c:311)
 
==211838==    by 0xFA756E: _ma_bin_search (ma_search.c:312)
 
==211838==    by 0xFD683E: w_search (ma_write.c:643)
 
==211838==    by 0xFD6272: _ma_ck_real_write_btree (ma_write.c:532)
 
==211838==    by 0xFD60E8: _ma_ck_write_btree_with_log (ma_write.c:498)
 
==211838==    by 0xFD5F35: _ma_ck_write_btree (ma_write.c:456)
 
==211838==    by 0xFD5E94: _ma_ck_write (ma_write.c:441)
 
==211838==    by 0xFD5610: maria_write (ma_write.c:189)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0xFA7576: _ma_bin_search (ma_search.c:315)
 
==211838==    by 0xFD683E: w_search (ma_write.c:643)
 
==211838==    by 0xFD6272: _ma_ck_real_write_btree (ma_write.c:532)
 
==211838==    by 0xFD60E8: _ma_ck_write_btree_with_log (ma_write.c:498)
 
==211838==    by 0xFD5F35: _ma_ck_write_btree (ma_write.c:456)
 
==211838==    by 0xFD5E94: _ma_ck_write (ma_write.c:441)
 
==211838==    by 0xFD5610: maria_write (ma_write.c:189)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0xFD684C: w_search (ma_write.c:645)
 
==211838==    by 0xFD6272: _ma_ck_real_write_btree (ma_write.c:532)
 
==211838==    by 0xFD60E8: _ma_ck_write_btree_with_log (ma_write.c:498)
 
==211838==    by 0xFD5F35: _ma_ck_write_btree (ma_write.c:456)
 
==211838==    by 0xFD5E94: _ma_ck_write (ma_write.c:441)
 
==211838==    by 0xFD5610: maria_write (ma_write.c:189)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838==    by 0x7707BA: sub_select_cache(JOIN*, st_join_table*, bool) (sql_select.cc:18642)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112F552: ha_key_cmp (my_compare.c:311)
 
==211838==    by 0xFA74FC: _ma_bin_search (ma_search.c:303)
 
==211838==    by 0xFA6E0B: _ma_search_no_save (ma_search.c:149)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xF4F211: _ma_check_unique (ma_unique.c:55)
 
==211838==    by 0xFD4EF7: maria_write (ma_write.c:136)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838==    by 0x7707BA: sub_select_cache(JOIN*, st_join_table*, bool) (sql_select.cc:18642)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0xFA7504: _ma_bin_search (ma_search.c:303)
 
==211838==    by 0xFA6E0B: _ma_search_no_save (ma_search.c:149)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xF4F211: _ma_check_unique (ma_unique.c:55)
 
==211838==    by 0xFD4EF7: maria_write (ma_write.c:136)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838==    by 0x7707BA: sub_select_cache(JOIN*, st_join_table*, bool) (sql_select.cc:18642)
 
==211838==    by 0x7709D2: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18814)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112F552: ha_key_cmp (my_compare.c:311)
 
==211838==    by 0xFA74FC: _ma_bin_search (ma_search.c:303)
 
==211838==    by 0xFD683E: w_search (ma_write.c:643)
 
==211838==    by 0xFD6272: _ma_ck_real_write_btree (ma_write.c:532)
 
==211838==    by 0xFD60E8: _ma_ck_write_btree_with_log (ma_write.c:498)
 
==211838==    by 0xFD5F35: _ma_ck_write_btree (ma_write.c:456)
 
==211838==    by 0xFD5E94: _ma_ck_write (ma_write.c:441)
 
==211838==    by 0xFD5610: maria_write (ma_write.c:189)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0xFA7504: _ma_bin_search (ma_search.c:303)
 
==211838==    by 0xFD683E: w_search (ma_write.c:643)
 
==211838==    by 0xFD6272: _ma_ck_real_write_btree (ma_write.c:532)
 
==211838==    by 0xFD60E8: _ma_ck_write_btree_with_log (ma_write.c:498)
 
==211838==    by 0xFD5F35: _ma_ck_write_btree (ma_write.c:456)
 
==211838==    by 0xFD5E94: _ma_ck_write (ma_write.c:441)
 
==211838==    by 0xFD5610: maria_write (ma_write.c:189)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7744F7: end_write(JOIN*, st_join_table*, bool) (sql_select.cc:20274)
 
==211838==    by 0x785B70: AGGR_OP::put_record(bool) (sql_select.cc:26808)
 
==211838==    by 0x78BE7A: AGGR_OP::put_record() (sql_select.h:973)
 
==211838==    by 0x7706D9: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18584)
 
==211838==    by 0x8A0CBC: JOIN_CACHE::generate_full_extensions(unsigned char*) (sql_join_cache.cc:2470)
 
==211838==    by 0x8A0A1F: JOIN_CACHE::join_matching_records(bool) (sql_join_cache.cc:2362)
 
==211838==    by 0x8A0355: JOIN_CACHE::join_records(bool) (sql_join_cache.cc:2146)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112E523: compare_bin (my_compare.c:43)
 
==211838==    by 0x112ED00: ha_key_cmp (my_compare.c:228)
 
==211838==    by 0xFA783D: _ma_seq_search (ma_search.c:387)
 
==211838==    by 0xFD683E: w_search (ma_write.c:643)
 
==211838==    by 0xFD6272: _ma_ck_real_write_btree (ma_write.c:532)
 
==211838==    by 0xFD60E8: _ma_ck_write_btree_with_log (ma_write.c:498)
 
==211838==    by 0xFD5F35: _ma_ck_write_btree (ma_write.c:456)
 
==211838==    by 0xFD5E94: _ma_ck_write (ma_write.c:441)
 
==211838==    by 0xFD5610: maria_write (ma_write.c:189)
 
==211838==    by 0xF593FA: ha_maria::write_row(unsigned char*) (ha_maria.cc:1293)
 
==211838==    by 0x78AFAA: handler::ha_write_tmp_row(unsigned char*) (sql_class.h:5926)
 
==211838==    by 0x7EDF81: select_union::send_data(List<Item>&) (sql_union.cc:79)
 
==211838==    by 0x773913: end_send(JOIN*, st_join_table*, bool) (sql_select.cc:20035)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x785E53: AGGR_OP::end_send() (sql_select.cc:26883)
 
==211838==    by 0x77069E: sub_select_postjoin_aggr(JOIN*, st_join_table*, bool) (sql_select.cc:18578)
 
==211838== Syscall param pwrite64(buf) points to uninitialised byte(s)
 
==211838==    at 0x4D1ACBF: __libc_pwrite64 (pwrite64.c:29)
 
==211838==    by 0x4D1ACBF: pwrite (pwrite64.c:27)
 
==211838==    by 0x1134A3B: my_pwrite (my_pread.c:159)
 
==211838==    by 0xF7D970: pagecache_fwrite (ma_pagecache.c:670)
 
==211838==    by 0xF872BD: flush_cached_blocks (ma_pagecache.c:4419)
 
==211838==    by 0xF87C9F: flush_pagecache_blocks_int (ma_pagecache.c:4715)
 
==211838==    by 0xF880C1: flush_pagecache_blocks_with_filter (ma_pagecache.c:4832)
 
==211838==    by 0xFE3697: maria_close (ma_close.c:49)
 
==211838==    by 0xF59383: ha_maria::close() (ha_maria.cc:1277)
 
==211838==    by 0x99541C: handler::ha_close() (handler.cc:2657)
 
==211838==    by 0xF5D8D1: ha_maria::drop_table(char const*) (ha_maria.cc:2692)
 
==211838==    by 0x99A2B7: handler::ha_drop_table(char const*) (handler.cc:4500)
 
==211838==    by 0x76F6B7: free_tmp_table(THD*, TABLE*) (sql_select.cc:18175)
 
==211838==    by 0x76109A: JOIN::cleanup(bool) (sql_select.cc:12383)
 
==211838==    by 0x760C54: JOIN::join_free() (sql_select.cc:12273)
 
==211838==    by 0x770361: do_select(JOIN*, Procedure*) (sql_select.cc:18453)
 
==211838==    by 0x749BD1: JOIN::exec_inner() (sql_select.cc:3642)
 
==211838==  Address 0xa33704c is 32,780 bytes inside a block of size 8,011,784 alloc'd
 
==211838==    at 0x483B7F3: malloc (in /usr/lib/x86_64-linux-gnu/valgrind/vgpreload_memcheck-amd64-linux.so)
 
==211838==    by 0x113250E: my_malloc (my_malloc.c:101)
 
==211838==    by 0x115DEE5: my_large_malloc (my_largepage.c:64)
 
==211838==    by 0xF7DE2D: init_pagecache (ma_pagecache.c:830)
 
==211838==    by 0xF5FB24: ha_maria_init(void*) (ha_maria.cc:3606)
 
==211838==    by 0x990749: ha_initialize_handlerton(st_plugin_int*) (handler.cc:555)
 
==211838==    by 0x716FB5: plugin_initialize(st_mem_root*, st_plugin_int*, int*, char**, bool) (sql_plugin.cc:1417)
 
==211838==    by 0x717BE4: plugin_init(int*, char**, int) (sql_plugin.cc:1698)
 
==211838==    by 0x605AD3: init_server_components() (mysqld.cc:5387)
 
==211838==    by 0x606BF3: mysqld_main(int, char**) (mysqld.cc:5996)
 
==211838==    by 0x5FB43C: main (main.cc:25)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112E523: compare_bin (my_compare.c:43)
 
==211838==    by 0x112ED00: ha_key_cmp (my_compare.c:228)
 
==211838==    by 0xFA783D: _ma_seq_search (ma_search.c:387)
 
==211838==    by 0xFA6E0B: _ma_search_no_save (ma_search.c:149)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xFA50D8: maria_rkey (ma_rkey.c:103)
 
==211838==    by 0xF5C9BA: ha_maria::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (ha_maria.cc:2356)
 
==211838==    by 0x995C6B: handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.cc:2718)
 
==211838==    by 0x772662: join_read_always_key(st_join_table*) (sql_select.cc:19614)
 
==211838==    by 0x770B99: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18860)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x770153: do_select(JOIN*, Procedure*) (sql_select.cc:18407)
 
==211838==    by 0x749BD1: JOIN::exec_inner() (sql_select.cc:3642)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0x112ED0E: ha_key_cmp (my_compare.c:227)
 
==211838==    by 0xFA783D: _ma_seq_search (ma_search.c:387)
 
==211838==    by 0xFA6E0B: _ma_search_no_save (ma_search.c:149)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xFA50D8: maria_rkey (ma_rkey.c:103)
 
==211838==    by 0xF5C9BA: ha_maria::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (ha_maria.cc:2356)
 
==211838==    by 0x995C6B: handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.cc:2718)
 
==211838==    by 0x772662: join_read_always_key(st_join_table*) (sql_select.cc:19614)
 
==211838==    by 0x770B99: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18860)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x770153: do_select(JOIN*, Procedure*) (sql_select.cc:18407)
 
==211838==    by 0x749BD1: JOIN::exec_inner() (sql_select.cc:3642)
 
==211838==    by 0x749075: JOIN::exec() (sql_select.cc:3437)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0xFA784B: _ma_seq_search (ma_search.c:387)
 
==211838==    by 0xFA6E0B: _ma_search_no_save (ma_search.c:149)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xFA50D8: maria_rkey (ma_rkey.c:103)
 
==211838==    by 0xF5C9BA: ha_maria::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (ha_maria.cc:2356)
 
==211838==    by 0x995C6B: handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.cc:2718)
 
==211838==    by 0x772662: join_read_always_key(st_join_table*) (sql_select.cc:19614)
 
==211838==    by 0x770B99: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18860)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x770153: do_select(JOIN*, Procedure*) (sql_select.cc:18407)
 
==211838==    by 0x749BD1: JOIN::exec_inner() (sql_select.cc:3642)
 
==211838==    by 0x749075: JOIN::exec() (sql_select.cc:3437)
 
==211838==    by 0x74A253: 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:3840)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0xFA78DC: _ma_seq_search (ma_search.c:397)
 
==211838==    by 0xFA6E0B: _ma_search_no_save (ma_search.c:149)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xFA50D8: maria_rkey (ma_rkey.c:103)
 
==211838==    by 0xF5C9BA: ha_maria::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (ha_maria.cc:2356)
 
==211838==    by 0x995C6B: handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.cc:2718)
 
==211838==    by 0x772662: join_read_always_key(st_join_table*) (sql_select.cc:19614)
 
==211838==    by 0x770B99: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18860)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x770153: do_select(JOIN*, Procedure*) (sql_select.cc:18407)
 
==211838==    by 0x749BD1: JOIN::exec_inner() (sql_select.cc:3642)
 
==211838==    by 0x749075: JOIN::exec() (sql_select.cc:3437)
 
==211838==    by 0x74A253: 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:3840)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0xFA6E1C: _ma_search_no_save (ma_search.c:151)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xFA50D8: maria_rkey (ma_rkey.c:103)
 
==211838==    by 0xF5C9BA: ha_maria::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (ha_maria.cc:2356)
 
==211838==    by 0x995C6B: handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.cc:2718)
 
==211838==    by 0x772662: join_read_always_key(st_join_table*) (sql_select.cc:19614)
 
==211838==    by 0x770B99: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18860)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x770153: do_select(JOIN*, Procedure*) (sql_select.cc:18407)
 
==211838==    by 0x749BD1: JOIN::exec_inner() (sql_select.cc:3642)
 
==211838==    by 0x749075: JOIN::exec() (sql_select.cc:3437)
 
==211838==    by 0x74A253: 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:3840)
 
==211838==    by 0x73E255: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:361)
 
==211838== Conditional jump or move depends on uninitialised value(s)
 
==211838==    at 0xFA6E75: _ma_search_no_save (ma_search.c:162)
 
==211838==    by 0xFA6B0E: _ma_search (ma_search.c:77)
 
==211838==    by 0xFA50D8: maria_rkey (ma_rkey.c:103)
 
==211838==    by 0xF5C9BA: ha_maria::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (ha_maria.cc:2356)
 
==211838==    by 0x995C6B: handler::ha_index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.cc:2718)
 
==211838==    by 0x772662: join_read_always_key(st_join_table*) (sql_select.cc:19614)
 
==211838==    by 0x770B99: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18860)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x771315: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:19083)
 
==211838==    by 0x770BFC: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:18863)
 
==211838==    by 0x770153: do_select(JOIN*, Procedure*) (sql_select.cc:18407)
 
==211838==    by 0x749BD1: JOIN::exec_inner() (sql_select.cc:3642)
 
==211838==    by 0x749075: JOIN::exec() (sql_select.cc:3437)
 
==211838==    by 0x74A253: 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:3840)
 
==211838==    by 0x73E255: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:361)

Valgrind warnings and the result diff are reproducible on current 10.2, but not 10.3+.

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