[MDEV-4413] Valgrind errors or server crash in Item_field::replace_equal_field on join with a constant table, AND and OR conditions Created: 2013-04-22  Updated: 2013-05-05  Resolved: 2013-05-05

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.1, 5.5.30, 5.3.12
Fix Version/s: 10.0.3, 5.5.31, 5.3.13

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

Issue Links:
Relates

 Description   

The problem appeared on 5.3 with the following revision:

revno: 3628
 
revision-id: igor@askmonty.org-20130225031611-jk8lyhhjazov66qc
 
committer: Igor Babaev <igor@askmonty.org>
 
branch nick: maria-5.3-mdev4177
 
timestamp: Sun 2013-02-24 19:16:11 -0800
 
message:
 
  Fixed bug mdev-4177

Valgrind warnings on 5.3:

==18014== Thread 4:
 
==18014== Conditional jump or move depends on uninitialised value(s)
 
==18014==    at 0x58913E: Item_field::replace_equal_field(unsigned char*) (item.cc:5078)
 
==18014==    by 0x57D35F: Item::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item.cc:647)
 
==18014==    by 0x5AFE6E: Item_func::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item_func.cc:338)
 
==18014==    by 0x72A85F: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12147)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x70DF46: JOIN::optimize() (sql_select.cc:1237)
 
==18014==    by 0x7144E6: 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:2976)
 
==18014==    by 0x70AF26: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:288)
 
==18014==    by 0x6963DE: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5172)
 
==18014==    by 0x68D19D: mysql_execute_command(THD*) (sql_parse.cc:2305)
 
==18014==    by 0x698E58: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
 
==18014==    by 0x68A941: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
 
==18014==    by 0x689BDF: do_command(THD*) (sql_parse.cc:923)
 
==18014==    by 0x68663A: handle_one_connection (sql_connect.cc:1231)
 
==18014== Use of uninitialised value of size 8
 
==18014==    at 0x589144: Item_field::replace_equal_field(unsigned char*) (item.cc:5079)
 
==18014==    by 0x57D35F: Item::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item.cc:647)
 
==18014==    by 0x5AFE6E: Item_func::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item_func.cc:338)
 
==18014==    by 0x72A85F: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12147)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x70DF46: JOIN::optimize() (sql_select.cc:1237)
 
==18014==    by 0x7144E6: 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:2976)
 
==18014==    by 0x70AF26: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:288)
 
==18014==    by 0x6963DE: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5172)
 
==18014==    by 0x68D19D: mysql_execute_command(THD*) (sql_parse.cc:2305)
 
==18014==    by 0x698E58: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
 
==18014==    by 0x68A941: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
 
==18014==    by 0x689BDF: do_command(THD*) (sql_parse.cc:923)
 
==18014==    by 0x68663A: handle_one_connection (sql_connect.cc:1231)
 
==18014== Conditional jump or move depends on uninitialised value(s)
 
==18014==    at 0x589162: Item_field::replace_equal_field(unsigned char*) (item.cc:5080)
 
==18014==    by 0x57D35F: Item::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item.cc:647)
 
==18014==    by 0x5AFE6E: Item_func::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item_func.cc:338)
 
==18014==    by 0x72A85F: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12147)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x70DF46: JOIN::optimize() (sql_select.cc:1237)
 
==18014==    by 0x7144E6: 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:2976)
 
==18014==    by 0x70AF26: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:288)
 
==18014==    by 0x6963DE: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5172)
 
==18014==    by 0x68D19D: mysql_execute_command(THD*) (sql_parse.cc:2305)
 
==18014==    by 0x698E58: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
 
==18014==    by 0x68A941: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
 
==18014==    by 0x689BDF: do_command(THD*) (sql_parse.cc:923)
 
==18014==    by 0x68663A: handle_one_connection (sql_connect.cc:1231)
 
==18014== Use of uninitialised value of size 8
 
==18014==    at 0x58917D: Item_field::replace_equal_field(unsigned char*) (item.cc:5080)
 
==18014==    by 0x57D35F: Item::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item.cc:647)
 
==18014==    by 0x5AFE6E: Item_func::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item_func.cc:338)
 
==18014==    by 0x72A85F: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12147)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x70DF46: JOIN::optimize() (sql_select.cc:1237)
 
==18014==    by 0x7144E6: 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:2976)
 
==18014==    by 0x70AF26: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:288)
 
==18014==    by 0x6963DE: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5172)
 
==18014==    by 0x68D19D: mysql_execute_command(THD*) (sql_parse.cc:2305)
 
