diff options
Diffstat (limited to 'mysql-test/r/insert_select.result')
| -rw-r--r-- | mysql-test/r/insert_select.result | 18 |
1 files changed, 3 insertions, 15 deletions
diff --git a/mysql-test/r/insert_select.result b/mysql-test/r/insert_select.result index 611c6f2712e..ac71ba05d58 100644 --- a/mysql-test/r/insert_select.result +++ b/mysql-test/r/insert_select.result @@ -74,8 +74,8 @@ 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 4 Format_desc 1 95 Server ver: VERSION, Binlog ver: 4 -master-bin.000001 95 Query 1 190 use `test`; insert into t1 select * from t2 +master-bin.000001 4 Format_desc 1 96 Server ver: VERSION, Binlog ver: 4 +master-bin.000001 96 Query 1 184 use `test`; insert into t1 select * from t2 select * from t1; a 1 @@ -88,7 +88,7 @@ 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 4 Format_desc 1 95 Server ver: VERSION, Binlog ver: 4 +master-bin.000001 4 Format_desc 1 96 Server ver: VERSION, Binlog ver: 4 drop table t1; create table t1 (a int not null); create table t2 (a int not null); @@ -638,15 +638,3 @@ No Field Count 0 1 100 0 2 100 drop table t1, t2; -CREATE TABLE t1 ( -ID int(11) NOT NULL auto_increment, -NO int(11) NOT NULL default '0', -SEQ int(11) NOT NULL default '0', -PRIMARY KEY (ID), -KEY t1$NO (SEQ,NO) -) ENGINE=MyISAM; -INSERT INTO t1 (SEQ, NO) SELECT "1" AS SEQ, IF(MAX(NO) IS NULL, 0, MAX(NO)) + 1 AS NO FROM t1 WHERE (SEQ = 1); -select SQL_BUFFER_RESULT * from t1 WHERE (SEQ = 1); -ID NO SEQ -1 1 1 -drop table t1; |