[MDEV-3852] Valgrind warnings on SELECT from INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES with ORDER BY Created: 2012-11-11  Updated: 2017-12-30  Resolved: 2017-12-30

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Affects Version/s: 5.3.9, 5.3.11, 5.2.13, 5.1.66
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: upstream, valgrind

Issue Links:
Relates

 Description   

Also reproducible on Percona server 5.1/5.5 and filed as https://bugs.launchpad.net/percona-server/+bug/1095544

# In MTR, run as 
# perl ./mtr --valgrind-mysqld  --mysqld=--innodb --mysqld=--innodb-buffer-pool-pages <test name>
 
SET sort_buffer_size=1048576;
SET max_heap_table_size=1048576;
SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES ORDER BY space_id;

==18916== Thread 20:
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0xAD19B8: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:591)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0xAD19C2: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:591)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0xAD19C8: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:591)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0xAD19D2: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:591)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0xAD19D7: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:591)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0xAD1BCF: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:637)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x5BC9F5B: rint (s_rint.c:48)
==18916==    by 0x67083C: double_to_longlong(double, bool, bool*) (field.cc:4224)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C00: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:637)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x5BC9F66: rint (s_rint.c:49)
==18916==    by 0x67083C: double_to_longlong(double, bool, bool*) (field.cc:4224)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C00: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:637)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x5BC9FD5: rint (s_rint.c:50)
==18916==    by 0x67083C: double_to_longlong(double, bool, bool*) (field.cc:4224)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C00: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:637)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x67085A: double_to_longlong(double, bool, bool*) (field.cc:4227)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C00: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:637)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x670882: double_to_longlong(double, bool, bool*) (field.cc:4232)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C00: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:637)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x6708A5: double_to_longlong(double, bool, bool*) (field.cc:4238)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C00: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:637)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0xAD1C26: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:638)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x5BC9F5B: rint (s_rint.c:48)
==18916==    by 0x67083C: double_to_longlong(double, bool, bool*) (field.cc:4224)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C57: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:638)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x5BC9F66: rint (s_rint.c:49)
==18916==    by 0x67083C: double_to_longlong(double, bool, bool*) (field.cc:4224)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C57: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:638)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x5BC9FD5: rint (s_rint.c:50)
==18916==    by 0x67083C: double_to_longlong(double, bool, bool*) (field.cc:4224)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C57: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:638)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x67085A: double_to_longlong(double, bool, bool*) (field.cc:4227)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C57: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:638)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x670882: double_to_longlong(double, bool, bool*) (field.cc:4232)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C57: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:638)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x6708A5: double_to_longlong(double, bool, bool*) (field.cc:4238)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1C57: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:638)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x5BC9F5B: rint (s_rint.c:48)
==18916==    by 0x67083C: double_to_longlong(double, bool, bool*) (field.cc:4224)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1D24: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:641)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x5BC9F66: rint (s_rint.c:49)
==18916==    by 0x67083C: double_to_longlong(double, bool, bool*) (field.cc:4224)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1D24: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:641)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x5BC9FD5: rint (s_rint.c:50)
==18916==    by 0x67083C: double_to_longlong(double, bool, bool*) (field.cc:4224)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1D24: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:641)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x67085A: double_to_longlong(double, bool, bool*) (field.cc:4227)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1D24: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:641)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x670882: double_to_longlong(double, bool, bool*) (field.cc:4232)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1D24: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:641)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Conditional jump or move depends on uninitialised value(s)
==18916==    at 0x6708A5: double_to_longlong(double, bool, bool*) (field.cc:4238)
==18916==    by 0x66F050: Field_longlong::store(double) (field.cc:3749)
==18916==    by 0xAD1D24: i_s_innodb_buffer_pool_pages_fill(THD*, TABLE_LIST*, Item*) (i_s.cc:641)
==18916==    by 0x89E620: get_schema_tables_result(JOIN*, enum_schema_table_state) (sql_show.cc:7089)
==18916==    by 0x74416B: JOIN::exec() (sql_select.cc:2225)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916==    by 0x5F18F4C: clone (clone.S:112)
==18916== Use of uninitialised value of size 8
==18916==    at 0xBF11F2: radixsort_for_str_ptr (mf_radix.c:39)
==18916==    by 0xBEFFAA: my_string_ptr_sort (mf_sort.c:29)
==18916==    by 0x83D7A7: write_keys(st_sort_param*, unsigned char**, unsigned int, st_io_cache*, st_io_cache*) (filesort.cc:722)
==18916==    by 0x83D40F: find_all_keys(st_sort_param*, SQL_SELECT*, unsigned char**, unsigned char*, st_io_cache*, st_io_cache*, st_io_cache*) (filesort.cc:641)
==18916==    by 0x83BF7E: filesort(THD*, st_table*, st_sort_field*, unsigned int, SQL_SELECT*, unsigned long long, bool, unsigned long long*) (filesort.cc:247)
==18916==    by 0x76E340: create_sort_index(THD*, JOIN*, st_order*, unsigned long long, unsigned long long, bool) (sql_select.cc:18790)
==18916==    by 0x7461F6: JOIN::exec() (sql_select.cc:2711)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
==18916== Syscall param write(buf) points to uninitialised byte(s)
==18916==    at 0x549307D: ??? (syscall-template.S:82)
==18916==    by 0xBD7AE1: my_write (my_write.c:51)
==18916==    by 0xBDE4AE: my_b_flush_io_cache (mf_iocache.c:1758)
==18916==    by 0xBDDCAC: _my_b_write (mf_iocache.c:1514)
==18916==    by 0x83D94C: write_keys(st_sort_param*, unsigned char**, unsigned int, st_io_cache*, st_io_cache*) (filesort.cc:736)
==18916==    by 0x83D40F: find_all_keys(st_sort_param*, SQL_SELECT*, unsigned char**, unsigned char*, st_io_cache*, st_io_cache*, st_io_cache*) (filesort.cc:641)
==18916==    by 0x83BF7E: filesort(THD*, st_table*, st_sort_field*, unsigned int, SQL_SELECT*, unsigned long long, bool, unsigned long long*) (filesort.cc:247)
==18916==    by 0x76E340: create_sort_index(THD*, JOIN*, st_order*, unsigned long long, unsigned long long, bool) (sql_select.cc:18790)
==18916==    by 0x7461F6: JOIN::exec() (sql_select.cc:2711)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==  Address 0x22882d10 is 0 bytes inside a block of size 65,536 alloc'd
==18916==    at 0x4C28F9F: malloc (vg_replace_malloc.c:236)
==18916==    by 0xBE16F1: my_malloc (my_malloc.c:42)
==18916==    by 0xBDBD9B: init_io_cache (mf_iocache.c:244)
==18916==    by 0xBE071A: open_cached_file (mf_cache.c:69)
==18916==    by 0x83D7E3: write_keys(st_sort_param*, unsigned char**, unsigned int, st_io_cache*, st_io_cache*) (filesort.cc:726)
==18916==    by 0x83D40F: find_all_keys(st_sort_param*, SQL_SELECT*, unsigned char**, unsigned char*, st_io_cache*, st_io_cache*, st_io_cache*) (filesort.cc:641)
==18916==    by 0x83BF7E: filesort(THD*, st_table*, st_sort_field*, unsigned int, SQL_SELECT*, unsigned long long, bool, unsigned long long*) (filesort.cc:247)
==18916==    by 0x76E340: create_sort_index(THD*, JOIN*, st_order*, unsigned long long, unsigned long long, bool) (sql_select.cc:18790)
==18916==    by 0x7461F6: JOIN::exec() (sql_select.cc:2711)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916== Use of uninitialised value of size 8
==18916==    at 0xBF11F2: radixsort_for_str_ptr (mf_radix.c:39)
==18916==    by 0xBEFFAA: my_string_ptr_sort (mf_sort.c:29)
==18916==    by 0x83D7A7: write_keys(st_sort_param*, unsigned char**, unsigned int, st_io_cache*, st_io_cache*) (filesort.cc:722)
==18916==    by 0x83D62A: find_all_keys(st_sort_param*, SQL_SELECT*, unsigned char**, unsigned char*, st_io_cache*, st_io_cache*, st_io_cache*) (filesort.cc:678)
==18916==    by 0x83BF7E: filesort(THD*, st_table*, st_sort_field*, unsigned int, SQL_SELECT*, unsigned long long, bool, unsigned long long*) (filesort.cc:247)
==18916==    by 0x76E340: create_sort_index(THD*, JOIN*, st_order*, unsigned long long, unsigned long long, bool) (sql_select.cc:18790)
==18916==    by 0x7461F6: JOIN::exec() (sql_select.cc:2711)
==18916==    by 0x746DD2: 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:2983)
==18916==    by 0x73D7EA: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:286)
==18916==    by 0x6C8C82: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5157)
==18916==    by 0x6BFA41: mysql_execute_command(THD*) (sql_parse.cc:2290)
==18916==    by 0x6CB6DA: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6158)
==18916==    by 0x6BD1E7: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1228)
==18916==    by 0x6BC4FB: do_command(THD*) (sql_parse.cc:923)
==18916==    by 0x6B8F54: handle_one_connection (sql_connect.cc:1218)
==18916==    by 0x548BEFB: start_thread (pthread_create.c:304)
 

