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/t/ndb_insert.test | |
| parent | 3372c31d12f30621c9cacd9b0e91044fc917a846 (diff) | |
| download | mariadb-git-e39256f8f44842e962289cd4abcfaaea4a5dd631.tar.gz | |
Added tests with IGNORE and NULL values
Diffstat (limited to 'mysql-test/t/ndb_insert.test')
| -rw-r--r-- | mysql-test/t/ndb_insert.test | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_insert.test b/mysql-test/t/ndb_insert.test index 4fe847058c4..bf25ca9a133 100644 --- a/mysql-test/t/ndb_insert.test +++ b/mysql-test/t/ndb_insert.test @@ -619,7 +619,15 @@ 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; DROP TABLE t1; +# Ignore and NULL values +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; +DROP TABLE t1; + # End of 4.1 tests |