[MDEV-2624] LP:737104 - Crash in DTCollation::set in 5.1-micro Created: 2011-03-17  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Philip Stoev (Inactive) Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug737104.xml    

 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' ) ;



 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-10-28 ]

Launchpad bug id: 737104

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