[MDEV-3852] Valgrind warnings on SELECT from INFORMATION_SCHEMA.INNODB_BUFFER_POOL_PAGES with ORDER BY - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Minor
Resolution: Won't Fix
Affects Version/s: 5.3.9, 5.3.11, 5.2.13, 5.1.66
Fix Version/s: N/A
Component/s: Storage Engine - InnoDB, Storage Engine - XtraDB
Labels:
- upstream
- valgrind

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

Attachments

Issue Links

links to

Percona:1095544

Activity

Ascending order - Click to sort in descending order

Sergei Golubchik added a comment - 2013-01-02 02:10

Elena, is that really 5.3 only?

Sergei Golubchik added a comment - 2013-01-02 02:10 Elena, is that really 5.3 only?

Elena Stepanova added a comment - 2013-01-03 09:32

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.

Elena Stepanova added a comment - 2013-01-03 09:32 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.

Daniel Black added a comment - 2017-12-30 03:24

Affected versions are no longer supported.

Daniel Black added a comment - 2017-12-30 03:24 Affected versions are no longer supported.

People

Assignee:: Unassigned

Reporter:: Elena Stepanova

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2012-11-11 16:36

Updated:: 2017-12-30 03:24

Resolved:: 2017-12-30 03:24

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server