field.cc:3591: virtual int Field_long::store(const char*, uint, const CHARSET_INFO*): Assertion `!table || (!table->write_set || bitmap_is_set(table->write_set, field_index) || bitmap_is_set(table->vcol_set, field_index))' failed. in maria-5.3-mwl89
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Undecided
|
Timour Katchaounov |
Bug Description
backtrace:
#8 0x00a72d98 in __assert_fail () from /lib/libc.so.6
#9 0x082502f2 in Field_long::store (this=0xae687a18, from=0xae6581e5 "l", len=1, cs=0x8a85b20) at field.cc:3591
#10 0x081c6f27 in Item::save_in_field (this=0xae658178, field=0xae687a18, no_conversions=
#11 0x081ce1fc in Item_cache_
#12 0x081c9f48 in Item_ref:
#13 0x08333923 in store_key_
#14 0x0823e9ee in store_key::copy (this=0xae6879f8) at sql_select.h:1887
#15 0x08238334 in subselect_
#16 0x082389da in subselect_
#17 0x0823246b in Item_subselect:
#18 0x0823266a in Item_in_
#19 0x08233fc0 in Item_in_
#20 0x081d16a0 in Item::val_
#21 0x081fd17a in Item_in_
#22 0x081bb122 in Item::val_bool (this=0xae657ea0) at item.cc:187
#23 0x08204fd4 in Item_cond_
#24 0x0830504f in JOIN::exec (this=0xae67cc90) at sql_select.cc:1825
#25 0x08307969 in mysql_select (thd=0xb2230e8, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2544
#26 0x0833104a in mysql_explain_union (thd=0xb2230e8, unit=0xb2247c4, result=0xae6578c0) at sql_select.cc:18930
#27 0x0829d7ba in execute_
#28 0x08294453 in mysql_execute_
#29 0x0829fedc in mysql_parse (thd=0xb2230e8,
rawbuf=
#30 0x08291f3c in dispatch_command (command=COM_QUERY, thd=0xb2230e8, packet=0xb23b789 "", packet_length=143) at sql_parse.cc:1209
#31 0x082913a6 in do_command (thd=0xb2230e8) at sql_parse.cc:902
#32 0x0828e484 in handle_
#33 0x00bea919 in start_thread () from /lib/libpthread
#34 0x00b2ccbe in clone () from /lib/libc.so.6
test case:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (
f5 int) ;
INSERT IGNORE INTO t1 VALUES ('z');
DROP TABLE IF EXISTS t2;
CREATE TABLE t2 (
f5 int,
KEY (f5)) ;
INSERT IGNORE INTO t2 VALUES ('w'),('y');
EXPLAIN SELECT table2.f5 FROM ( SELECT * FROM t1 ) AS table1 JOIN t2 AS table2 ON table1.f5 WHERE ( 'l' , 'i' ) IN ( SELECT f5 , f5 FROM t2 );
Not repeatable on maria-5.3