diff options
author | unknown <ingo@mysql.com> | 2006-01-23 12:17:05 +0100 |
---|---|---|
committer | unknown <ingo@mysql.com> | 2006-01-23 12:17:05 +0100 |
commit | 0369042a0903ac4c0c07ec44f723b34e4f0821e1 (patch) | |
tree | b8e563f22089b8c74c2ba8e68fb041431a9a4829 /mysql-test/r/join_outer.result | |
parent | 098af0ae1aae693829f0c9daef551f2c3571c476 (diff) | |
download | mariadb-git-0369042a0903ac4c0c07ec44f723b34e4f0821e1.tar.gz |
WL#1563 - Modify MySQL to support fast CREATE/DROP INDEX
Change "duplicate key" message to print key name
instead of key number.
Diffstat (limited to 'mysql-test/r/join_outer.result')
-rw-r--r-- | mysql-test/r/join_outer.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/join_outer.result b/mysql-test/r/join_outer.result index 92b352aa608..67fba3dad51 100644 --- a/mysql-test/r/join_outer.result +++ b/mysql-test/r/join_outer.result @@ -169,7 +169,7 @@ usr_id uniq_id increment usr2_id c_amount max 3 4 84676 NULL NULL NULL INSERT INTO t2 VALUES (2,3,3000,6000,0,0,746584,837484,'yes'); INSERT INTO t2 VALUES (2,3,3000,6000,0,0,746584,837484,'yes'); -ERROR 23000: Duplicate entry '2-3' for key 1 +ERROR 23000: Duplicate entry '2-3' for key 'PRIMARY' INSERT INTO t2 VALUES (7,3,1000,2000,0,0,746294,937484,'yes'); SELECT t1.usr_id,t1.uniq_id,t1.increment,t2.usr2_id,t2.c_amount,t2.max FROM t1 LEFT JOIN t2 ON t2.id = t1.uniq_id WHERE t1.uniq_id = 4 ORDER BY t2.c_amount; usr_id uniq_id increment usr2_id c_amount max |