Assertion `(was_cut & 1) == 0' failed in Field_temporal::store_TIME_with_warning() in 5.1-micro
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Sergei Golubchik |
Bug Description
Not repeatable in mysql-5.1
assertion:
mysqld: field.cc:5195: int Field_temporal:
backtrace:
#8 0x006b0d98 in __assert_fail () from /lib/libc.so.6
#9 0x08234369 in Field_temporal:
at field.cc:5195
#10 0x08234555 in Field_temporal:
#11 0x081b1fa7 in Item::save_in_field (this=0xb692bf80, field=0xb69054b0, no_conversions=
#12 0x081a874b in Item::save_
#13 0x0837317b in get_mm_leaf (param=0xb6ae751c, conf_func=
at opt_range.cc:5823
#14 0x08372a33 in get_mm_parts (param=0xb6ae751c, cond_func=
at opt_range.cc:5618
#15 0x08372563 in get_mm_tree (param=0xb6ae751c, cond=0xb692d460) at opt_range.cc:5564
#16 0x0836b738 in SQL_SELECT:
force_
#17 0x082da3ea in get_quick_
at sql_select.cc:2591
#18 0x082dbe2f in make_join_
#19 0x082d4baa in JOIN::optimize (this=0xb692c178) at sql_select.cc:1020
#20 0x082da0dd in mysql_select (thd=0xa409090, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2530
#21 0x082d2b4e in handle_select (thd=0xa409090, lex=0xa40a1ac, result=0xb692c160, setup_tables_
#22 0x0827ac8f in execute_
#23 0x08271b46 in mysql_execute_
#24 0x0827ce48 in mysql_parse (thd=0xa409090, rawbuf=0xb692b930 "SELECT * FROM t1 WHERE f1 = FROM_UNIXTIME( 2002190336 , \"%m''%
length=78, found_semicolon
#25 0x0826f7a0 in dispatch_command (command=COM_QUERY, thd=0xa409090,
packet=
#26 0x0826e9d0 in do_command (thd=0xa409090) at sql_parse.cc:889
#27 0x0826cd15 in handle_
#28 0x00821919 in start_thread () from /lib/libpthread
#29 0x0076acce in clone () from /lib/libc.so.6
test case:
CREATE TABLE t1 ( f1 date, KEY (f1)) ;
INSERT IGNORE INTO t1 VALUES (NULL),(NULL);
SELECT * FROM t1 WHERE f1 = FROM_UNIXTIME( 2002190336 , "%m''%w'
Related branches
Changed in maria: | |
importance: | Undecided → Critical |
Changed in maria: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
Also repeatable with a more realistic format:
FROM_UNIXTIME( 2002190336 , CONCAT_WS( ':' , '%m' , '%w' , '%d' , '%c' , '%T' ) )