diff options
| author | Nikita Malyavin <nikitamalyavin@gmail.com> | 2018-06-22 23:26:43 +1000 |
|---|---|---|
| committer | Nikita Malyavin <nikitamalyavin@gmail.com> | 2019-09-09 20:14:47 +0300 |
| commit | f6a7730c4505c14c8b63b00623917ddaf90c60ae (patch) | |
| tree | 09a0fb8dfc60e63826f34f57085367246bd8b17a /mysql-test/suite/versioning/r/create.result | |
| parent | 604f80e77c054758aa449064cdc29dfa13a71922 (diff) | |
| download | mariadb-git-f6a7730c4505c14c8b63b00623917ddaf90c60ae.tar.gz | |
MDEV-16490: It's possible to make a system versioned table without any versioning field
* do not allow versioned table to be without versioned (non-system) fields
* prohibit changing field versioning, when removing table versioning
* handle CREATE...SELECT as well
Diffstat (limited to 'mysql-test/suite/versioning/r/create.result')
| -rw-r--r-- | mysql-test/suite/versioning/r/create.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/suite/versioning/r/create.result b/mysql-test/suite/versioning/r/create.result index 89cec6c038a..f9d13123db5 100644 --- a/mysql-test/suite/versioning/r/create.result +++ b/mysql-test/suite/versioning/r/create.result @@ -515,3 +515,13 @@ row_end datetime(6) generated always as row end, period for system_time(row_start, row_end) ) with system versioning; ERROR HY000: `row_start` must be of type TIMESTAMP(6) for system-versioned table `t` +# 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; +create or replace table t1 (x int without system versioning) +with system versioning +select 1 as x; +ERROR HY000: Table `t1` must have at least one versioned column +drop database test; +create database test; |