summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb_gis/r/gis.result
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2019-07-30 21:57:48 +0400
committerAlexey Botchkov <holyfoot@askmonty.org>2019-07-30 21:57:48 +0400
commitc6efbc543d6fb3004f320ef9d02542a4692ca88a (patch)
tree4a2df43eb04ddcbf30878add945cb0577f4121aa /mysql-test/suite/innodb_gis/r/gis.result
parent4b5a14d0fe3d6945a0a9516261f563dcfd1f2c9c (diff)
downloadmariadb-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/gis.result')
-rw-r--r--mysql-test/suite/innodb_gis/r/gis.result4
1 files changed, 4 insertions, 0 deletions
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;