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

Bug #674521 reported by Philip Stoev
6
This bug affects 1 person
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=true) at item.cc:5306
#11 0x081ce1fc in Item_cache_str::save_in_field (this=0xae658178, field=0xae687a18, no_conversions=true) at item.cc:7963
#12 0x081c9f48 in Item_ref::save_in_field (this=0xae6871a0, to=0xae687a18, no_conversions=true) at item.cc:6497
#13 0x08333923 in store_key_const_item::copy_inner (this=0xae6879f8) at sql_select.h:2001
#14 0x0823e9ee in store_key::copy (this=0xae6879f8) at sql_select.h:1887
#15 0x08238334 in subselect_uniquesubquery_engine::copy_ref_key (this=0xae687ee8) at item_subselect.cc:2909
#16 0x082389da in subselect_indexsubquery_engine::exec (this=0xae687ee8) at item_subselect.cc:3214
#17 0x0823246b in Item_subselect::exec (this=0xae62f888) at item_subselect.cc:552
#18 0x0823266a in Item_in_subselect::exec (this=0xae62f888) at item_subselect.cc:649
#19 0x08233fc0 in Item_in_subselect::val_bool (this=0xae62f888) at item_subselect.cc:1327
#20 0x081d16a0 in Item::val_bool_result (this=0xae62f888) at item.h:783
#21 0x081fd17a in Item_in_optimizer::val_int (this=0xae657ea0) at item_cmpfunc.cc:1893
#22 0x081bb122 in Item::val_bool (this=0xae657ea0) at item.cc:187
#23 0x08204fd4 in Item_cond_and::val_int (this=0xae658ed8) at item_cmpfunc.cc:4591
#24 0x0830504f in JOIN::exec (this=0xae67cc90) at sql_select.cc:1825
#25 0x08307969 in mysql_select (thd=0xb2230e8, rref_pointer_array=0xb224b64, tables=0xae62e7c0, wild_num=0, fields=..., conds=0xae62f888, og_num=0,
    order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764740, result=0xae6578c0, unit=0xb2247c4, select_lex=0xb224a60)
    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_sqlcom_select (thd=0xb2230e8, all_tables=0xae62e7c0) at sql_parse.cc:5080
#28 0x08294453 in mysql_execute_command (thd=0xb2230e8) at sql_parse.cc:2281
#29 0x0829fedc in mysql_parse (thd=0xb2230e8,
    rawbuf=0xae62d9b8 "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 )", length=143, found_semicolon=0xae7ff228) at sql_parse.cc:6109
#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_one_connection (arg=0xb2230e8) at sql_connect.cc:1154
#33 0x00bea919 in start_thread () from /lib/libpthread.so.0
#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 );

Tags: rqg mwl89

Related branches

Revision history for this message
Philip Stoev (pstoev-askmonty) wrote :

Not repeatable on maria-5.3

Changed in maria:
milestone: none → 5.3
assignee: nobody → Timour Katchaounov (timour)
Revision history for this message
Timour Katchaounov (timour) wrote :

This bug fails the same kind of assertion as in LP BUG #676411.
The only difference is the type of the field, which results in calling
the store() method for a different type of Field object. Here it is
Field_long, while in bug #676411 it is Field_varstring.
The same problem should be reproducible for the store() method
of all other Field subclasses.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.