mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-02-13 17:05:35 +01:00
Code Issues Projects Releases Packages Wiki Activity Actions
mariadb/mysql-test/suite/gcol/t
History
Exact
Thirunarayanan Balathandayuthapani a6adf567fd Bug #23533396 ASSERTION !M_PREBUILT->TRX->CHECK_FOREIGNS 
Analysis:
========
A foreign key constraint cannot reference a secondary index defined
on a generated virtual column. While adding new index/drop existing
column, server internally drops the internal foreign key index and
it leads to choose the virtual secondary index as foreign key index.
But innodb doesn't allow foreign key constraint reference to
secondary virtual index.

Fix:
===
Allow foreign key constraint refer to secondary index defined on
a generated virutal column.

Reviewed-by: Jimmy Yang<jimmy.yang@oracle.com>
RB: 13586
2017-04-26 23:03:27 +03:00
..
gcol_archive.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_blackhole.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_blocked_sql_funcs_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_blocked_sql_funcs_myisam.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_bug20746926.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_bugfixes.test update test results for embedded 2017-03-29 13:37:18 +02:00
gcol_column_def_options_innodb.test MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
gcol_column_def_options_myisam.test MDEV-5800 MyISAM support for indexed vcols 2016-12-12 20:27:36 +01:00
gcol_handler_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_handler_myisam.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_ins_upd_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_ins_upd_myisam.test MDEV-5800 MyISAM support for indexed vcols 2016-12-12 20:27:36 +01:00
gcol_keys_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_keys_myisam.test MDEV-5800 MyISAM support for indexed vcols 2016-12-12 20:27:36 +01:00
gcol_memory.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_merge.test MDEV-11066 use MySQL terminology for "virtual columns" 2016-12-12 20:35:51 +01:00
gcol_non_stored_columns_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_non_stored_columns_myisam.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_partition_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_partition_myisam.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_rejected_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_rollback.test MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
gcol_select_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_select_myisam.test MDEV-5800 MyISAM support for indexed vcols 2016-12-12 20:27:36 +01:00
gcol_supported_sql_funcs_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_supported_sql_funcs_myisam.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_trigger_sp_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_trigger_sp_myisam.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_update.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_view_innodb.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_view_myisam.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
innodb_partition.test MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
innodb_prefix_index_check.test MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
innodb_virtual_basic.test MDEV-11066 use MySQL terminology for "virtual columns" 2016-12-12 20:35:51 +01:00
innodb_virtual_blob.test MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
innodb_virtual_debug.test Bug#22018745 CORRUPTION IN ONLINE TABLE REBUILD (ROW_FORMAT=REDUNDANT, INDEXED VIRTUAL COLUMN) 2017-04-24 17:45:23 +03:00
innodb_virtual_debug_purge.test test how MDL blocks InnoDB purge 2016-12-12 20:27:43 +01:00
innodb_virtual_fk.test Bug #23533396 ASSERTION !M_PREBUILT->TRX->CHECK_FOREIGNS 2017-04-26 23:03:27 +03:00
innodb_virtual_fk_restart.test MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
innodb_virtual_index.test MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
innodb_virtual_purge.test MDEV-11802 preparation: Clean up the purge tests. 2017-02-19 14:51:19 +02:00
innodb_wl8114.test MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
main_alter_table.test MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
main_mysqldump.test MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
rpl_gcol.test gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00