Changeset: 644b84aef6c9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/644b84aef6c9
Modified Files:
sql/test/dict/Tests/dict03.py
Branch: Jan2022
Log Message:
Missed order by clause to keep test deterministic
diffs (28 lines):
diff --git a/sql/test/dict/Tests/dict03.py b/sql/test/dict/Tests/dict03.py
--- a/sql/test/dict/Tests/dict03.py
+++ b/sql/test/dict/Tests/dict03.py
@@ -23,19 +23,19 @@ with tempfile.TemporaryDirectory() as fa
CREATE TABLE "t1" ("c0" CLOB);
INSERT INTO "t1" VALUES ('85'),('ieyE7bk'),('#2MP'),('v汉字'),('2');
COMMIT""").assertSucceeded()
- mdb.execute("SELECT c0 FROM
t1").assertSucceeded().assertDataResultMatch([('85',),('ieyE7bk',),('#2MP',),('v汉字',),('2',)])
+ mdb.execute("SELECT c0 FROM t1 ORDER BY
c0;").assertSucceeded().assertDataResultMatch([('#2MP',),('2',),('85',),('ieyE7bk',),('v汉字',)])
mdb.execute("CALL
\"sys\".\"dict_compress\"('sys','t1','c0');").assertSucceeded()
- mdb.execute("SELECT c0 FROM
t1").assertSucceeded().assertDataResultMatch([('85',),('ieyE7bk',),('#2MP',),('v汉字',),('2',)])
+ mdb.execute("SELECT c0 FROM t1 ORDER BY
c0;").assertSucceeded().assertDataResultMatch([('#2MP',),('2',),('85',),('ieyE7bk',),('v汉字',)])
mdb.execute("TRUNCATE TABLE
t1;").assertSucceeded().assertRowCount(5)
- mdb.execute("SELECT c0 FROM
t1").assertSucceeded().assertDataResultMatch([])
+ mdb.execute("SELECT c0 FROM t1 ORDER BY
c0;").assertSucceeded().assertDataResultMatch([])
mdb.execute("INSERT INTO t1(c0) VALUES(''), ('3be汉字0'),
('aa8877');").assertSucceeded().assertRowCount(3)
- mdb.execute("SELECT c0 FROM
t1").assertSucceeded().assertDataResultMatch([('',),('3be汉字0',),('aa8877',)])
+ mdb.execute("SELECT c0 FROM t1 ORDER BY
c0;").assertSucceeded().assertDataResultMatch([('',),('3be汉字0',),('aa8877',)])
s.communicate()
with process.server(mapiport=port, dbname='db1',
dbfarm=os.path.join(farm_dir, 'db1'), stdin = process.PIPE, stdout =
process.PIPE, stderr = process.PIPE) as s:
with SQLTestCase() as mdb:
mdb.connect(database='db1', port=port, username="monetdb",
password="monetdb")
- mdb.execute("SELECT c0 FROM
t1").assertSucceeded().assertDataResultMatch([('',),('3be汉字0',),('aa8877',)])
+ mdb.execute("SELECT c0 FROM t1 ORDER BY
c0;").assertSucceeded().assertDataResultMatch([('',),('3be汉字0',),('aa8877',)])
mdb.execute("""
START TRANSACTION;
DROP TABLE t1;
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