==18014==    by 0x698E58: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
 
==18014==    by 0x68A941: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
 
==18014==    by 0x689BDF: do_command(THD*) (sql_parse.cc:923)
 
==18014==    by 0x68663A: handle_one_connection (sql_connect.cc:1231)
 
==18014== Conditional jump or move depends on uninitialised value(s)
 
==18014==    at 0x5AFE78: Item_func::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item_func.cc:339)
 
==18014==    by 0x72A85F: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12147)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x70DF46: JOIN::optimize() (sql_select.cc:1237)
 
==18014==    by 0x7144E6: 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:2976)
 
==18014==    by 0x70AF26: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:288)
 
==18014==    by 0x6963DE: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5172)
 
==18014==    by 0x68D19D: mysql_execute_command(THD*) (sql_parse.cc:2305)
 
==18014==    by 0x698E58: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
 
==18014==    by 0x68A941: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
 
==18014==    by 0x689BDF: do_command(THD*) (sql_parse.cc:923)
 
==18014==    by 0x68663A: handle_one_connection (sql_connect.cc:1231)
 
==18014==    by 0x548DE99: start_thread (pthread_create.c:308)
 
==18014==    by 0x5F9ACBC: clone (clone.S:112)
 
==18014== Conditional jump or move depends on uninitialised value(s)
 
==18014==    at 0x5AFE8C: Item_func::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item_func.cc:348)
 
==18014==    by 0x72A85F: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12147)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x70DF46: JOIN::optimize() (sql_select.cc:1237)
 
==18014==    by 0x7144E6: 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:2976)
 
==18014==    by 0x70AF26: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:288)
 
==18014==    by 0x6963DE: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5172)
 
==18014==    by 0x68D19D: mysql_execute_command(THD*) (sql_parse.cc:2305)
 
==18014==    by 0x698E58: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
 
==18014==    by 0x68A941: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
 
==18014==    by 0x689BDF: do_command(THD*) (sql_parse.cc:923)
 
==18014==    by 0x68663A: handle_one_connection (sql_connect.cc:1231)
 
==18014==    by 0x548DE99: start_thread (pthread_create.c:308)
 
==18014==    by 0x5F9ACBC: clone (clone.S:112)
 
==18014== Use of uninitialised value of size 8
 
==18014==    at 0x5AFE4A: Item_func::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item_func.cc:338)
 
==18014==    by 0x72A85F: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12147)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x70DF46: JOIN::optimize() (sql_select.cc:1237)
 
==18014==    by 0x7144E6: 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:2976)
 
==18014==    by 0x70AF26: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:288)
 
==18014==    by 0x6963DE: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5172)
 
==18014==    by 0x68D19D: mysql_execute_command(THD*) (sql_parse.cc:2305)
 
==18014==    by 0x698E58: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
 
==18014==    by 0x68A941: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
 
==18014==    by 0x689BDF: do_command(THD*) (sql_parse.cc:923)
 
==18014==    by 0x68663A: handle_one_connection (sql_connect.cc:1231)
 
==18014==    by 0x548DE99: start_thread (pthread_create.c:308)
 
==18014==    by 0x5F9ACBC: clone (clone.S:112)
 
==18014== Use of uninitialised value of size 8
 
==18014==    at 0x57D335: Item::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item.cc:647)
 
==18014==    by 0x5AFE6E: Item_func::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item_func.cc:338)
 
==18014==    by 0x72A85F: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12147)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x70DF46: JOIN::optimize() (sql_select.cc:1237)
 
==18014==    by 0x7144E6: 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:2976)
 
==18014==    by 0x70AF26: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:288)
 
==18014==    by 0x6963DE: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5172)
 
==18014==    by 0x68D19D: mysql_execute_command(THD*) (sql_parse.cc:2305)
 
==18014==    by 0x698E58: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
 
==18014==    by 0x68A941: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
 
==18014==    by 0x689BDF: do_command(THD*) (sql_parse.cc:923)
 
==18014==    by 0x68663A: handle_one_connection (sql_connect.cc:1231)
 
==18014==    by 0x548DE99: start_thread (pthread_create.c:308)
 
==18014== Use of uninitialised value of size 8
 
==18014==    at 0x58909A: Item_field::replace_equal_field(unsigned char*) (item.cc:5066)
 
==18014==    by 0x57D35F: Item::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item.cc:647)
 
==18014==    by 0x5AFE6E: Item_func::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item_func.cc:338)
 
==18014==    by 0x72A85F: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12147)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x70DF46: JOIN::optimize() (sql_select.cc:1237)
 
