diff options
| author | serg@serg.mysql.com <> | 2002-12-02 21:12:25 +0100 |
|---|---|---|
| committer | serg@serg.mysql.com <> | 2002-12-02 21:12:25 +0100 |
| commit | 451440f930f98a095ca738af28b181b3631a7d46 (patch) | |
| tree | 1501a640db8ab613fb995045575d785c925595ff /mysql-test/t/insert_update.test | |
| parent | e54134fde720f27e4a613e1be27ae2fb2a521388 (diff) | |
| download | mariadb-git-451440f930f98a095ca738af28b181b3631a7d46.tar.gz | |
one more test
Diffstat (limited to 'mysql-test/t/insert_update.test')
| -rw-r--r-- | mysql-test/t/insert_update.test | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/mysql-test/t/insert_update.test b/mysql-test/t/insert_update.test index 1c0cfff8167..cd92999ece8 100644 --- a/mysql-test/t/insert_update.test +++ b/mysql-test/t/insert_update.test @@ -16,4 +16,6 @@ TRUNCATE TABLE t1; INSERT t1 VALUES (1,2,10), (3,4,20); INSERT t1 VALUES (5,6,30), (7,4,40), (8,9,60) ON DUPLICATE KEY UPDATE SET c=c+100; SELECT * FROM t1; +INSERT t1 SET a=5 ON DUPLICATE KEY UPDATE SET b=0; +SELECT * FROM t1; DROP TABLE t1; |