diff options
| author | unknown <ram@gw.mysql.r18.ru> | 2004-11-02 19:48:37 +0400 |
|---|---|---|
| committer | unknown <ram@gw.mysql.r18.ru> | 2004-11-02 19:48:37 +0400 |
| commit | c940b515d46247a5b1107bedf30d074721ef2dc9 (patch) | |
| tree | 9eb804ab66052766d5f9678fe5de9c51e8c85203 /mysql-test/r/ndb_insert.result | |
| parent | 03a91f9bb77100a377c1a60e005957ac779815b7 (diff) | |
| download | mariadb-git-c940b515d46247a5b1107bedf30d074721ef2dc9.tar.gz | |
A fix (bug #6331: INSERT IGNORE .. SELECT breaks subsequent inserts).
Diffstat (limited to 'mysql-test/r/ndb_insert.result')
| -rw-r--r-- | mysql-test/r/ndb_insert.result | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_insert.result b/mysql-test/r/ndb_insert.result index cdc445558b9..16c76f39680 100644 --- a/mysql-test/r/ndb_insert.result +++ b/mysql-test/r/ndb_insert.result @@ -557,3 +557,32 @@ select * from t1 where pk1=1; pk1 b c 1 2 3 DROP TABLE t1; +CREATE TABLE t1(a INT) ENGINE=ndb; +INSERT IGNORE INTO t1 VALUES (1); +INSERT IGNORE INTO t1 VALUES (1); +INSERT IGNORE INTO t1 SELECT a FROM t1; +INSERT IGNORE INTO t1 SELECT a FROM t1; +INSERT IGNORE INTO t1 SELECT a FROM t1; +INSERT IGNORE INTO t1 VALUES (1); +INSERT IGNORE INTO t1 VALUES (1); +SELECT * FROM t1; +a +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +DROP TABLE t1; |