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/innodb_gis/r | |
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/innodb_gis/r')
-rw-r--r-- | mysql-test/suite/innodb_gis/r/1.result | 4 | ||||
-rw-r--r-- | mysql-test/suite/innodb_gis/r/gis.result | 4 |
2 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb_gis/r/1.result b/mysql-test/suite/innodb_gis/r/1.result index 84e7bec53cd..bb99ba6fca4 100644 --- a/mysql-test/suite/innodb_gis/r/1.result +++ b/mysql-test/suite/innodb_gis/r/1.result @@ -796,11 +796,15 @@ POINT(1 1) drop function fn3; create table t1(pt POINT); alter table t1 add primary key pti(pt); +Warnings: +Warning 1280 Name 'pti' ignored for PRIMARY key. drop table t1; create table t1(pt GEOMETRY); alter table t1 add primary key pti(pt); ERROR 42000: BLOB/TEXT column 'pt' used in key specification without a key length alter table t1 add primary key pti(pt(20)); +Warnings: +Warning 1280 Name 'pti' ignored for PRIMARY key. drop table t1; create table t1 select ST_GeomFromText('point(1 1)'); desc t1; diff --git a/mysql-test/suite/innodb_gis/r/gis.result b/mysql-test/suite/innodb_gis/r/gis.result index 65d1e940cd3..eb5a3d100c1 100644 --- a/mysql-test/suite/innodb_gis/r/gis.result +++ b/mysql-test/suite/innodb_gis/r/gis.result @@ -792,11 +792,15 @@ POINT(1 1) drop function fn3; create table t1(pt POINT); alter table t1 add primary key pti(pt); +Warnings: +Warning 1280 Name 'pti' ignored for PRIMARY key. drop table t1; create table t1(pt GEOMETRY); alter table t1 add primary key pti(pt); ERROR 42000: BLOB/TEXT column 'pt' used in key specification without a key length alter table t1 add primary key pti(pt(20)); +Warnings: +Warning 1280 Name 'pti' ignored for PRIMARY key. drop table t1; create table t1 select ST_GeomFromText('point(1 1)'); desc t1; |