Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit52ca149

Browse files
committed
Update regress tests to reflect removal of 'current'.
1 parent370174b commit52ca149

File tree

9 files changed

+13
-11
lines changed

9 files changed

+13
-11
lines changed

‎src/test/regress/expected/abstime-solaris-1947.out

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
--
1111
CREATE TABLE ABSTIME_TBL (f1 abstime);
1212
BEGIN;
13-
INSERT INTO ABSTIME_TBL (f1) VALUES (abstime 'current');
13+
INSERT INTO ABSTIME_TBL (f1) VALUES (abstime 'now');
1414
INSERT INTO ABSTIME_TBL (f1) VALUES (abstime 'now');
1515
SELECT count(*) AS two FROM ABSTIME_TBL WHERE f1 = 'now' ;
1616
two

‎src/test/regress/expected/abstime.out

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -10,7 +10,7 @@
1010
--
1111
CREATE TABLE ABSTIME_TBL (f1 abstime);
1212
BEGIN;
13-
INSERT INTO ABSTIME_TBL (f1) VALUES (abstime 'current');
13+
INSERT INTO ABSTIME_TBL (f1) VALUES (abstime 'now');
1414
INSERT INTO ABSTIME_TBL (f1) VALUES (abstime 'now');
1515
SELECT count(*) AS two FROM ABSTIME_TBL WHERE f1 = 'now' ;
1616
two

‎src/test/regress/expected/horology-no-DST-before-1970.out

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2000,7 +2000,7 @@ SELECT '' AS three, ABSTIME_TBL.*
20002000
--
20012001
SELECT '' AS "16", f1 AS "timestamp", date(f1) AS date
20022002
FROM TEMP_TIMESTAMP
2003-
WHERE f1 <> timestamp 'current'
2003+
WHERE f1 <> timestamp 'now'
20042004
ORDER BY date, "timestamp";
20052005
16 | timestamp | date
20062006
----+------------------------------+------------
@@ -2047,7 +2047,7 @@ SELECT '' AS "16", f1 AS "timestamp", abstime(f1) AS abstime
20472047

20482048
SELECT '' AS four, f1 AS abstime, date(f1) AS date
20492049
FROM ABSTIME_TBL
2050-
WHERE isfinite(f1) AND f1 <> abstime 'current'
2050+
WHERE isfinite(f1) AND f1 <> abstime 'now'
20512051
ORDER BY date, abstime;
20522052
four | abstime | date
20532053
------+------------------------------+------------

‎src/test/regress/expected/horology-solaris-1947.out

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2000,7 +2000,7 @@ SELECT '' AS three, ABSTIME_TBL.*
20002000
--
20012001
SELECT '' AS "16", f1 AS "timestamp", date(f1) AS date
20022002
FROM TEMP_TIMESTAMP
2003-
WHERE f1 <> timestamp 'current'
2003+
WHERE f1 <> timestamp 'now'
20042004
ORDER BY date, "timestamp";
20052005
16 | timestamp | date
20062006
----+------------------------------+------------
@@ -2047,7 +2047,7 @@ SELECT '' AS "16", f1 AS "timestamp", abstime(f1) AS abstime
20472047

20482048
SELECT '' AS four, f1 AS abstime, date(f1) AS date
20492049
FROM ABSTIME_TBL
2050-
WHERE isfinite(f1) AND f1 <> abstime 'current'
2050+
WHERE isfinite(f1) AND f1 <> abstime 'now'
20512051
ORDER BY date, abstime;
20522052
four | abstime | date
20532053
------+------------------------------+------------

‎src/test/regress/expected/horology.out

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2000,7 +2000,7 @@ SELECT '' AS three, ABSTIME_TBL.*
20002000
--
20012001
SELECT '' AS "16", f1 AS "timestamp", date(f1) AS date
20022002
FROM TEMP_TIMESTAMP
2003-
WHERE f1 <> timestamp 'current'
2003+
WHERE f1 <> timestamp 'now'
20042004
ORDER BY date, "timestamp";
20052005
16 | timestamp | date
20062006
----+------------------------------+------------
@@ -2047,7 +2047,7 @@ SELECT '' AS "16", f1 AS "timestamp", abstime(f1) AS abstime
20472047

20482048
SELECT '' AS four, f1 AS abstime, date(f1) AS date
20492049
FROM ABSTIME_TBL
2050-
WHERE isfinite(f1) AND f1 <> abstime 'current'
2050+
WHERE isfinite(f1) AND f1 <> abstime 'now'
20512051
ORDER BY date, abstime;
20522052
four | abstime | date
20532053
------+------------------------------+------------

‎src/test/regress/expected/timestamp.out

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -11,6 +11,7 @@ CREATE TABLE TIMESTAMP_TBL ( d1 timestamp(2) without time zone);
1111
-- statements.
1212
INSERT INTO TIMESTAMP_TBL VALUES ('now');
1313
INSERT INTO TIMESTAMP_TBL VALUES ('current');
14+
ERROR: Bad timestamp external representation 'current'
1415
INSERT INTO TIMESTAMP_TBL VALUES ('today');
1516
INSERT INTO TIMESTAMP_TBL VALUES ('yesterday');
1617
INSERT INTO TIMESTAMP_TBL VALUES ('tomorrow');

‎src/test/regress/expected/timestamptz.out

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -6,6 +6,7 @@ SET australian_timezones = 'off';
66
CREATE TABLE TIMESTAMPTZ_TBL ( d1 timestamp(2) with time zone);
77
INSERT INTO TIMESTAMPTZ_TBL VALUES ('now');
88
INSERT INTO TIMESTAMPTZ_TBL VALUES ('current');
9+
ERROR: Bad timestamp external representation 'current'
910
INSERT INTO TIMESTAMPTZ_TBL VALUES ('today');
1011
INSERT INTO TIMESTAMPTZ_TBL VALUES ('yesterday');
1112
INSERT INTO TIMESTAMPTZ_TBL VALUES ('tomorrow');

‎src/test/regress/sql/abstime.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -13,7 +13,7 @@
1313
CREATETABLEABSTIME_TBL (f1 abstime);
1414

1515
BEGIN;
16-
INSERT INTO ABSTIME_TBL (f1)VALUES (abstime'current');
16+
INSERT INTO ABSTIME_TBL (f1)VALUES (abstime'now');
1717
INSERT INTO ABSTIME_TBL (f1)VALUES (abstime'now');
1818
SELECTcount(*)AS twoFROM ABSTIME_TBLWHERE f1='now' ;
1919
END;

‎src/test/regress/sql/horology.sql

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -229,7 +229,7 @@ SELECT '' AS three, ABSTIME_TBL.*
229229

230230
SELECT''AS"16", f1AS"timestamp",date(f1)ASdate
231231
FROM TEMP_TIMESTAMP
232-
WHERE f1<>timestamp'current'
232+
WHERE f1<>timestamp'now'
233233
ORDER BYdate,"timestamp";
234234

235235
SELECT''AS"16", f1AS"timestamp", abstime(f1)AS abstime
@@ -238,7 +238,7 @@ SELECT '' AS "16", f1 AS "timestamp", abstime(f1) AS abstime
238238

239239
SELECT''AS four, f1AS abstime,date(f1)ASdate
240240
FROM ABSTIME_TBL
241-
WHERE isfinite(f1)AND f1<> abstime'current'
241+
WHERE isfinite(f1)AND f1<> abstime'now'
242242
ORDER BYdate, abstime;
243243

244244
SELECT''AS two, d1AS"timestamp", abstime(d1)AS abstime

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp