Changeset: 58df7d0d5887 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=58df7d0d5887
Modified Files:
sql/test/miscellaneous/Tests/groupby_error.test
sql/test/orderidx/Tests/simpletable.test
sql/test/orderidx/Tests/smalltable.test
sql/test/pg_regress/Tests/alter_table.test
sql/test/pg_regress/Tests/numeric.test
sql/test/pg_regress/Tests/without_oid.test
sql/test/sys-schema/Tests/systemfunctions.test
Branch: unlock
Log Message:
fixes for tests as vacuum and friends are gone
diffs (139 lines):
diff --git a/sql/test/miscellaneous/Tests/groupby_error.test
b/sql/test/miscellaneous/Tests/groupby_error.test
--- a/sql/test/miscellaneous/Tests/groupby_error.test
+++ b/sql/test/miscellaneous/Tests/groupby_error.test
@@ -405,7 +405,7 @@ project (
| | | table(sys.tab1) [ "tab1"."part" as "myalias0"."part", "tab1"."tet" as
"myalias0"."tet" ] COUNT ,
| | | table(sys.tab2) [ "tab2"."myk" as "myalias1"."myk", "tab2"."ups" as
"myalias1"."ups" ] COUNT
| | ) [ "myalias0"."part" = "myalias1"."myk" ]
-| ) [ "myalias0"."part", "myalias0"."tet" as "track", "myalias1"."ups" ] [
"myalias0"."part", "track", sys.count() NOT NULL as "%1"."%1" ]
+| ) [ "myalias1"."ups", "myalias0"."part", "myalias0"."tet" as "track" ] [
"myalias0"."part", "track", sys.count() NOT NULL as "%1"."%1" ]
) [ "myalias0"."part", "track" as "tet", "%1"."%1" NOT NULL as "mycount",
"track" ]
query IIII rowsort
diff --git a/sql/test/orderidx/Tests/simpletable.test
b/sql/test/orderidx/Tests/simpletable.test
--- a/sql/test/orderidx/Tests/simpletable.test
+++ b/sql/test/orderidx/Tests/simpletable.test
@@ -32,7 +32,7 @@ 12
0
False
0
-False
+NULL
False
statement ok
@@ -53,8 +53,8 @@ 12
0
False
0
+NULL
False
-True
query I rowsort
SELECT * FROM xtmp1 WHERE i<0
diff --git a/sql/test/orderidx/Tests/smalltable.test
b/sql/test/orderidx/Tests/smalltable.test
--- a/sql/test/orderidx/Tests/smalltable.test
+++ b/sql/test/orderidx/Tests/smalltable.test
@@ -106,7 +106,7 @@ 3
0
False
0
-False
+NULL
False
statement ok
@@ -127,8 +127,8 @@ 3
0
False
0
+NULL
False
-True
query I rowsort
SELECT * FROM xtmp4 WHERE i>=0 AND i<8
diff --git a/sql/test/pg_regress/Tests/alter_table.test
b/sql/test/pg_regress/Tests/alter_table.test
--- a/sql/test/pg_regress/Tests/alter_table.test
+++ b/sql/test/pg_regress/Tests/alter_table.test
@@ -1147,15 +1147,6 @@ analyze atacc1(a)
statement error
analyze atacc1("........pg.dropped.1........")
-statement error
-vacuum analyze atacc1(a)
-
-statement error
-vacuum analyze atacc1("........pg.dropped.1........")
-
-statement ok
-call vacuum('sys', 'atacc1')
-
statement ok
call analyze(0, 0, 'sys', 'atacc1')
diff --git a/sql/test/pg_regress/Tests/numeric.test
b/sql/test/pg_regress/Tests/numeric.test
--- a/sql/test/pg_regress/Tests/numeric.test
+++ b/sql/test/pg_regress/Tests/numeric.test
@@ -1382,30 +1382,6 @@ statement ok
INSERT INTO num_data VALUES (9, '-24926804.045047420')
statement ok
-call vacuum('sys', 'num_exp_add')
-
-statement ok
-call vacuum('sys', 'num_exp_sub')
-
-statement ok
-call vacuum('sys', 'num_exp_div')
-
-statement ok
-call vacuum('sys', 'num_exp_mul')
-
-statement ok
-call vacuum('sys', 'num_exp_sqrt')
-
-statement ok
-call vacuum('sys', 'num_exp_ln')
-
-statement ok
-call vacuum('sys', 'num_exp_log10')
-
-statement ok
-call vacuum('sys', 'num_exp_power_10_ln')
-
-statement ok
CREATE UNIQUE INDEX num_exp_add_idx ON num_exp_add (id1, id2)
statement ok
diff --git a/sql/test/pg_regress/Tests/without_oid.test
b/sql/test/pg_regress/Tests/without_oid.test
--- a/sql/test/pg_regress/Tests/without_oid.test
+++ b/sql/test/pg_regress/Tests/without_oid.test
@@ -85,15 +85,9 @@ SELECT count(i) FROM wo
9136
statement ok
-call vacuum('sys', 'wi')
-
-statement ok
analyze sys.wi
statement ok
-call vacuum('sys', 'wo')
-
-statement ok
analyze sys.wo
query TTTTIIIIIIT rowsort
diff --git a/sql/test/sys-schema/Tests/systemfunctions.test
b/sql/test/sys-schema/Tests/systemfunctions.test
--- a/sql/test/sys-schema/Tests/systemfunctions.test
+++ b/sql/test/sys-schema/Tests/systemfunctions.test
@@ -6,6 +6,6 @@ select s.name as "schema", f.name as "fu
and f.system
order by s.name, f.name, f.id, a.number
----
-21770 values hashing to 654890d1d2aec83280cd4629f387f937
+21735 values hashing to 6c5e19f87f5f32ba4387ee54b026514c
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