==18014==    by 0x7144E6: 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:2976)
 
==18014==    by 0x70AF26: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:288)
 
==18014==    by 0x6963DE: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5172)
 
==18014==    by 0x68D19D: mysql_execute_command(THD*) (sql_parse.cc:2305)
 
==18014==    by 0x698E58: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
 
==18014==    by 0x68A941: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
 
==18014==    by 0x689BDF: do_command(THD*) (sql_parse.cc:923)
 
==18014==    by 0x68663A: handle_one_connection (sql_connect.cc:1231)
 
==18014== Use of uninitialised value of size 8
 
==18014==    at 0x5890AE: Item_field::replace_equal_field(unsigned char*) (item.cc:5066)
 
==18014==    by 0x57D35F: Item::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item.cc:647)
 
==18014==    by 0x5AFE6E: Item_func::transform(Item* (Item::*)(unsigned char*), unsigned char*) (item_func.cc:338)
 
==18014==    by 0x72A85F: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12147)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x72A4B5: substitute_for_best_equal_field(st_join_table*, Item*, COND_EQUAL*, void*) (sql_select.cc:12063)
 
==18014==    by 0x70DF46: JOIN::optimize() (sql_select.cc:1237)
 
==18014==    by 0x7144E6: 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:2976)
 
==18014==    by 0x70AF26: handle_select(THD*, st_lex*, select_result*, unsigned long) (sql_select.cc:288)
 
==18014==    by 0x6963DE: execute_sqlcom_select(THD*, TABLE_LIST*) (sql_parse.cc:5172)
 
==18014==    by 0x68D19D: mysql_execute_command(THD*) (sql_parse.cc:2305)
 
==18014==    by 0x698E58: mysql_parse(THD*, char*, unsigned int, char const**) (sql_parse.cc:6173)
 
==18014==    by 0x68A941: dispatch_command(enum_server_command, THD*, char*, unsigned int) (sql_parse.cc:1243)
 
==18014==    by 0x689BDF: do_command(THD*) (sql_parse.cc:923)
 
==18014==    by 0x68663A: handle_one_connection (sql_connect.cc:1231)
 

revision-id: sergii@pisem.net-20130411173539-tzwl0193224o7t7u
 
revno: 3652
 
branch-nick: 5.3
 
BUILD/compile-pentium-valgrind-max-no-ndb

Server crash on 5.5:

#2  0x00000000007c6d68 in handle_fatal_signal (sig=11) at /data/bzr/5.5/sql/signal_handler.cc:262
 
#3  <signal handler called>
 
#4  0x00000000007e3090 in Item_field::replace_equal_field (this=0x7f7aac008b08, arg=0x7f7ab5396080 "@\027\002\254z\177") at /data/bzr/5.5/sql/item.cc:5434
 
#5  0x00000000007d63d9 in Item::transform (this=0x7f7aac008b08, transformer=&virtual Item::replace_equal_field(unsigned char*), arg=0x7f7ab5396080 "@\027\002\254z\177") at /data/bzr/5.5/sql/item.cc:697
 
#6  0x00000000008214d6 in Item_func::transform (this=0x7f7aac008ca0, transformer=&virtual table offset 816, argument=0x7f7ab5396080 "@\027\002\254z\177") at /data/bzr/5.5/sql/item_func.cc:361
 
#7  0x000000000065cdb7 in substitute_for_best_equal_field (context_tab=0x1, cond=0x7f7aac008ca0, cond_equal=0x7f7aac0201a0, table_join_idx=0x7f7aac021948) at /data/bzr/5.5/sql/sql_select.cc:12425
 
#8  0x000000000065ca0b in substitute_for_best_equal_field (context_tab=0x1, cond=0x7f7aac009130, cond_equal=0x7f7aac009220, table_join_idx=0x7f7aac021948) at /data/bzr/5.5/sql/sql_select.cc:12341
 
#9  0x000000000065ca0b in substitute_for_best_equal_field (context_tab=0x1, cond=0x7f7aac009268, cond_equal=0x7f7aac0203b8, table_join_idx=0x7f7aac021948) at /data/bzr/5.5/sql/sql_select.cc:12341
 
#10 0x000000000065ca0b in substitute_for_best_equal_field (context_tab=0x1, cond=0x7f7aac0202c8, cond_equal=0x7f7aac0203b8, table_join_idx=0x7f7aac021948) at /data/bzr/5.5/sql/sql_select.cc:12341
 
#11 0x000000000064060c in JOIN::optimize (this=0x7f7aac0204c0) at /data/bzr/5.5/sql/sql_select.cc:1288
 
