diff options
| author | Alexey Botchkov <holyfoot@askmonty.org> | 2019-07-30 21:57:48 +0400 |
|---|---|---|
| committer | Alexey Botchkov <holyfoot@askmonty.org> | 2019-07-30 21:57:48 +0400 |
| commit | c6efbc543d6fb3004f320ef9d02542a4692ca88a (patch) | |
| tree | 4a2df43eb04ddcbf30878add945cb0577f4121aa /mysql-test/suite/versioning | |
| parent | 4b5a14d0fe3d6945a0a9516261f563dcfd1f2c9c (diff) | |
| download | mariadb-git-c6efbc543d6fb3004f320ef9d02542a4692ca88a.tar.gz | |
MDEV-17544 No warning when trying to name a primary key constraint.
Warning added.
Diffstat (limited to 'mysql-test/suite/versioning')
| -rw-r--r-- | mysql-test/suite/versioning/r/online.result | 4 | ||||
| -rw-r--r-- | mysql-test/suite/versioning/r/trx_id.result | 4 |
2 files changed, 6 insertions, 2 deletions
diff --git a/mysql-test/suite/versioning/r/online.result b/mysql-test/suite/versioning/r/online.result index 21441acb6b2..f3a7241d884 100644 --- a/mysql-test/suite/versioning/r/online.result +++ b/mysql-test/suite/versioning/r/online.result @@ -66,7 +66,9 @@ alter table t2 change a a int with system versioning, add primary key pk (a); affected rows: 0 -info: Records: 0 Duplicates: 0 Warnings: 0 +info: Records: 0 Duplicates: 0 Warnings: 1 +Warnings: +Warning 1280 Name 'pk' ignored for PRIMARY key. update t1 set a=2; select count(*) from t1 for system_time all; count(*) diff --git a/mysql-test/suite/versioning/r/trx_id.result b/mysql-test/suite/versioning/r/trx_id.result index 951e5ce3dd9..98543caadbc 100644 --- a/mysql-test/suite/versioning/r/trx_id.result +++ b/mysql-test/suite/versioning/r/trx_id.result @@ -421,7 +421,9 @@ ALTER TABLE t CHANGE a a INT WITH SYSTEM VERSIONING, ADD PRIMARY KEY pk(a); affected rows: 0 -info: Records: 0 Duplicates: 0 Warnings: 0 +info: Records: 0 Duplicates: 0 Warnings: 1 +Warnings: +Warning 1280 Name 'pk' ignored for PRIMARY key. SELECT c.prtype FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS AS c INNER JOIN INFORMATION_SCHEMA.INNODB_SYS_TABLES AS t ON c.table_id=t.table_id |