We're updating the issue view to help you get more done.Learn more

crash with self referencing virtual column

Description:
---------------

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Version: '10.0.7-MariaDB' mariadb.org binary distribution mysqld.exe!bitmap_fast_test_and_set()[my_bitmap.c:235] mysqld.exe!TABLE::mark_virtual_col()[table.cc:5871] mysqld.exe!Item_field::update_table_bitmaps()[item.h:2107] mysqld.exe!Item_func_isnull::update_used_tables()[item_cmpfunc.h:1390] mysqld.exe!Item_func::fix_fields()[item_func.cc:230] mysqld.exe!fix_vcol_expr()[table.cc:2281] mysqld.exe!unpack_vcol_info_from_frm()[table.cc:2466] mysqld.exe!open_table_from_share()[table.cc:2723] mysqld.exe!ha_create_table()[handler.cc:4591] mysqld.exe!rea_create_table()[unireg.cc:409] mysqld.exe!create_table_impl()[sql_table.cc:4643] mysqld.exe!mysql_create_table_no_lock()[sql_table.cc:4753] mysqld.exe!mysql_create_table()[sql_table.cc:4794] mysqld.exe!mysql_execute_command()[sql_parse.cc:3025] mysqld.exe!mysql_parse()[sql_parse.cc:6399] mysqld.exe!dispatch_command()[sql_parse.cc:1299] mysqld.exe!do_command()[sql_parse.cc:1000] mysqld.exe!threadpool_process_request()[threadpool_common.cc:233] mysqld.exe!io_completion_callback()[threadpool_win.cc:568]

How to repeat:
------------------

1 2 drop table if exists t1; create table `t1` (`a` int, `b` int as (`b` is null) virtual) engine=innodb;

Status

Assignee

Igor Babaev

Reporter

sbester1

Fix versions

Affects versions

5.3.12
5.5.35
10.0.7

Priority

Major