Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
-
None
Description
Only reproducible on 5.5 - 10.1, not reproducible on 10.2+.
CREATE TABLE t1 (a INT, b BIT(4) DEFAULT 0, vb BIT(4) AS (b) VIRTUAL); |
CREATE VIEW v1 AS SELECT * FROM t1; |
|
INSERT IGNORE INTO t1 (a,b) VALUES (0,0),(1,1); |
|
SELECT VALUES(vb) FROM v1 GROUP BY a WITH ROLLUP; |
|
# Cleanup
|
DROP VIEW v1; |
DROP TABLE t1; |
5.5 1956695c6946 |
mysqld: /data/src/5.5/sql/field.cc:8354: virtual longlong Field_bit::val_int(): Assertion `!table || (!table->read_set || bitmap_is_set(table->read_set, field_index))' failed.
|
181118 13:13:07 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007fc8ec28fee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x00000000007a1592 in Field_bit::val_int (this=0x7fc8e6c56b40) at /data/src/5.5/sql/field.cc:8354
|
#9 0x00000000007ad353 in field_conv (to=0x7fc8e6c56bf0, from=0x7fc8e6c56b40) at /data/src/5.5/sql/field_conv.cc:907
|
#10 0x00000000007cfbc9 in save_field_in_field (from=0x7fc8e6c56b40, null_value=0x7fc8e6c56d92, to=0x7fc8e6c56bf0, no_conversions=false) at /data/src/5.5/sql/item.cc:5928
|
#11 0x00000000007cfc58 in Item_field::save_in_field (this=0x7fc8e6c56d30, to=0x7fc8e6c56bf0, no_conversions=false) at /data/src/5.5/sql/item.cc:5946
|
#12 0x00000000006d5756 in update_virtual_fields (thd=0x7fc8e7e64060, table=0x7fc8e6ddb860, vcol_update_mode=VCOL_UPDATE_FOR_READ) at /data/src/5.5/sql/table.cc:6630
|
#13 0x00000000007af0ea in find_all_keys (param=0x7fc8edae7240, select=0x7fc8e6d77390, sort_keys=0x7fc8e6d623e0, sort_keys_buf=0x7fc8e6d62458 '\245' <repeats 165 times>, "h4z\025'\024\003", buffpek_pointers=0x7fc8edae7450, tempfile=0x7fc8edae72c0) at /data/src/5.5/sql/filesort.cc:689
|
#14 0x00000000007adcb6 in filesort (thd=0x7fc8e7e64060, table=0x7fc8e6ddb860, sortorder=0x7fc8e6d77898, s_length=1, select=0x7fc8e6d77390, max_rows=18446744073709551615, sort_positions=false, examined_rows=0x7fc8edae76d8) at /data/src/5.5/sql/filesort.cc:250
|
#15 0x000000000066406c in create_sort_index (thd=0x7fc8e7e64060, join=0x7fc8e6d5bf80, order=0x7fc8e6cc4ad0, filesort_limit=18446744073709551615, select_limit=18446744073709551615, is_order_by=false) at /data/src/5.5/sql/sql_select.cc:20079
|
#16 0x000000000063a73c in JOIN::exec (this=0x7fc8e6d5bf80) at /data/src/5.5/sql/sql_select.cc:2882
|
#17 0x000000000063b132 in mysql_select (thd=0x7fc8e7e64060, rref_pointer_array=0x7fc8e7e67d08, tables=0x7fc8e6cc43d8, wild_num=0, fields=..., conds=0x0, og_num=1, order=0x0, group=0x7fc8e6cc4ad0, having=0x0, proc_param=0x0, select_options=2147748608, result=0x7fc8e6d5bf60, unit=0x7fc8e7e67388, select_lex=0x7fc8e7e67a68) at /data/src/5.5/sql/sql_select.cc:3133
|
#18 0x00000000006316ee in handle_select (thd=0x7fc8e7e64060, lex=0x7fc8e7e672d8, result=0x7fc8e6d5bf60, setup_tables_done_option=0) at /data/src/5.5/sql/sql_select.cc:323
|
#19 0x000000000060aaf6 in execute_sqlcom_select (thd=0x7fc8e7e64060, all_tables=0x7fc8e6cc43d8) at /data/src/5.5/sql/sql_parse.cc:4678
|
#20 0x0000000000603e77 in mysql_execute_command (thd=0x7fc8e7e64060) at /data/src/5.5/sql/sql_parse.cc:2224
|
#21 0x000000000060d6c2 in mysql_parse (thd=0x7fc8e7e64060, rawbuf=0x7fc8e6cc4078 "SELECT VALUES(vb) FROM v1 GROUP BY a WITH ROLLUP", length=48, parser_state=0x7fc8edae8640) at /data/src/5.5/sql/sql_parse.cc:5923
|
#22 0x00000000006013d7 in dispatch_command (command=COM_QUERY, thd=0x7fc8e7e64060, packet=0x7fc8ebb5b061 "SELECT VALUES(vb) FROM v1 GROUP BY a WITH ROLLUP", packet_length=48) at /data/src/5.5/sql/sql_parse.cc:1066
|
#23 0x00000000006005c9 in do_command (thd=0x7fc8e7e64060) at /data/src/5.5/sql/sql_parse.cc:793
|
#24 0x0000000000703bbf in do_handle_one_connection (thd_arg=0x7fc8e7e64060) at /data/src/5.5/sql/sql_connect.cc:1268
|
#25 0x000000000070394c in handle_one_connection (arg=0x7fc8e7e64060) at /data/src/5.5/sql/sql_connect.cc:1184
|
#26 0x0000000000a12a33 in pfs_spawn_thread (arg=0x7fc8e8b60fc0) at /data/src/5.5/storage/perfschema/pfs.cc:1015
|
#27 0x00007fc8ed71b494 in start_thread (arg=0x7fc8edae9700) at pthread_create.c:333
|
#28 0x00007fc8ec34c93f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|