diff options
| author | unknown <evgen@moonbone.local> | 2007-03-16 00:15:16 +0300 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2007-03-16 00:15:16 +0300 |
| commit | 496f421a697568efcd8b47d746b3682a3e97fcf8 (patch) | |
| tree | a4b61939dbc03378f134271a27ee7b4714b7fc0e /mysql-test/r | |
| parent | b42da2dd01b718766d8b0339f68399935de6dd9f (diff) | |
| parent | c6ab94bdf17340a57ec1f4575c644f27117b11cf (diff) | |
| download | mariadb-git-496f421a697568efcd8b47d746b3682a3e97fcf8.tar.gz | |
Merge moonbone.local:/mnt/gentoo64/work/27033-bug-5.0-opt-mysql
into moonbone.local:/mnt/gentoo64/work/test-5.1-opt-mysql
mysql-test/r/insert_update.result:
Auto merged
mysql-test/t/insert_update.test:
Auto merged
sql/sql_class.h:
Manual merge
sql/sql_insert.cc:
Manual merge
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/insert_update.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/insert_update.result b/mysql-test/r/insert_update.result index f608e0e7895..b7a5a9a65ff 100644 --- a/mysql-test/r/insert_update.result +++ b/mysql-test/r/insert_update.result @@ -236,3 +236,14 @@ INSERT INTO t2 VALUES (1), (3); INSERT INTO t1 SELECT 1, COUNT(*) FROM t2 ON DUPLICATE KEY UPDATE j= a; ERROR 42S22: Unknown column 'a' in 'field list' DROP TABLE t1,t2; +CREATE TABLE t1 (f1 INT AUTO_INCREMENT PRIMARY KEY, +f2 VARCHAR(5) NOT NULL UNIQUE); +INSERT t1 (f2) VALUES ('test') ON DUPLICATE KEY UPDATE f1 = LAST_INSERT_ID(f1); +SELECT LAST_INSERT_ID(); +LAST_INSERT_ID() +1 +INSERT t1 (f2) VALUES ('test') ON DUPLICATE KEY UPDATE f1 = LAST_INSERT_ID(f1); +SELECT LAST_INSERT_ID(); +LAST_INSERT_ID() +1 +DROP TABLE t1; |