summaryrefslogtreecommitdiff
path: root/mysql-test/suite/versioning/t/create.test
diff options
context:
space:
mode:
authorNikita Malyavin <nikitamalyavin@gmail.com>2018-06-22 16:26:43 +0300
committerNikita Malyavin <nikitamalyavin@gmail.com>2019-09-11 19:36:09 +0300
commit8e3a1c576ef26afea79a7b5d782564c96f3722ef (patch)
treecc61a628def4450adedcb8b6e89edf5f63ff3a9c /mysql-test/suite/versioning/t/create.test
parent5c5452a5a086a9584efb2255059da671fff6e484 (diff)
downloadmariadb-git-10.4-nikita-merge.tar.gz
cherry-pick MDEV-1649010.4-nikita-merge
Diffstat (limited to 'mysql-test/suite/versioning/t/create.test')
-rw-r--r--mysql-test/suite/versioning/t/create.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/t/create.test b/mysql-test/suite/versioning/t/create.test
index 64858bbe0ec..c98c23f4c05 100644
--- a/mysql-test/suite/versioning/t/create.test
+++ b/mysql-test/suite/versioning/t/create.test
@@ -396,3 +396,14 @@ create table t (
) with system versioning;
--source suite/versioning/common_finish.inc
+--echo # MDEV-16490 It's possible to make a system versioned table without any versioning field
+create or replace table t1 (x int without system versioning)
+with system versioning
+select 1 as y;
+--error ER_VERS_TABLE_MUST_HAVE_COLUMNS
+create or replace table t1 (x int without system versioning)
+with system versioning
+select 1 as x;
+
+drop database test;
+create database test;