some infos: ----------- valgrind -v --leak-check=full --show-reachable=yes --db-attach=yes --track-origins=yes --tool=memcheck --num-callers=50 ./bin/mysqld --no-defaults --basedir=. --datadir=./data --skip-gr --skip-na --myisam-recover=force --open-files-limit=2000 --port=3306 --gdb [sbester@levovo mysql-5.5.9-linux-x86_64]$ valgrind --version valgrind-3.5.0 [sbester@levovo mysql-5.5.9-linux-x86_64]$ uname -a Linux levovo 2.6.33.3-85.fc13.x86_64 #1 SMP Thu May 6 18:09:49 UTC 2010 x86_64 x86_64 x86_64 GNU/Linux [sbester@levovo mysql-5.5.9-linux-x86_64]$ rpm -qa |grep glibc glibc-debuginfo-2.12-3.x86_64 glibc-common-2.12-3.x86_64 glibc-2.12-3.x86_64 glibc-devel-2.12-3.x86_64 glibc-headers-2.12-3.x86_64 glibc-2.12-3.i686 [sbester@levovo mysql-5.5.9-linux-x86_64]$ cat /etc/re readahead.conf reader.conf.d/ redhat-release report.d/ resolv.conf reader.conf redhat-lsb/ report.conf request-key.conf [sbester@levovo mysql-5.5.9-linux-x86_64]$ cat /etc/redhat-release Fedora release 13 (Goddard) [sbester@levovo mysql-5.5.9-linux-x86_64]$ drop table if exists `t1`; create table `t1`(`a` int not null,key (`a`)) engine=myisam; insert into `t1` values (0),(1); select 1 from `t1` where `a` < some (select `a` from `t1` where `a` <=> (select `a` from `t1`) ); Version: '5.5.9-valgrind-max-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution ==13817== Thread 17: ==13817== Conditional jump or move depends on uninitialised value(s) ==13817== at 0xA86491: ha_key_cmp (my_handler.c:308) ==13817== by 0x8EF48B: _mi_bin_search (mi_search.c:200) ==13817== by 0x8EEE10: _mi_search (mi_search.c:89) ==13817== by 0x90F819: mi_rkey (mi_rkey.c:94) ==13817== by 0x8B78C2: ha_myisam::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (ha_myisam.cc:1558) ==13817== by 0x841C50: get_index_max_value(TABLE*, st_table_ref*, unsigned int) (opt_sum.cc:207) ==13817== by 0x8421D4: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:382) ==13817== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==13817== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==13817== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==13817== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==13817== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==13817== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==13817== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==13817== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==13817== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==13817== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==13817== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==13817== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==13817== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==13817== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==13817== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==13817== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==13817== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==13817== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==13817== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==13817== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==13817== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==13817== by 0x30E1807760: start_thread (pthread_create.c:301) ==13817== by 0x1AA6F70F: ??? ==13817== Uninitialised value was created by a stack allocation ==13817== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==13817== ==13817== ==13817== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- c ==13817== Conditional jump or move depends on uninitialised value(s) ==13817== at 0xA86491: ha_key_cmp (my_handler.c:308) ==13817== by 0x8EF4DF: _mi_bin_search (mi_search.c:208) ==13817== by 0x8EEE10: _mi_search (mi_search.c:89) ==13817== by 0x90F819: mi_rkey (mi_rkey.c:94) ==13817== by 0x8B78C2: ha_myisam::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (ha_myisam.cc:1558) ==13817== by 0x841C50: get_index_max_value(TABLE*, st_table_ref*, unsigned int) (opt_sum.cc:207) ==13817== by 0x8421D4: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:382) ==13817== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==13817== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==13817== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==13817== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==13817== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==13817== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==13817== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==13817== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==13817== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==13817== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==13817== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==13817== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==13817== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==13817== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==13817== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==13817== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==13817== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==13817== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==13817== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==13817== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==13817== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==13817== by 0x30E1807760: start_thread (pthread_create.c:301) ==13817== by 0x1AA6F70F: ??? ==13817== Uninitialised value was created by a stack allocation ==13817== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==13817== ==13817== Conditional jump or move depends on uninitialised value(s) ==13817== at 0x4A07199: bcmp (mc_replace_strmem.c:541) ==13817== by 0x7ED851: key_cmp_if_same(TABLE*, unsigned char const*, unsigned int, unsigned int) (key.cc:309) ==13817== by 0x843474: reckey_in_range(bool, st_table_ref*, Field*, Item*, unsigned int, unsigned int) (opt_sum.cc:928) ==13817== by 0x842247: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:385) ==13817== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==13817== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==13817== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==13817== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==13817== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==13817== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==13817== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==13817== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==13817== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==13817== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==13817== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==13817== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==13817== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==13817== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==13817== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==13817== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==13817== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==13817== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==13817== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==13817== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==13817== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==13817== by 0x30E1807760: start_thread (pthread_create.c:301) ==13817== by 0x1AA6F70F: ??? ==13817== Uninitialised value was created by a stack allocation ==13817== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==13817== ==13817== Conditional jump or move depends on uninitialised value(s) ==13817== at 0x7ED854: key_cmp_if_same(TABLE*, unsigned char const*, unsigned int, unsigned int) (key.cc:309) ==13817== by 0x843474: reckey_in_range(bool, st_table_ref*, Field*, Item*, unsigned int, unsigned int) (opt_sum.cc:928) ==13817== by 0x842247: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:385) ==13817== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==13817== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==13817== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==13817== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==13817== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==13817== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==13817== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==13817== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==13817== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==13817== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==13817== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==13817== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==13817== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==13817== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==13817== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==13817== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==13817== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==13817== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==13817== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==13817== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==13817== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==13817== by 0x30E1807760: start_thread (pthread_create.c:301) ==13817== by 0x1AA6F70F: ??? ==13817== Uninitialised value was created by a stack allocation ==13817== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==13817== drop table if exists `t1`; create table `t1`(`a` int not null,key (`a`)) engine=innodb; insert into `t1` values (0),(1); select 1 from `t1` where `a` < some (select `a` from `t1` where `a` <=> (select `a` from `t1`) ); Version: '5.5.9-valgrind-max-debug' socket: '/tmp/mysql.sock' port: 3306 Source distribution ==14085== Thread 17: ==14085== Conditional jump or move depends on uninitialised value(s) ==14085== at 0xA3633B: cmp_dtuple_rec_with_match (rem0cmp.c:582) ==14085== by 0xA1D36A: page_cur_search_with_match (page0cur.c:437) ==14085== by 0x98EF30: btr_cur_search_to_nth_level (btr0cur.c:699) ==14085== by 0x998D37: btr_pcur_open_with_no_init_func (btr0pcur.ic:542) ==14085== by 0x957DAE: row_search_for_mysql (row0sel.c:3799) ==14085== by 0x92D7E2: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5663) ==14085== by 0x758CDB: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490) ==14085== by 0x841C50: get_index_max_value(TABLE*, st_table_ref*, unsigned int) (opt_sum.cc:207) ==14085== by 0x8421D4: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:382) ==14085== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==14085== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==14085== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==14085== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==14085== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==14085== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==14085== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==14085== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==14085== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==14085== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==14085== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==14085== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==14085== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==14085== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==14085== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==14085== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==14085== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==14085== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==14085== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==14085== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==14085== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==14085== by 0x30E1807760: start_thread (pthread_create.c:301) ==14085== by 0x1AA6F70F: ??? ==14085== Uninitialised value was created by a stack allocation ==14085== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==14085== ==14085== ==14085== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- c ==14085== Conditional jump or move depends on uninitialised value(s) ==14085== at 0xA36394: cmp_dtuple_rec_with_match (rem0cmp.c:599) ==14085== by 0xA1D36A: page_cur_search_with_match (page0cur.c:437) ==14085== by 0x98EF30: btr_cur_search_to_nth_level (btr0cur.c:699) ==14085== by 0x998D37: btr_pcur_open_with_no_init_func (btr0pcur.ic:542) ==14085== by 0x957DAE: row_search_for_mysql (row0sel.c:3799) ==14085== by 0x92D7E2: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5663) ==14085== by 0x758CDB: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490) ==14085== by 0x841C50: get_index_max_value(TABLE*, st_table_ref*, unsigned int) (opt_sum.cc:207) ==14085== by 0x8421D4: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:382) ==14085== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==14085== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==14085== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==14085== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==14085== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==14085== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==14085== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==14085== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==14085== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==14085== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==14085== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==14085== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==14085== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==14085== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==14085== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==14085== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==14085== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==14085== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==14085== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==14085== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==14085== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==14085== by 0x30E1807760: start_thread (pthread_create.c:301) ==14085== by 0x1AA6F70F: ??? ==14085== Uninitialised value was created by a stack allocation ==14085== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==14085== ==14085== Conditional jump or move depends on uninitialised value(s) ==14085== at 0xA3639A: cmp_dtuple_rec_with_match (rem0cmp.c:600) ==14085== by 0xA1D36A: page_cur_search_with_match (page0cur.c:437) ==14085== by 0x98EF30: btr_cur_search_to_nth_level (btr0cur.c:699) ==14085== by 0x998D37: btr_pcur_open_with_no_init_func (btr0pcur.ic:542) ==14085== by 0x957DAE: row_search_for_mysql (row0sel.c:3799) ==14085== by 0x92D7E2: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5663) ==14085== by 0x758CDB: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490) ==14085== by 0x841C50: get_index_max_value(TABLE*, st_table_ref*, unsigned int) (opt_sum.cc:207) ==14085== by 0x8421D4: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:382) ==14085== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==14085== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==14085== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==14085== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==14085== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==14085== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==14085== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==14085== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==14085== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==14085== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==14085== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==14085== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==14085== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==14085== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==14085== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==14085== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==14085== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==14085== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==14085== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==14085== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==14085== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==14085== by 0x30E1807760: start_thread (pthread_create.c:301) ==14085== by 0x1AA6F70F: ??? ==14085== Uninitialised value was created by a stack allocation ==14085== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==14085== ==14085== Conditional jump or move depends on uninitialised value(s) ==14085== at 0xA35DE2: cmp_data_data_slow (rem0cmp.c:367) ==14085== by 0xA35681: cmp_data_data (rem0cmp.ic:43) ==14085== by 0xA373DC: cmp_debug_dtuple_rec_with_match (rem0cmp.c:1181) ==14085== by 0xA3648D: cmp_dtuple_rec_with_match (rem0cmp.c:626) ==14085== by 0xA1D36A: page_cur_search_with_match (page0cur.c:437) ==14085== by 0x98EF30: btr_cur_search_to_nth_level (btr0cur.c:699) ==14085== by 0x998D37: btr_pcur_open_with_no_init_func (btr0pcur.ic:542) ==14085== by 0x957DAE: row_search_for_mysql (row0sel.c:3799) ==14085== by 0x92D7E2: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5663) ==14085== by 0x758CDB: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490) ==14085== by 0x841C50: get_index_max_value(TABLE*, st_table_ref*, unsigned int) (opt_sum.cc:207) ==14085== by 0x8421D4: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:382) ==14085== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==14085== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==14085== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==14085== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==14085== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==14085== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==14085== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==14085== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==14085== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==14085== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==14085== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==14085== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==14085== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==14085== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==14085== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==14085== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==14085== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==14085== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==14085== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==14085== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==14085== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==14085== by 0x30E1807760: start_thread (pthread_create.c:301) ==14085== by 0x1AA6F70F: ??? ==14085== Uninitialised value was created by a stack allocation ==14085== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==14085== ==14085== Conditional jump or move depends on uninitialised value(s) ==14085== at 0xA35E28: cmp_data_data_slow (rem0cmp.c:382) ==14085== by 0xA35681: cmp_data_data (rem0cmp.ic:43) ==14085== by 0xA373DC: cmp_debug_dtuple_rec_with_match (rem0cmp.c:1181) ==14085== by 0xA3648D: cmp_dtuple_rec_with_match (rem0cmp.c:626) ==14085== by 0xA1D36A: page_cur_search_with_match (page0cur.c:437) ==14085== by 0x98EF30: btr_cur_search_to_nth_level (btr0cur.c:699) ==14085== by 0x998D37: btr_pcur_open_with_no_init_func (btr0pcur.ic:542) ==14085== by 0x957DAE: row_search_for_mysql (row0sel.c:3799) ==14085== by 0x92D7E2: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5663) ==14085== by 0x758CDB: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490) ==14085== by 0x841C50: get_index_max_value(TABLE*, st_table_ref*, unsigned int) (opt_sum.cc:207) ==14085== by 0x8421D4: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:382) ==14085== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==14085== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==14085== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==14085== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==14085== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==14085== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==14085== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==14085== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==14085== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==14085== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==14085== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==14085== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==14085== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==14085== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==14085== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==14085== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==14085== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==14085== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==14085== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==14085== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==14085== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==14085== by 0x30E1807760: start_thread (pthread_create.c:301) ==14085== by 0x1AA6F70F: ??? ==14085== Uninitialised value was created by a stack allocation ==14085== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==14085== ==14085== Conditional jump or move depends on uninitialised value(s) ==14085== at 0x4A07199: bcmp (mc_replace_strmem.c:541) ==14085== by 0x7ED851: key_cmp_if_same(TABLE*, unsigned char const*, unsigned int, unsigned int) (key.cc:309) ==14085== by 0x843474: reckey_in_range(bool, st_table_ref*, Field*, Item*, unsigned int, unsigned int) (opt_sum.cc:928) ==14085== by 0x842247: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:385) ==14085== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==14085== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==14085== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==14085== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==14085== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==14085== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==14085== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==14085== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==14085== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==14085== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==14085== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==14085== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==14085== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==14085== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==14085== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==14085== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==14085== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==14085== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==14085== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==14085== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==14085== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==14085== by 0x30E1807760: start_thread (pthread_create.c:301) ==14085== by 0x1AA6F70F: ??? ==14085== Uninitialised value was created by a stack allocation ==14085== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==14085== ==14085== Conditional jump or move depends on uninitialised value(s) ==14085== at 0x7ED854: key_cmp_if_same(TABLE*, unsigned char const*, unsigned int, unsigned int) (key.cc:309) ==14085== by 0x843474: reckey_in_range(bool, st_table_ref*, Field*, Item*, unsigned int, unsigned int) (opt_sum.cc:928) ==14085== by 0x842247: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:385) ==14085== by 0x61C347: JOIN::optimize() (sql_select.cc:989) ==14085== by 0x7D17D5: subselect_single_select_engine::exec() (item_subselect.cc:1905) ==14085== by 0x7CC6D4: Item_subselect::exec() (item_subselect.cc:288) ==14085== by 0x7CD4AF: Item_singlerow_subselect::val_int() (item_subselect.cc:601) ==14085== by 0x77B2DC: Arg_comparator::compare_int_signed() (item_cmpfunc.cc:1474) ==14085== by 0x788E70: Arg_comparator::compare() (item_cmpfunc.h:88) ==14085== by 0x77C97A: Item_func_lt::val_int() (item_cmpfunc.cc:2011) ==14085== by 0x778387: Item_func_nop_all::val_int() (item_cmpfunc.cc:359) ==14085== by 0x638D22: evaluate_join_record(JOIN*, st_join_table*, int) (sql_select.cc:11711) ==14085== by 0x638B8C: sub_select(JOIN*, st_join_table*, bool) (sql_select.cc:11663) ==14085== by 0x63874D: do_select(JOIN*, List*, TABLE*, Procedure*) (sql_select.cc:11428) ==14085== by 0x621920: JOIN::exec() (sql_select.cc:2361) ==14085== by 0x6220CF: mysql_select(THD*, Item***, TABLE_LIST*, unsigned int, List&, 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:2570) ==14085== by 0x61A27B: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297) ==14085== by 0x5F6ECC: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4452) ==14085== by 0x5EFAC1: mysql_execute_command(THD*) (sql_parse.cc:2046) ==14085== by 0x5F905A: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5496) ==14085== by 0x5ED429: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1032) ==14085== by 0x5ECA45: do_command(THD*) (sql_parse.cc:772) ==14085== by 0x6C9189: do_handle_one_connection(THD*) (sql_connect.cc:745) ==14085== by 0x6C8FC3: handle_one_connection (sql_connect.cc:684) ==14085== by 0x30E1807760: start_thread (pthread_create.c:301) ==14085== by 0x1AA6F70F: ??? ==14085== Uninitialised value was created by a stack allocation ==14085== at 0x841C8B: opt_sum_query(TABLE_LIST*, List&, Item*) (opt_sum.cc:235) ==14085==