NotificationsYou must be signed in to change notification settings
Fork28
Star151

Commitd062f0f

committed

Fix collateral damage from error message cleanup.

1 parent8265769 commitd062f0fCopy full SHA for d062f0f

File tree

3 files changed

-9

lines changed

src/test/regress
- expected
  - horology-no-DST-before-1970.out
  - horology-solaris-1947.out
- output
  - create_function_1.source

3 files changed

-9

lines changed

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

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -43,7 +43,7 @@ SELECT date '1991-02-03' - time '04:05:06' AS "Subtract Time";`
`43`	`43`	`(1 row)`
`44`	`44`
`45`	`45`	`SELECT date '1991-02-03' - time with time zone '04:05:06 UTC' AS "Subtract Time UTC";`
`46`		`-ERROR: Unable to identify an operator '-' for types 'date' and 'timetz'`
	`46`	`+ERROR: Unable to identify an operator '-' for types 'date' and 'time with time zone'`
`47`	`47`	`You will have to retype this query using an explicit cast`
`48`	`48`	`--`
`49`	`49`	`-- timestamp, interval arithmetic`
`@@ -118,9 +118,9 @@ SELECT interval '04:30' - time '01:02' AS "+03:28";`
`118`	`118`	`(1 row)`
`119`	`119`
`120`	`120`	`SELECT CAST(time with time zone '01:02-08' AS interval) AS "+00:01";`
`121`		`-ERROR: Cannot cast type 'timetz' to 'interval'`
	`121`	`+ERROR: Cannot cast type 'time with time zone' to 'interval'`
`122`	`122`	`SELECT CAST(interval '02:03' AS time with time zone) AS "02:03:00-08";`
`123`		`-ERROR: Cannot cast type 'interval' to 'timetz'`
	`123`	`+ERROR: Cannot cast type 'interval' to 'time with time zone'`
`124`	`124`	`SELECT time with time zone '01:30-08' - interval '02:01' AS "23:29:00-08";`
`125`	`125`	`23:29:00-08`
`126`	`126`	`-------------`
`@@ -153,7 +153,7 @@ SELECT CAST(date 'today' + time with time zone '03:30'`
`153`	`153`	`(1 row)`
`154`	`154`
`155`	`155`	`SELECT interval '04:30' - time with time zone '01:02' AS "+03:28";`
`156`		`-ERROR: Unable to identify an operator '-' for types 'interval' and 'timetz'`
	`156`	`+ERROR: Unable to identify an operator '-' for types 'interval' and 'time with time zone'`
`157`	`157`	`You will have to retype this query using an explicit cast`
`158`	`158`	`-- We get 100 rows when run in GMT...`
`159`	`159`	`SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i`

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

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -43,7 +43,7 @@ SELECT date '1991-02-03' - time '04:05:06' AS "Subtract Time";`
`43`	`43`	`(1 row)`
`44`	`44`
`45`	`45`	`SELECT date '1991-02-03' - time with time zone '04:05:06 UTC' AS "Subtract Time UTC";`
`46`		`-ERROR: Unable to identify an operator '-' for types 'date' and 'timetz'`
	`46`	`+ERROR: Unable to identify an operator '-' for types 'date' and 'time with time zone'`
`47`	`47`	`You will have to retype this query using an explicit cast`
`48`	`48`	`--`
`49`	`49`	`-- timestamp, interval arithmetic`
`@@ -118,9 +118,9 @@ SELECT interval '04:30' - time '01:02' AS "+03:28";`
`118`	`118`	`(1 row)`
`119`	`119`
`120`	`120`	`SELECT CAST(time with time zone '01:02-08' AS interval) AS "+00:01";`
`121`		`-ERROR: Cannot cast type 'timetz' to 'interval'`
	`121`	`+ERROR: Cannot cast type 'time with time zone' to 'interval'`
`122`	`122`	`SELECT CAST(interval '02:03' AS time with time zone) AS "02:03:00-08";`
`123`		`-ERROR: Cannot cast type 'interval' to 'timetz'`
	`123`	`+ERROR: Cannot cast type 'interval' to 'time with time zone'`
`124`	`124`	`SELECT time with time zone '01:30-08' - interval '02:01' AS "23:29:00-08";`
`125`	`125`	`23:29:00-08`
`126`	`126`	`-------------`
`@@ -153,7 +153,7 @@ SELECT CAST(date 'today' + time with time zone '03:30'`
`153`	`153`	`(1 row)`
`154`	`154`
`155`	`155`	`SELECT interval '04:30' - time with time zone '01:02' AS "+03:28";`
`156`		`-ERROR: Unable to identify an operator '-' for types 'interval' and 'timetz'`
	`156`	`+ERROR: Unable to identify an operator '-' for types 'interval' and 'time with time zone'`
`157`	`157`	`You will have to retype this query using an explicit cast`
`158`	`158`	`-- We get 100 rows when run in GMT...`
`159`	`159`	`SELECT t.d1 + i.f1 AS "102" FROM TIMESTAMP_TBL t, INTERVAL_TBL i`

`‎src/test/regress/output/create_function_1.source`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -5,7 +5,7 @@ CREATE FUNCTION widget_in(opaque)`
`5`	`5`	`RETURNS widget`
`6`	`6`	`AS '@abs_builddir@/regress@DLSUFFIX@'`
`7`	`7`	`LANGUAGE 'c';`
`8`		`-NOTICE: ProcedureCreate: type'widget' is not yet defined`
	`8`	`+NOTICE: ProcedureCreate: type widget is not yet defined`
`9`	`9`	`CREATE FUNCTION widget_out(opaque)`
`10`	`10`	`RETURNS opaque`
`11`	`11`	`AS '@abs_builddir@/regress@DLSUFFIX@'`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

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

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitd062f0f

File tree

3 files changed

3 files changed

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

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

`‎src/test/regress/output/create_function_1.source`

0 commit comments