From c6efbc543d6fb3004f320ef9d02542a4692ca88a Mon Sep 17 00:00:00 2001 From: Alexey Botchkov Date: Tue, 30 Jul 2019 21:57:48 +0400 Subject: MDEV-17544 No warning when trying to name a primary key constraint. Warning added. --- mysql-test/main/join_cache.result | 2 ++ 1 file changed, 2 insertions(+) (limited to 'mysql-test/main/join_cache.result') diff --git a/mysql-test/main/join_cache.result b/mysql-test/main/join_cache.result index 256a6eda97e..9bb64c0b32c 100644 --- a/mysql-test/main/join_cache.result +++ b/mysql-test/main/join_cache.result @@ -3103,6 +3103,8 @@ CREATE TABLE t2 ( a2 int, b2 int, filler2 char(64) default ' ', PRIMARY KEY idx(a2,b2,filler2) ) ; +Warnings: +Warning 1280 Name 'idx' ignored for PRIMARY key. CREATE TABLE t3 (b3 int, c3 int, INDEX idx(b3)); INSERT INTO t1(a1) VALUES (4), (7), (1), (9), (8), (5), (3), (6), (2); -- cgit v1.2.1