diff options
| author | unknown <serg@serg.mylan> | 2005-02-16 17:34:02 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2005-02-16 17:34:02 +0100 |
| commit | 519cefd9195e5f2936b5155c403126a1e86af18f (patch) | |
| tree | 035ac3e99dc2b1a103e3b2fd04896b2e3ef10421 /mysql-test/r/insert_select.result | |
| parent | 789f0a6e897028a03a0b527ef03e18254823daf8 (diff) | |
| download | mariadb-git-519cefd9195e5f2936b5155c403126a1e86af18f.tar.gz | |
after merge fixes
Diffstat (limited to 'mysql-test/r/insert_select.result')
| -rw-r--r-- | mysql-test/r/insert_select.result | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/mysql-test/r/insert_select.result b/mysql-test/r/insert_select.result index ac71ba05d58..47f1b18d8a4 100644 --- a/mysql-test/r/insert_select.result +++ b/mysql-test/r/insert_select.result @@ -75,7 +75,7 @@ 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 96 Server ver: VERSION, Binlog ver: 4 -master-bin.000001 96 Query 1 184 use `test`; insert into t1 select * from t2 +master-bin.000001 96 Query 1 191 use `test`; insert into t1 select * from t2 select * from t1; a 1 @@ -638,3 +638,15 @@ 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; |