mariadb/mysql-test/suite/vcol/t
Aleksey Midenkov fe6a5c2200 MDEV-29155 CREATE OR REPLACE with self-referencing CHECK hangs
forever, cannot be killed

mysql_rm_table_no_locks() does TDC_RT_REMOVE_ALL which waits while
share is closed. The table normally is open only as OPEN_STUB, this is
what parser does for CREATE TABLE. But for SELECT the table is opened
not as a stub. If it is the same table name we anyway have two
TABLE_LIST objects: stub and not stub. So for "not stub"
TDC_RT_REMOVE_ALL sees open count and decides to wait until it is
closed. And it hangs because that was opened in the same thread.

The fix disables subqueries in CHECK expression at parser
level. Thanks to Sergei Golubchik <serg@mariadb.org> for the patch.
2025-05-29 12:34:07 +03:00
..
alter_inplace-9045.test
binlog.test [1/2] MDEV-18166 ASSERT_COLUMN_MARKED_FOR_READ failed on tables with vcols 2021-07-12 22:00:39 +03:00
charsets.test
cross_db.test
delayed.test
func_regexp.test MDEV-21058 CREATE TABLE with generated column and RLIKE results in sigabrt 2024-04-29 11:08:07 +04:00
index.test
innodb_autoinc_vcol.test
innodb_virtual_fk.test MDEV-31853 Assertion failure in Column_definition::check_vcol_for_key upon adding FK 2023-08-06 20:08:51 +02:00
load_data.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
mrr.test
myisam_repair_prefix_varchar.test
not_supported.test MDEV-29155 CREATE OR REPLACE with self-referencing CHECK hangs 2025-05-29 12:34:07 +03:00
partition.test MDEV-28127 EXCHANGE PARTITION with non-matching vcol expression segfault 2023-11-10 15:46:15 +03:00
races.test
range.test
rpl_vcol.test
update.test
update_binlog.test
upgrade.test
vcol_archive.test
vcol_blackhole.test
vcol_blocked_sql_funcs.test
vcol_blocked_sql_funcs_main.inc
vcol_column_def_options_innodb.test
vcol_column_def_options_myisam.test
vcol_csv.test
vcol_handler_aria.test
vcol_handler_innodb.test
vcol_handler_myisam.test
vcol_ins_upd_innodb.test
vcol_ins_upd_myisam.test
vcol_keys_aria.test
vcol_keys_innodb.opt
vcol_keys_innodb.test
vcol_keys_myisam.test MDEV-31005: Make working cursor-protocol 2024-09-18 18:39:26 +07:00
vcol_memory.test
vcol_merge.test
vcol_misc.opt vcols: cannot use CONTEXT_ANALYSIS_ONLY_VCOL_EXPR on fix_fields 2022-04-19 17:10:05 +02:00
vcol_misc.test MDEV-26891 Segfault in Field::register_field_in_read_map upon INSERT 2025-01-14 18:56:13 +03:00
vcol_non_stored_columns_innodb.test
vcol_non_stored_columns_myisam.test
vcol_partition_innodb.test
vcol_partition_myisam.test
vcol_select_innodb.test MDEV-4750 follow-up: Reduce disabling innodb_stats_persistent 2021-08-31 13:55:02 +03:00
vcol_select_myisam.test
vcol_sql_mode.test
vcol_sql_mode_datetime.test
vcol_sql_mode_time.test
vcol_sql_mode_timestamp.test
vcol_sql_mode_upgrade.test
vcol_supported_sql_funcs.test
vcol_supported_sql_funcs_main.inc
vcol_syntax.test Merge branch '10.5' into 10.6 2023-12-17 11:20:43 +01:00
vcol_trigger_sp_innodb.test
vcol_trigger_sp_myisam.test
vcol_utf32.test MDEV-27966 Assertion fixed()' failed and Assertion fixed == 1' failed, both in Item_func_concat::val_str on SELECT after INSERT with collation utf32_bin on utf8_bin table 2024-06-19 10:01:30 +04:00
vcol_view_innodb.test MDEV-4750 follow-up: Reduce disabling innodb_stats_persistent 2021-08-31 13:55:02 +03:00
vcol_view_myisam.test
wrong_arena.test MDEV-31003: Second execution for ps-protocol 2023-07-26 17:15:00 +07:00