summaryrefslogtreecommitdiff
path: root/mysql-test/r/insert_select.result
diff options
context:
space:
mode:
authorjimw@mysql.com <>2005-04-01 19:17:15 -0800
committerjimw@mysql.com <>2005-04-01 19:17:15 -0800
commit5865330a9e27c050dd644705457eb5d4415e27fd (patch)
tree0f605570b31eecc8dd6b58343d5a07d32375e540 /mysql-test/r/insert_select.result
parent2292480e795a02973b828a37f826c6e4e0192b69 (diff)
parent623a5d5a57f8f8ee2674245e0abafaef698577fb (diff)
downloadmariadb-git-5865330a9e27c050dd644705457eb5d4415e27fd.tar.gz
Merge embedded server testing changes from 4.1.
Diffstat (limited to 'mysql-test/r/insert_select.result')
-rw-r--r--mysql-test/r/insert_select.result25
1 files changed, 0 insertions, 25 deletions
diff --git a/mysql-test/r/insert_select.result b/mysql-test/r/insert_select.result
index 13d4b0e22bc..d2c0a665845 100644
--- a/mysql-test/r/insert_select.result
+++ b/mysql-test/r/insert_select.result
@@ -65,31 +65,6 @@ INSERT INTO t1 (numeropost,icone,contenu,pseudo,date,signature,ip)
SELECT 1718,icone,contenu,pseudo,date,signature,ip FROM t2
WHERE numeropost=9 ORDER BY numreponse ASC;
DROP TABLE t1,t2;
-create table t1(a int, unique(a));
-insert into t1 values(2);
-create table t2(a int);
-insert into t2 values(1),(2);
-reset master;
-insert into t1 select * from t2;
-ERROR 23000: Duplicate entry '2' for key 1
-show binlog events;
-Log_name Pos Event_type Server_id End_log_pos Info
-master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
-master-bin.000001 # Query 1 # use `test`; insert into t1 select * from t2
-select * from t1;
-a
-1
-2
-drop table t1, t2;
-create table t1(a int);
-insert into t1 values(1),(1);
-reset master;
-create table t2(unique(a)) select a from t1;
-ERROR 23000: Duplicate entry '1' for key 1
-show binlog events;
-Log_name Pos Event_type Server_id End_log_pos Info
-master-bin.000001 # Format_desc 1 # Server ver: VERSION, Binlog ver: 4
-drop table t1;
create table t1 (a int not null);
create table t2 (a int not null);
insert into t1 values (1);