diff options
| author | unknown <magnus@neptunus.(none)> | 2004-05-10 14:14:14 +0200 |
|---|---|---|
| committer | unknown <magnus@neptunus.(none)> | 2004-05-10 14:14:14 +0200 |
| commit | e6bec02e3de1aa7e5da4cc8ee5f6467eec47ebcc (patch) | |
| tree | fe214103ff11134e62cabb7c64b42a4cbc25ab96 /mysql-test/r/ndb_basic.result | |
| parent | 444fc1ce984243126e6912bd584966269ad44fa7 (diff) | |
| download | mariadb-git-e6bec02e3de1aa7e5da4cc8ee5f6467eec47ebcc.tar.gz | |
Updated ndb_basic
mysql-test/r/ndb_basic.result:
Updated ndb_basic for better coverage
mysql-test/t/ndb_basic.test:
Updated ndb_basic for better coverage
Diffstat (limited to 'mysql-test/r/ndb_basic.result')
| -rw-r--r-- | mysql-test/r/ndb_basic.result | 54 |
1 files changed, 51 insertions, 3 deletions
diff --git a/mysql-test/r/ndb_basic.result b/mysql-test/r/ndb_basic.result index ac550937146..4e26ac8e0b5 100644 --- a/mysql-test/r/ndb_basic.result +++ b/mysql-test/r/ndb_basic.result @@ -25,11 +25,59 @@ pk1 attr1 DELETE FROM t1; SELECT * FROM t1; pk1 attr1 -INSERT INTO t1 VALUES (9410,9412); +INSERT INTO t1 VALUES (9410,9412), (9411, 9413), (9408, 8765), +(7,8), (8,9), (9,10), (10,11), (11,12), (12,13), (13,14); +UPDATE t1 SET attr1 = 9999; +SELECT * FROM t1 ORDER BY pk1; +pk1 attr1 +7 9999 +8 9999 +9 9999 +10 9999 +11 9999 +12 9999 +13 9999 +9408 9999 +9410 9999 +9411 9999 +UPDATE t1 SET attr1 = 9998 WHERE pk1 < 1000; +SELECT * FROM t1 ORDER BY pk1; +pk1 attr1 +7 9998 +8 9998 +9 9998 +10 9998 +11 9998 +12 9998 +13 9998 +9408 9999 +9410 9999 +9411 9999 +UPDATE t1 SET attr1 = 9997 WHERE attr1 = 9999; +SELECT * FROM t1 ORDER BY pk1; +pk1 attr1 +7 9998 +8 9998 +9 9998 +10 9998 +11 9998 +12 9998 +13 9998 +9408 9997 +9410 9997 +9411 9997 DELETE FROM t1 WHERE pk1 = 9410; -SELECT * FROM t1; +SELECT * FROM t1 ORDER BY pk1; pk1 attr1 -INSERT INTO t1 VALUES (9410,9412), (9411, 9413), (9408, 8765); +7 9998 +8 9998 +9 9998 +10 9998 +11 9998 +12 9998 +13 9998 +9408 9997 +9411 9997 DELETE FROM t1; SELECT * FROM t1; pk1 attr1 |