mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-08-03 00:51:35 +02:00
Code Issues Projects Releases Packages Wiki Activity
mariadb/mysql-test/suite/gcol/r
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
..
federated_gcol.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_archive.result MDEV-11066 use MySQL terminology for "virtual columns" 2016-12-12 20:35:51 +01:00
gcol_blackhole.result MDEV-11066 use MySQL terminology for "virtual columns" 2016-12-12 20:35:51 +01:00
gcol_blocked_sql_funcs_innodb.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_blocked_sql_funcs_myisam.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_bug20746926.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_bugfixes.result update test results for embedded 2017-03-29 13:37:18 +02:00
gcol_column_def_options_innodb.result MDEV-11117 CHECK constraint fails on intermediate step of ALTER 2017-04-17 15:32:44 -07:00
gcol_column_def_options_myisam.result MDEV-11117 CHECK constraint fails on intermediate step of ALTER 2017-04-17 15:32:44 -07:00
gcol_csv.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_falcon.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_handler_innodb.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_handler_myisam.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_ins_upd_innodb.result MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
gcol_ins_upd_myisam.result MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
gcol_keys_innodb.result Item::print(): remove redundant parentheses 2016-12-12 20:44:41 +01:00
gcol_keys_myisam.result MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
gcol_memory.result MDEV-11066 use MySQL terminology for "virtual columns" 2016-12-12 20:35:51 +01:00
gcol_merge.result MDEV-11066 use MySQL terminology for "virtual columns" 2016-12-12 20:35:51 +01:00
gcol_ndb.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_non_stored_columns_innodb.result Item::print(): remove redundant parentheses 2016-12-12 20:44:41 +01:00
gcol_non_stored_columns_myisam.result Item::print(): remove redundant parentheses 2016-12-12 20:44:41 +01:00
gcol_partition_innodb.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_partition_myisam.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_rejected_innodb.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_rollback.result MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
gcol_select_innodb.result MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
gcol_select_myisam.result MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
gcol_supported_sql_funcs_innodb.result MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
gcol_supported_sql_funcs_myisam.result MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
gcol_trigger_sp_innodb.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_trigger_sp_myisam.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_update.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_view_innodb.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
gcol_view_myisam.result gcol mysql-test suite from 5.7 2016-12-12 20:27:36 +01:00
innodb_partition.result MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
innodb_prefix_index_check.result MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
innodb_virtual_basic.result MDEV-7635: Update tests to adapt to the new default sql_mode 2017-02-10 06:30:42 -05:00
innodb_virtual_blob.result MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
innodb_virtual_debug.result 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.result update a forgotten result file 2017-03-29 00:40:41 +02:00
innodb_virtual_fk.result Bug #23533396 ASSERTION !M_PREBUILT->TRX->CHECK_FOREIGNS 2017-04-26 23:03:27 +03:00
innodb_virtual_fk_restart.result MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
innodb_virtual_index.result Merge branch '10.1' into 10.2 2016-12-29 13:23:18 +01:00
innodb_virtual_purge.result MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
innodb_wl8114.result MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
main_alter_table.result MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
main_mysqldump.result MDEV-5800 InnoDB support for indexed vcols 2016-12-12 20:27:42 +01:00
rpl_gcol.result Item::print(): remove redundant parentheses 2016-12-12 20:44:41 +01:00