(select min(`t52_1`.`col583`) as `col583`  from t52 as `t52_1`  where `t52_1`.`col583`  <=> 
    (select `t52_1`.`col582`  from t52 as `t52_1`  where `t52_1`.`col582` <= '' 
     order by  `t52_1`.`col583` )
    having `col583` > '12345' );



Version: '5.5.10-valgrind-max-debug'  socket: 'sock'  port: 3306  Source distribution
==18046== Thread 19:
==18046== Conditional jump or move depends on uninitialised value(s)
==18046==    at 0x9F18B5: dfield_get_len (data0data.ic:92)
==18046==    by 0x9F2B65: dtuple_validate (data0data.c:273)
==18046==    by 0xA56A7B: page_cur_search_with_match (page0cur.c:300)
==18046==    by 0x9C808C: btr_cur_search_to_nth_level (btr0cur.c:699)
==18046==    by 0x9D1D13: btr_pcur_open_with_no_init_func (btr0pcur.ic:542)
==18046==    by 0x98FB4E: row_search_for_mysql (row0sel.c:3799)
==18046==    by 0x965472: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5665)
==18046==    by 0x75B621: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490)
==18046==    by 0x845673: get_index_min_value(TABLE*, st_table_ref*, Item_field*, unsigned int, unsigned int) (opt_sum.cc:138)
==18046==    by 0x845E2F: opt_sum_query(TABLE_LIST*, List<Item>&, Item*) (opt_sum.cc:382)
==18046==    by 0x61DF0F: JOIN::optimize() (sql_select.cc:990)
==18046==    by 0x623C05: mysql_select(THD*, Item***, 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:2557)
==18046==    by 0x61BE3F: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297)
==18046==    by 0x5F8A6D: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4472)
==18046==    by 0x5F1626: mysql_execute_command(THD*) (sql_parse.cc:2053)
==18046==    by 0x5FABD1: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5509)
==18046==    by 0x5EEF04: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1035)
==18046==    by 0x5EE210: do_command(THD*) (sql_parse.cc:772)
==18046==    by 0x6CB885: do_handle_one_connection(THD*) (sql_connect.cc:748)
==18046==    by 0x6CB416: handle_one_connection (sql_connect.cc:684)
==18046==    by 0x30E1807760: start_thread (pthread_create.c:301)
==18046==    by 0x1AAF170F: ???
==18046==  Uninitialised value was created by a stack allocation
==18046==    at 0x8458BB: opt_sum_query(TABLE_LIST*, List<Item>&, Item*) (opt_sum.cc:235)
==18046== 
==18046== 
==18046== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- n
==18046== Conditional jump or move depends on uninitialised value(s)
==18046==    at 0x9F2B79: dtuple_validate (data0data.c:275)
==18046==    by 0xA56A7B: page_cur_search_with_match (page0cur.c:300)
==18046==    by 0x9C808C: btr_cur_search_to_nth_level (btr0cur.c:699)
==18046==    by 0x9D1D13: btr_pcur_open_with_no_init_func (btr0pcur.ic:542)
==18046==    by 0x98FB4E: row_search_for_mysql (row0sel.c:3799)
==18046==    by 0x965472: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5665)
==18046==    by 0x75B621: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490)
==18046==    by 0x845673: get_index_min_value(TABLE*, st_table_ref*, Item_field*, unsigned int, unsigned int) (opt_sum.cc:138)
==18046==    by 0x845E2F: opt_sum_query(TABLE_LIST*, List<Item>&, Item*) (opt_sum.cc:382)
==18046==    by 0x61DF0F: JOIN::optimize() (sql_select.cc:990)
==18046==    by 0x623C05: mysql_select(THD*, Item***, 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:2557)
==18046==    by 0x61BE3F: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297)
==18046==    by 0x5F8A6D: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4472)
==18046==    by 0x5F1626: mysql_execute_command(THD*) (sql_parse.cc:2053)
==18046==    by 0x5FABD1: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5509)
==18046==    by 0x5EEF04: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1035)
==18046==    by 0x5EE210: do_command(THD*) (sql_parse.cc:772)
==18046==    by 0x6CB885: do_handle_one_connection(THD*) (sql_connect.cc:748)
==18046==    by 0x6CB416: handle_one_connection (sql_connect.cc:684)
==18046==    by 0x30E1807760: start_thread (pthread_create.c:301)
==18046==    by 0x1AAF170F: ???
==18046==  Uninitialised value was created by a stack allocation
==18046==    at 0x8458BB: opt_sum_query(TABLE_LIST*, List<Item>&, Item*) (opt_sum.cc:235)
==18046== 
==18046== 
==18046== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- n
==18046== Conditional jump or move depends on uninitialised value(s)
==18046==    at 0x9F1825: dfield_get_data (data0data.ic:75)
==18046==    by 0x9F2B86: dtuple_validate (data0data.c:277)
==18046==    by 0xA56A7B: page_cur_search_with_match (page0cur.c:300)
==18046==    by 0x9C808C: btr_cur_search_to_nth_level (btr0cur.c:699)
==18046==    by 0x9D1D13: btr_pcur_open_with_no_init_func (btr0pcur.ic:542)
==18046==    by 0x98FB4E: row_search_for_mysql (row0sel.c:3799)
==18046==    by 0x965472: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5665)
==18046==    by 0x75B621: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490)
==18046==    by 0x845673: get_index_min_value(TABLE*, st_table_ref*, Item_field*, unsigned int, unsigned int) (opt_sum.cc:138)
==18046==    by 0x845E2F: opt_sum_query(TABLE_LIST*, List<Item>&, Item*) (opt_sum.cc:382)
==18046==    by 0x61DF0F: JOIN::optimize() (sql_select.cc:990)
==18046==    by 0x623C05: mysql_select(THD*, Item***, 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:2557)
==18046==    by 0x61BE3F: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297)
==18046==    by 0x5F8A6D: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4472)
==18046==    by 0x5F1626: mysql_execute_command(THD*) (sql_parse.cc:2053)
==18046==    by 0x5FABD1: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5509)
==18046==    by 0x5EEF04: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1035)
==18046==    by 0x5EE210: do_command(THD*) (sql_parse.cc:772)
==18046==    by 0x6CB885: do_handle_one_connection(THD*) (sql_connect.cc:748)
==18046==    by 0x6CB416: handle_one_connection (sql_connect.cc:684)
==18046==    by 0x30E1807760: start_thread (pthread_create.c:301)
==18046==    by 0x1AAF170F: ???
==18046==  Uninitialised value was created by a stack allocation
==18046==    at 0x8458BB: opt_sum_query(TABLE_LIST*, List<Item>&, Item*) (opt_sum.cc:235)
==18046== 
==18046== 
==18046== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- n
==18046== Conditional jump or move depends on uninitialised value(s)
==18046==    at 0x9F2BC1: dtuple_validate (data0data.c:281)
==18046==    by 0xA56A7B: page_cur_search_with_match (page0cur.c:300)
==18046==    by 0x9C808C: btr_cur_search_to_nth_level (btr0cur.c:699)
==18046==    by 0x9D1D13: btr_pcur_open_with_no_init_func (btr0pcur.ic:542)
==18046==    by 0x98FB4E: row_search_for_mysql (row0sel.c:3799)
==18046==    by 0x965472: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5665)
==18046==    by 0x75B621: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490)
==18046==    by 0x845673: get_index_min_value(TABLE*, st_table_ref*, Item_field*, unsigned int, unsigned int) (opt_sum.cc:138)
==18046==    by 0x845E2F: opt_sum_query(TABLE_LIST*, List<Item>&, Item*) (opt_sum.cc:382)
==18046==    by 0x61DF0F: JOIN::optimize() (sql_select.cc:990)
==18046==    by 0x623C05: mysql_select(THD*, Item***, 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:2557)
==18046==    by 0x61BE3F: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297)
==18046==    by 0x5F8A6D: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4472)
==18046==    by 0x5F1626: mysql_execute_command(THD*) (sql_parse.cc:2053)
==18046==    by 0x5FABD1: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5509)
==18046==    by 0x5EEF04: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1035)
==18046==    by 0x5EE210: do_command(THD*) (sql_parse.cc:772)
==18046==    by 0x6CB885: do_handle_one_connection(THD*) (sql_connect.cc:748)
==18046==    by 0x6CB416: handle_one_connection (sql_connect.cc:684)
==18046==    by 0x30E1807760: start_thread (pthread_create.c:301)
==18046==    by 0x1AAF170F: ???
==18046==  Uninitialised value was created by a stack allocation
==18046==    at 0x8458BB: opt_sum_query(TABLE_LIST*, List<Item>&, Item*) (opt_sum.cc:235)
==18046== 
==18046== 
==18046== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- n
==18046== Invalid read of size 1
==18046==    at 0x9F2B99: dtuple_validate (data0data.c:283)
==18046==    by 0xA56A7B: page_cur_search_with_match (page0cur.c:300)
==18046==    by 0x9C808C: btr_cur_search_to_nth_level (btr0cur.c:699)
==18046==    by 0x9D1D13: btr_pcur_open_with_no_init_func (btr0pcur.ic:542)
==18046==    by 0x98FB4E: row_search_for_mysql (row0sel.c:3799)
==18046==    by 0x965472: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5665)
==18046==    by 0x75B621: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490)
==18046==    by 0x845673: get_index_min_value(TABLE*, st_table_ref*, Item_field*, unsigned int, unsigned int) (opt_sum.cc:138)
==18046==    by 0x845E2F: opt_sum_query(TABLE_LIST*, List<Item>&, Item*) (opt_sum.cc:382)
==18046==    by 0x61DF0F: JOIN::optimize() (sql_select.cc:990)
==18046==    by 0x623C05: mysql_select(THD*, Item***, 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:2557)
==18046==    by 0x61BE3F: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297)
==18046==    by 0x5F8A6D: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4472)
==18046==    by 0x5F1626: mysql_execute_command(THD*) (sql_parse.cc:2053)
==18046==    by 0x5FABD1: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5509)
==18046==    by 0x5EEF04: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1035)
==18046==    by 0x5EE210: do_command(THD*) (sql_parse.cc:772)
==18046==    by 0x6CB885: do_handle_one_connection(THD*) (sql_connect.cc:748)
==18046==    by 0x6CB416: handle_one_connection (sql_connect.cc:684)
==18046==    by 0x30E1807760: start_thread (pthread_create.c:301)
==18046==    by 0x1AAF170F: ???
==18046==  Address 0x1aaf2000 is not stack'd, malloc'd or (recently) free'd
==18046== 
==18046== 
==18046== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ---- n
==18046== 
==18046== Process terminating with default action of signal 11 (SIGSEGV)
==18046==  Access not within mapped region at address 0x1AAF2000
==18046==    at 0x9F2B99: dtuple_validate (data0data.c:283)
==18046==    by 0xA56A7B: page_cur_search_with_match (page0cur.c:300)
==18046==    by 0x9C808C: btr_cur_search_to_nth_level (btr0cur.c:699)
==18046==    by 0x9D1D13: btr_pcur_open_with_no_init_func (btr0pcur.ic:542)
==18046==    by 0x98FB4E: row_search_for_mysql (row0sel.c:3799)
==18046==    by 0x965472: ha_innobase::index_read(unsigned char*, unsigned char const*, unsigned int, ha_rkey_function) (ha_innodb.cc:5665)
==18046==    by 0x75B621: handler::index_read_map(unsigned char*, unsigned char const*, unsigned long, ha_rkey_function) (handler.h:1490)
==18046==    by 0x845673: get_index_min_value(TABLE*, st_table_ref*, Item_field*, unsigned int, unsigned int) (opt_sum.cc:138)
==18046==    by 0x845E2F: opt_sum_query(TABLE_LIST*, List<Item>&, Item*) (opt_sum.cc:382)
==18046==    by 0x61DF0F: JOIN::optimize() (sql_select.cc:990)
==18046==    by 0x623C05: mysql_select(THD*, Item***, 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:2557)
==18046==    by 0x61BE3F: handle_select(THD*, LEX*, select_result*, unsigned long) (sql_select.cc:297)
==18046==    by 0x5F8A6D: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:4472)
==18046==    by 0x5F1626: mysql_execute_command(THD*) (sql_parse.cc:2053)
==18046==    by 0x5FABD1: mysql_parse(THD*, char*, unsigned int, Parser_state*) (sql_parse.cc:5509)
==18046==    by 0x5EEF04: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1035)
==18046==    by 0x5EE210: do_command(THD*) (sql_parse.cc:772)
==18046==    by 0x6CB885: do_handle_one_connection(THD*) (sql_connect.cc:748)
==18046==    by 0x6CB416: handle_one_connection (sql_connect.cc:684)
==18046==    by 0x30E1807760: start_thread (pthread_create.c:301)
==18046==    by 0x1AAF170F: ???
==18046==  If you believe this happened as a result of a stack
==18046==  overflow in your program's main thread (unlikely but
==18046==  possible), you can try to increase the size of the
==18046==  main thread stack using the --main-stacksize= flag.
==18046==  The main thread stack size used in this run was 10485760.
==18046== 
==18046== ---- Attach to debugger ? --- [Return/N/n/Y/y/C/c] ----