Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
not repeatable with mysql-5.1
backtrace:
#4 <signal handler called>
#5 0x081ba953 in DTCollation::set (this=0x38, dt=...) at item.h:73
#6 0x082e80e7 in change_cond_ref_to_const (thd=0xa26c090, save_list=0xb6e41c24, and_father=0xb6b2c210, cond=0xb6b2be08, field=0xb6b2bef0, value=0xb6b2c098)
at sql_select.cc:8499
#7 0x082e7fa5 in change_cond_ref_to_const (thd=0xa26c090, save_list=0xb6e41c24, and_father=0xb6b2c210, cond=0xb6b2c210, field=0xb6b2bef0, value=0xb6b2c098)
at sql_select.cc:8480
#8 0x082e875e in propagate_cond_constants (thd=0xa26c090, save_list=0xb6e41c24, and_father=0xb6b2c210, cond=0xb6b2c130) at sql_select.cc:8623
#9 0x082e84e8 in propagate_cond_constants (thd=0xa26c090, save_list=0x0, and_father=0xb6b2c210, cond=0xb6b2c210) at sql_select.cc:8590
#10 0x082e969f in optimize_cond (join=0xb6b2c348, conds=0xb6b2c210, join_list=0xa26d53c, cond_value=0xb6b2d460) at sql_select.cc:9244
#11 0x082d427c in JOIN::optimize (this=0xb6b2c348) at sql_select.cc:887
#12 0x082d9ebd in mysql_select (thd=0xa26c090, rref_pointer_array=0xa26d570, tables=0xb6b2baf0, wild_num=1, fields=..., conds=0xb6b2c210, og_num=0,
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb6b2c330, unit=0xa26d208, select_lex=0xa26d478)
at sql_select.cc:2530
#13 0x082d292e in handle_select (thd=0xa26c090, lex=0xa26d1ac, result=0xb6b2c330, setup_tables_done_option=0) at sql_select.cc:269
#14 0x0827aa6f in execute_sqlcom_select (thd=0xa26c090, all_tables=0xb6b2baf0) at sql_parse.cc:5129
#15 0x08271926 in mysql_execute_command (thd=0xa26c090) at sql_parse.cc:2278
#16 0x0827cc28 in mysql_parse (thd=0xa26c090,
rawbuf=0xb6b2b930 "SELECT * FROM t1 WHERE f1 > f1 AND f1 <=> TIMESTAMPADD( HOUR , 9 , '2010-01-01 16:55:35' )", length=90, found_semicolon=0xb6e43210)
at sql_parse.cc:6054
#17 0x0826f580 in dispatch_command (command=COM_QUERY, thd=0xa26c090,
packet=0xa2b1539 "SELECT * FROM t1 WHERE f1 > f1 AND f1 <=> TIMESTAMPADD( HOUR , 9 , '2010-01-01 16:55:35' ) ", packet_length=91) at sql_parse.cc:1249
#18 0x0826e7b0 in do_command (thd=0xa26c090) at sql_parse.cc:889
#19 0x0826caf5 in handle_one_connection (arg=0xa26c090) at sql_connect.cc:1136
#20 0x00821919 in start_thread () from /lib/libpthread.so.0
#21 0x0076acce in clone () from /lib/libc.so.6
test case:
CREATE TABLE t1 ( f1 timestamp) ;
SELECT * FROM t1 WHERE f1 > f1 AND f1 <=> TIMESTAMPADD( HOUR , 9 , '2010-01-01 16:55:35' ) ;
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Launchpad bug id: 737104