summaryrefslogtreecommitdiff
path: root/mysql-test/suite/vcol/t/innodb_virtual_fk.test
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/suite/vcol/t/innodb_virtual_fk.test')
-rw-r--r--mysql-test/suite/vcol/t/innodb_virtual_fk.test16
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/suite/vcol/t/innodb_virtual_fk.test b/mysql-test/suite/vcol/t/innodb_virtual_fk.test
new file mode 100644
index 00000000000..c364adaa613
--- /dev/null
+++ b/mysql-test/suite/vcol/t/innodb_virtual_fk.test
@@ -0,0 +1,16 @@
+source include/have_innodb.inc;
+set default_storage_engine=innodb;
+
+#
+# MDEV-13708 Crash with indexed virtual columns and FK cascading deletes
+#
+
+create table t1 (id int primary key, id2 int as (id) virtual, key id2 (id2));
+create table t2 (id int key, constraint fk_id foreign key (id) references t1 (id) on delete cascade);
+insert into t1 (id) values (1), (2);
+insert into t2 (id) values (1), (2);
+delete from t1;
+select * from t1;
+select * from t2;
+drop table t2;
+drop table t1;