Assertion `fixed == 0' failed in Item_func::fix_fields in maria-5.3-mwl106
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Igor Babaev |
Bug Description
Not repeatable in maria-5.3. EXPLAIN also crashes. Assertion:
mysqld: item_func.cc:153: virtual bool Item_func:
backtrace:
#8 0x00399d98 in __assert_fail () from /lib/libc.so.6
#9 0x081edfd4 in Item_func:
#10 0x083cdfb9 in convert_subq_to_sj (parent_
#11 0x083cd1ad in convert_
#12 0x0830f5da in JOIN::optimize (this=0xae52e4b0) at sql_select.cc:832
#13 0x08315bb9 in mysql_select (thd=0x95f1e30, rref_pointer_
group=0x0, having=0x0, proc_param=0x0, select_
#14 0x0830deef in handle_select (thd=0x95f1e30, lex=0x95f34d8, result=0xae513dd8, setup_tables_
#15 0x082aa282 in execute_
#16 0x082a102a in mysql_execute_
#17 0x082ac8ba in mysql_parse (thd=0x95f1e30, rawbuf=0xae5125e0 "SELECT *\nFROM t1\nINNER JOIN t2\nON t2.f1 != 0\nAND t2.f1 IN ( SELECT * FROM v1 )",
length=78, found_semicolon
#18 0x0829ec97 in dispatch_command (command=COM_QUERY, thd=0x95f1e30,
packet=
#19 0x0829e0f5 in do_command (thd=0x95f1e30) at sql_parse.cc:904
#20 0x0829b1a8 in handle_
#21 0x00821919 in start_thread () from /lib/libpthread
#22 0x00453cce in clone () from /lib/libc.so.6
test case:
CREATE TABLE t1 ( f1 int ) ;
INSERT INTO t1 VALUES (1), (1);
CREATE TABLE t2 ( f1 int ) ;
INSERT INTO t2 VALUES (1), (1);
CREATE VIEW v1 AS SELECT 7;
SELECT *
FROM t1
INNER JOIN t2
ON t2.f1 != 0
AND t2.f1 IN ( SELECT * FROM v1 );
bzr version-info
revision-id: <email address hidden>
date: 2011-05-16 22:39:43 -0700
build-date: 2011-05-18 10:25:02 +0300
revno: 2982
branch-nick: maria-5.3-mwl106
Related branches
Changed in maria: | |
assignee: | nobody → Igor Babaev (igorb-seattle) |
milestone: | none → 5.3 |
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → Critical |
Changed in maria: | |
status: | Confirmed → In Progress |
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
Still repeatable with
bzr version-info eve-20110601094 248-uo9la7qx3h5 xcf56 views-testing
revision-id: philips@
date: 2011-06-01 12:42:48 +0300
build-date: 2011-06-06 12:53:36 +0300
revno: 811
branch-nick: randgen-