Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
Description
CREATE TABLE IF NOT EXISTS X ( |
f2 DOUBLE NOT NULL DEFAULT '0', |
f3 DOUBLE NOT NULL DEFAULT '0', |
f4 DOUBLE, |
f5 DOUBLE DEFAULT '0', |
v4 DOUBLE AS (IF(f4,f3,f2)) VIRTUAL, |
KEY (f5), |
KEY (v4) |
);
|
INSERT INTO X (f2,f3,f4,f5) VALUES (5,4,1,0),(5,7,NULL,0); |
INSERT INTO X (f2,f3,f4,f5) SELECT f2, f3, f5, f3 FROM X; |
INSERT INTO X (f2,f3,f4,f5) VALUES (5,0,NULL,1); |
INSERT INTO X (f2,f3,f4,f5) SELECT f2, f5, f5, f3 FROM X; |
DELETE FROM X WHERE f5 = 1 OR v4 = 4 ORDER BY f5,v4 LIMIT 9; |
10.2 c35b8c46b404d035e54a23d667da5dff6502fc2e |
mysqld: /data/src/10.2/sql/field.cc:4771: virtual double Field_double::val_real(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.
|
161218 18:48:31 [ERROR] mysqld got signal 6 ;
|
 |
#7 0x00007fc8cc9e9312 in __GI___assert_fail (assertion=0x7fc8cf5726c0 "!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))", file=0x7fc8cf571e67 "/data/src/10.2/sql/field.cc", line=4771, function=0x7fc8cf575ae0 <Field_double::val_real()::__PRETTY_FUNCTION__> "virtual double Field_double::val_real()") at assert.c:101
|
#8 0x00007fc8ced49bda in Field_double::val_real (this=<optimized out>) at /data/src/10.2/sql/field.cc:4771
|
#9 0x00007fc8ced7ba7c in Item_field::val_real (this=<optimized out>) at /data/src/10.2/sql/item.cc:2740
|
#10 0x00007fc8ced9d027 in Item_func_if::real_op (this=0x7fc8c3a0af70) at /data/src/10.2/sql/item_cmpfunc.cc:2425
|
#11 0x00007fc8cedd337a in Item_func_hybrid_field_type::val_real (this=0x7fc8c3a0af70) at /data/src/10.2/sql/item_func.cc:902
|
#12 0x00007fc8ced81b8e in Item::save_in_field (this=0x7fc8c3a0af70, field=0x7fc8c3827b58, no_conversions=<optimized out>) at /data/src/10.2/sql/item.cc:6293
|
#13 0x00007fc8cec554be in TABLE::update_virtual_fields (this=0x7fc8c38d5870, update_mode=update_mode@entry=VCOL_UPDATE_FOR_READ) at /data/src/10.2/sql/table.cc:7354
|
#14 0x00007fc8ced6e78c in handler::ha_index_read_map (this=this@entry=0x7fc8c39e0298, buf=0x7fc8c3827588 "\363", '\245' <repeats 24 times>, key=0x7fc8c39e0138 "", keypart_map=1, find_flag=<optimized out>) at /data/src/10.2/sql/handler.cc:2634
|
#15 0x00007fc8ced73ddc in handler::read_range_first (this=0x7fc8c39e0298, start_key=0x7fc8c39e0380, end_key=0x7fc8c39e03a0, eq_range_arg=<optimized out>, sorted=<optimized out>) at /data/src/10.2/sql/handler.cc:5318
|
#16 0x00007fc8cecbdd5e in handler::multi_range_read_next (this=0x7fc8c39e0298, range_info=range_info@entry=0x7fc8cfb8eb88) at /data/src/10.2/sql/multi_range_read.cc:290
|
#17 0x00007fc8cecbde35 in Mrr_simple_index_reader::get_next (this=0x7fc8c39e0828, range_info=0x7fc8cfb8eb88) at /data/src/10.2/sql/multi_range_read.cc:322
|
#18 0x00007fc8cecbf842 in DsMrr_impl::dsmrr_next (this=0x7fc8c39e06e8, range_info=0x7fc8cfb8eb88) at /data/src/10.2/sql/multi_range_read.cc:1408
|
#19 0x00007fc8cf39d73e in ha_myisam::multi_range_read_next (this=<optimized out>, range_info=<optimized out>) at /data/src/10.2/storage/myisam/ha_myisam.cc:2355
|
#20 0x00007fc8cee809b9 in QUICK_RANGE_SELECT::get_next (this=0x7fc8c38ff140) at /data/src/10.2/sql/opt_range.cc:11189
|
#21 0x00007fc8cee852a8 in QUICK_ROR_UNION_SELECT::reset (this=0x7fc8c3852300) at /data/src/10.2/sql/opt_range.cc:1807
|
#22 0x00007fc8ced66dc5 in find_all_keys (found_rows=0x7fc8c3a9d3f0, pq=0x0, tempfile=0x7fc8cfb8ef30, buffpek_pointers=0x7fc8cfb8f0b0, fs_info=0x7fc8c3a9d200, select=0x7fc8c38656b8, param=0x7fc8cfb8ee90, thd=0x7fc8c3816070) at /data/src/10.2/sql/filesort.cc:776
|
#23 filesort (thd=thd@entry=0x7fc8c3816070, table=table@entry=0x7fc8c38d5870, filesort=filesort@entry=0x7fc8cfb8f790, tracker=0x7fc8c3865b20, join=join@entry=0x0, first_table_bit=first_table_bit@entry=0) at /data/src/10.2/sql/filesort.cc:284
|
#24 0x00007fc8ceec5a4c in mysql_delete (thd=thd@entry=0x7fc8c3816070, table_list=0x7fc8c38641b0, conds=0x7fc8c3864dd0, order_list=order_list@entry=0x7fc8c381a4a8, limit=9, options=<optimized out>, result=0x0) at /data/src/10.2/sql/sql_delete.cc:503
|
#25 0x00007fc8ceb8935b in mysql_execute_command (thd=thd@entry=0x7fc8c3816070) at /data/src/10.2/sql/sql_parse.cc:4516
|
#26 0x00007fc8ceb8f2d2 in mysql_parse (thd=thd@entry=0x7fc8c3816070, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fc8cfb918e0, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:7790
|
#27 0x00007fc8ceb9155b in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fc8c3816070, packet=packet@entry=0x7fc8c3858071 "DELETE FROM X WHERE f5 = 1 OR v4 = 4 ORDER BY f5,v4 LIMIT 9", packet_length=packet_length@entry=59, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.2/sql/sql_parse.cc:1799
|
#28 0x00007fc8ceb9408d in do_command (thd=0x7fc8c3816070) at /data/src/10.2/sql/sql_parse.cc:1359
|
#29 0x00007fc8cec81f4a in do_handle_one_connection (connect=connect@entry=0x7fc8cbc71410) at /data/src/10.2/sql/sql_connect.cc:1354
|
#30 0x00007fc8cec82133 in handle_one_connection (arg=arg@entry=0x7fc8cbc71410) at /data/src/10.2/sql/sql_connect.cc:1260
|
#31 0x00007fc8cef301bf in pfs_spawn_thread (arg=0x7fc8cbc15df0) at /data/src/10.2/storage/perfschema/pfs.cc:1862
|
#32 0x00007fc8ce2830a4 in start_thread (arg=0x7fc8cfb93300) at pthread_create.c:309
|
#33 0x00007fc8ccaa387d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
Attachments
Issue Links
- relates to
-
MDEV-5800 indexes on virtual (not materialized) columns
- Closed