diff options
Diffstat (limited to 'mysql-test/r/temp_table.result')
| -rw-r--r-- | mysql-test/r/temp_table.result | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/temp_table.result b/mysql-test/r/temp_table.result index 45f879e182b..7c8d10cf0a6 100644 --- a/mysql-test/r/temp_table.result +++ b/mysql-test/r/temp_table.result @@ -72,6 +72,11 @@ id val elt(two.val,'one','two') 2 1 one 4 2 two drop table t1,t2; +create temporary table t1 (a int not null); +insert into t1 values (1),(1); +alter table t1 add primary key (a); +Duplicate entry '1' for key 1 +drop table t1; drop table if exists t1; CREATE TABLE t1 ( d datetime default NULL |