Changeset: 9c76f2e7c5cb for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9c76f2e7c5cb
Modified Files:
sql/test/pg_regress/Tests/timestamp.sql
sql/test/pg_regress/Tests/timestamp.stable.out
sql/test/pg_regress/Tests/timestamptz.sql
sql/test/pg_regress/Tests/timestamptz.stable.out
Branch: default
Log Message:
Small improvement to make the output more stable such that less testweb errors
are reported.
diffs (48 lines):
diff --git a/sql/test/pg_regress/Tests/timestamp.sql
b/sql/test/pg_regress/Tests/timestamp.sql
--- a/sql/test/pg_regress/Tests/timestamp.sql
+++ b/sql/test/pg_regress/Tests/timestamp.sql
@@ -37,7 +37,7 @@ DELETE FROM TIMESTAMP_TBL;
START TRANSACTION;
INSERT INTO TIMESTAMP_TBL VALUES (now);
INSERT INTO TIMESTAMP_TBL VALUES (now());
-SELECT count(*) AS two FROM TIMESTAMP_TBL WHERE d1 = cast(now as timestamp);
+SELECT count(*) AS two FROM TIMESTAMP_TBL WHERE d1 <= cast(now as timestamp);
COMMIT;
DELETE FROM TIMESTAMP_TBL;
diff --git a/sql/test/pg_regress/Tests/timestamp.stable.out
b/sql/test/pg_regress/Tests/timestamp.stable.out
--- a/sql/test/pg_regress/Tests/timestamp.stable.out
+++ b/sql/test/pg_regress/Tests/timestamp.stable.out
@@ -93,7 +93,7 @@ Ready.
[ 1 ]
#INSERT INTO TIMESTAMP_TBL VALUES ('now');
[ 1 ]
-#SELECT count(*) AS two FROM TIMESTAMP_TBL WHERE d1 = cast(now as timestamp);
+#SELECT count(*) AS two FROM TIMESTAMP_TBL WHERE d1 <= cast(now as timestamp);
% sys.L2 # table_name
% two # name
% wrd # type
diff --git a/sql/test/pg_regress/Tests/timestamptz.sql
b/sql/test/pg_regress/Tests/timestamptz.sql
--- a/sql/test/pg_regress/Tests/timestamptz.sql
+++ b/sql/test/pg_regress/Tests/timestamptz.sql
@@ -31,7 +31,7 @@ DELETE FROM TIMESTAMPTZ_TBL;
START TRANSACTION;
INSERT INTO TIMESTAMPTZ_TBL VALUES (now);
INSERT INTO TIMESTAMPTZ_TBL VALUES (now());
-SELECT count(*) AS two FROM TIMESTAMPTZ_TBL WHERE d1 = cast(now as
timestamptz);
+SELECT count(*) AS two FROM TIMESTAMPTZ_TBL WHERE d1 <= cast(now as
timestamptz);
COMMIT;
DELETE FROM TIMESTAMPTZ_TBL;
diff --git a/sql/test/pg_regress/Tests/timestamptz.stable.out
b/sql/test/pg_regress/Tests/timestamptz.stable.out
--- a/sql/test/pg_regress/Tests/timestamptz.stable.out
+++ b/sql/test/pg_regress/Tests/timestamptz.stable.out
@@ -62,7 +62,7 @@ Ready.
[ 1 ]
#INSERT INTO TIMESTAMPTZ_TBL VALUES ('now');
[ 1 ]
-#SELECT count(*) AS two FROM TIMESTAMPTZ_TBL WHERE d1 = cast(now as
timestamptz);
+#SELECT count(*) AS two FROM TIMESTAMPTZ_TBL WHERE d1 <= cast(now as
timestamptz);
% sys.L2 # table_name
% two # name
% wrd # type
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