#12 0x00000000006469e1 in mysql_select (thd=0x27b0820, rref_pointer_array=0x27b3828, tables=0x7f7aac007750, wild_num=1, fields=..., conds=0x7f7aac0202c8, og_num=0, order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7f7aac0204a0, unit=0x27b2ef8, select_lex=0x27b35d0) at /data/bzr/5.5/sql/sql_select.cc:3048
 
#13 0x000000000063d5ea in handle_select (thd=0x27b0820, lex=0x27b2e48, result=0x7f7aac0204a0, setup_tables_done_option=0) at /data/bzr/5.5/sql/sql_select.cc:318
 
#14 0x000000000061643d in execute_sqlcom_select (thd=0x27b0820, all_tables=0x7f7aac007750) at /data/bzr/5.5/sql/sql_parse.cc:4641
 
#15 0x000000000060ee8c in mysql_execute_command (thd=0x27b0820) at /data/bzr/5.5/sql/sql_parse.cc:2195
 
#16 0x0000000000618cdc in mysql_parse (thd=0x27b0820, rawbuf=0x7f7aac0074c8 "SELECT * FROM t1, t2 WHERE c = a AND ( 0 OR ( b BETWEEN 45 AND 300 OR a > 45 AND a < 100 ) AND b = c )", length=102, parser_state=0x7f7ab5397500) at /data/bzr/5.5/sql/sql_parse.cc:5759
 
#17 0x000000000060c3dc in dispatch_command (command=COM_QUERY, thd=0x27b0820, packet=0x28a5c41 "SELECT * FROM t1, t2 WHERE c = a AND ( 0 OR ( b BETWEEN 45 AND 300 OR a > 45 AND a < 100 ) AND b = c )", packet_length=102) at /data/bzr/5.5/sql/sql_parse.cc:1068
 
#18 0x000000000060b61d in do_command (thd=0x27b0820) at /data/bzr/5.5/sql/sql_parse.cc:794
 
#19 0x000000000071092d in do_handle_one_connection (thd_arg=0x27b0820) at /data/bzr/5.5/sql/sql_connect.cc:1266
 
#20 0x0000000000710314 in handle_one_connection (arg=0x27b0820) at /data/bzr/5.5/sql/sql_connect.cc:1181
 
#21 0x000000000096c0b8 in pfs_spawn_thread (arg=0x284ea70) at /data/bzr/5.5/storage/perfschema/pfs.cc:1015
 
#22 0x00007f7ac0a84e9a in start_thread (arg=0x7f7ab5398700) at pthread_create.c:308
 
#23 0x00007f7abfd78cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
 
#24 0x0000000000000000 in ?? ()
 

revision-id: knielsen@knielsen-hq.org-20130422142239-e1b8ly4fsw30i2c5
 
revno: 3734
 
branch-nick: 5.5
 
BUILD/compile-pentium-debug-max-no-ndb

Test case:

CREATE TABLE t1 (a INT, b INT) ENGINE=MyISAM;
 
INSERT INTO t1 VALUES (7,1);
 
 
 
CREATE TABLE t2 (c INT) ENGINE=MyISAM;
 
INSERT INTO t2 VALUES (0),(8);
 
 
 
SELECT * FROM t1, t2 WHERE c = a AND ( 0 OR ( b BETWEEN 45 AND 300 OR a > 45 AND a < 100 ) AND b = c );

EXPLAIN also fails.
Reproducible with the default optimizer_switch as well as with all OFF values.



 Comments   
Comment by Elena Stepanova [ 2013-04-22 ]

See also MDEV-4274 which might be related since it came with the same change.

Comment by Elena Stepanova [ 2013-04-30 ]

This bug was fixed along with MDEV-4274 by the following revision (on 5.3 tree):

revno: 3653
revision-id: igor@askmonty.org-20130430033140-qhx9wsgc5w2dx14r
parent: sergii@pisem.net-20130411173539-tzwl0193224o7t7u
committer: Igor Babaev <igor@askmonty.org>
branch nick: maria-5.3-mdev4274
timestamp: Mon 2013-04-29 20:31:40 -0700
message:
Fixed bug mdev-4274.

Comment by Elena Stepanova [ 2013-05-04 ]

reopening to set correct fix versions after the fix is merged up to 5.5 and 10.0

Comment by Elena Stepanova [ 2013-05-05 ]

Not reproducible anymore on 5.3 and 5.5, fixed along with MDEV-4274 and/or MDEV-4336.

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