diff options
| author | unknown <mskold@mysql.com> | 2004-07-29 13:32:50 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2004-07-29 13:32:50 +0200 |
| commit | 3dbb52364620707d25b652146227a1348c2614e3 (patch) | |
| tree | b37a75354ce723bf420cb137a41ed028fbd2fdb9 /mysql-test/r | |
| parent | ac64c00dde580f4599737b2a2bfaedd9534622d7 (diff) | |
| download | mariadb-git-3dbb52364620707d25b652146227a1348c2614e3.tar.gz | |
Added ORDER BY to ensure same result on all setups/platforms
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/ndb_basic.result | 22 | ||||
| -rw-r--r-- | mysql-test/r/ndb_lock.result | 21 |
2 files changed, 26 insertions, 17 deletions
diff --git a/mysql-test/r/ndb_basic.result b/mysql-test/r/ndb_basic.result index 7675048ca3c..3dc60b17754 100644 --- a/mysql-test/r/ndb_basic.result +++ b/mysql-test/r/ndb_basic.result @@ -6,33 +6,33 @@ attr2 INT, attr3 VARCHAR(10) ) ENGINE=ndbcluster; INSERT INTO t1 VALUES (9410,9412, NULL, '9412'), (9411,9413, 17, '9413'); -SELECT pk1 FROM t1; +SELECT pk1 FROM t1 ORDER BY pk1; pk1 9410 9411 -SELECT * FROM t1; +SELECT * FROM t1 ORDER BY pk1; pk1 attr1 attr2 attr3 9410 9412 NULL 9412 9411 9413 17 9413 -SELECT t1.* FROM t1; +SELECT t1.* FROM t1 ORDER BY pk1; pk1 attr1 attr2 attr3 9410 9412 NULL 9412 9411 9413 17 9413 UPDATE t1 SET attr1=1 WHERE pk1=9410; -SELECT * FROM t1; +SELECT * FROM t1 ORDER BY pk1; pk1 attr1 attr2 attr3 9410 1 NULL 9412 9411 9413 17 9413 UPDATE t1 SET pk1=2 WHERE attr1=1; -SELECT * FROM t1; +SELECT * FROM t1 ORDER BY pk1; pk1 attr1 attr2 attr3 2 1 NULL 9412 9411 9413 17 9413 UPDATE t1 SET pk1=pk1 + 1; -SELECT * FROM t1; +SELECT * FROM t1 ORDER BY pk1; pk1 attr1 attr2 attr3 -9412 9413 17 9413 3 1 NULL 9412 +9412 9413 17 9413 DELETE FROM t1; SELECT * FROM t1; pk1 attr1 attr2 attr3 @@ -115,13 +115,17 @@ SELECT * FROM t1; id id2 1234 7890 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; id id2 +3454 7890 3456 7890 3456 7890 3456 7890 DELETE FROM t1 WHERE id = 3456; +SELECT * FROM t1 ORDER BY id; +id id2 +3454 7890 DROP TABLE t1; CREATE TABLE t1 ( pk1 INT NOT NULL PRIMARY KEY, diff --git a/mysql-test/r/ndb_lock.result b/mysql-test/r/ndb_lock.result index 94ff5c25e6b..56661913e22 100644 --- a/mysql-test/r/ndb_lock.result +++ b/mysql-test/r/ndb_lock.result @@ -1,25 +1,30 @@ DROP TABLE IF EXISTS t1,t2,t3,t4,t5,t6,t7; create table t1 (x integer not null primary key, y varchar(32)) engine = ndb; insert into t1 values (1,'one'), (2,'two'); -select * from t1; +select * from t1 order by x; x y -2 two 1 one -select * from t1; -x y 2 two +select * from t1 order by x; +x y 1 one +2 two start transaction; insert into t1 values (3,'three'); -start transaction; -select * from t1; +select * from t1 order by x; x y +1 one 2 two +3 three +start transaction; +select * from t1 order by x; +x y 1 one +2 two commit; -select * from t1; +select * from t1 order by x; x y +1 one 2 two 3 three -1 one commit; |