diff options
| author | mskold@mysql.com <> | 2004-07-29 13:32:50 +0200 |
|---|---|---|
| committer | mskold@mysql.com <> | 2004-07-29 13:32:50 +0200 |
| commit | 24f9a2e9bb9a5f0e4d503e0a963107e996fbfd7a (patch) | |
| tree | b37a75354ce723bf420cb137a41ed028fbd2fdb9 /mysql-test/t/ndb_basic.test | |
| parent | 4dd1fc014fb87b4e96d9956237b12059567048a3 (diff) | |
| download | mariadb-git-24f9a2e9bb9a5f0e4d503e0a963107e996fbfd7a.tar.gz | |
Added ORDER BY to ensure same result on all setups/platforms
Diffstat (limited to 'mysql-test/t/ndb_basic.test')
| -rw-r--r-- | mysql-test/t/ndb_basic.test | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/mysql-test/t/ndb_basic.test b/mysql-test/t/ndb_basic.test index 6c120e00942..c3c296113c3 100644 --- a/mysql-test/t/ndb_basic.test +++ b/mysql-test/t/ndb_basic.test @@ -21,19 +21,19 @@ CREATE TABLE t1 ( INSERT INTO t1 VALUES (9410,9412, NULL, '9412'), (9411,9413, 17, '9413'); -SELECT pk1 FROM t1; -SELECT * FROM t1; -SELECT t1.* FROM t1; +SELECT pk1 FROM t1 ORDER BY pk1; +SELECT * FROM t1 ORDER BY pk1; +SELECT t1.* FROM t1 ORDER BY pk1; # Update on record by primary key UPDATE t1 SET attr1=1 WHERE pk1=9410; -SELECT * FROM t1; +SELECT * FROM t1 ORDER BY pk1; # Update primary key UPDATE t1 SET pk1=2 WHERE attr1=1; -SELECT * FROM t1; +SELECT * FROM t1 ORDER BY pk1; UPDATE t1 SET pk1=pk1 + 1; -SELECT * FROM t1; +SELECT * FROM t1 ORDER BY pk1; # Delete the record DELETE FROM t1; @@ -85,9 +85,10 @@ UPDATE t1 SET id=1234 WHERE id2=7890; SELECT * FROM t1; DELETE FROM t1; -INSERT INTO t1 values(3456, 7890), (3456, 7890), (3456, 7890); -SELECT * FROM t1; +INSERT INTO t1 values(3456, 7890), (3456, 7890), (3456, 7890), (3454, 7890); +SELECT * FROM t1 ORDER BY id; DELETE FROM t1 WHERE id = 3456; +SELECT * FROM t1 ORDER BY id; DROP TABLE t1; |