diff options
| author | unknown <mskold@mysql.com> | 2006-03-28 10:01:23 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2006-03-28 10:01:23 +0200 |
| commit | e39256f8f44842e962289cd4abcfaaea4a5dd631 (patch) | |
| tree | 59c937a2c741ee93d2e52879b6f38daa8edb0cbf /mysql-test/r/ndb_insert.result | |
| parent | 3372c31d12f30621c9cacd9b0e91044fc917a846 (diff) | |
| download | mariadb-git-e39256f8f44842e962289cd4abcfaaea4a5dd631.tar.gz | |
Added tests with IGNORE and NULL values
Diffstat (limited to 'mysql-test/r/ndb_insert.result')
| -rw-r--r-- | mysql-test/r/ndb_insert.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_insert.result b/mysql-test/r/ndb_insert.result index 93614419865..0818f9ce9ac 100644 --- a/mysql-test/r/ndb_insert.result +++ b/mysql-test/r/ndb_insert.result @@ -629,7 +629,23 @@ DELETE FROM t1; CREATE UNIQUE INDEX ai ON t1(a); INSERT IGNORE INTO t1 VALUES (1); INSERT IGNORE INTO t1 VALUES (1); +INSERT IGNORE INTO t1 VALUES (NULL),(2); SELECT * FROM t1 ORDER BY a; a +NULL 1 +2 +DROP TABLE t1; +CREATE TABLE t1(pk INT NOT NULL PRIMARY KEY, a INT, UNIQUE (a)) ENGINE=ndb; +INSERT IGNORE INTO t1 VALUES (1,1),(2,2),(3,3); +INSERT IGNORE INTO t1 VALUES (4,NULL),(5,NULL),(6,NULL),(7,4); +SELECT * FROM t1 ORDER BY pk; +pk a +1 1 +2 2 +3 3 +4 NULL +5 NULL +6 NULL +7 4 DROP TABLE t1; |