EXPLAIN EXTENDED SELECT * FROM INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES ORDER BY space_id;
id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	INNODB_BUFFER_POOL_PAGES	ALL	NULL	NULL	NULL	NULL	NULL	NULL	Using filesort
Warnings:
Note	1003	select `INNODB_BUFFER_POOL_PAGES`.`page_type` AS `page_type`,`INNODB_BUFFER_POOL_PAGES`.`space_id` AS `space_id`,`INNODB_BUFFER_POOL_PAGES`.`page_no` AS `page_no`,`INNODB_BUFFER_POOL_PAGES`.`lru_position` AS `lru_position`,`INNODB_BUFFER_POOL_PAGES`.`fix_count` AS `fix_count`,`INNODB_BUFFER_POOL_PAGES`.`flush_type` AS `flush_type` from `INFORMATION_SCHEMA`.`INNODB_BUFFER_POOL_PAGES` order by `INNODB_BUFFER_POOL_PAGES`.`space_id`

branch: maria/5.3
revision-id: timour@askmonty.org-20121219135657-mbje1blpgw2qsw7j
revno: 3607

Also reproducible on current maria/5.1, maria/5.2. Didn't get valgrind warnings on maria/5.5 and maria/10.0-base, although, as stated above, it's reproducible on Percona server 5.5.

All servers were built with BUILD/compile-pentium-valgrind-max-no-ndb



 Comments   
Comment by Sergei Golubchik [ 2013-01-02 ]

Elena, is that really 5.3 only?

Comment by Elena Stepanova [ 2013-01-03 ]

It's also reproducible on 5.1 and 5.2, but I'm not getting the warnings on 5.5 and 10.0-base. However, Percona server 5.5 produces them. I re-filed the bug for percona-server and updated the description of this one.

Comment by Daniel Black [ 2017-12-30 ]

Affected versions are no longer supported.

Generated at Thu Feb 08 06:51:45 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.