NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commit434ddfb

committed

Improve numeric_power() tests for large integer powers.

Two of the tests added by4dd5ce2 fail on buildfarm membercastoroides, though it's not clear why. Improve the tests to reportthe actual values produced, if they're not what was expected.Apply to v11 only for now, until it's clearer what's going on.

1 parent4851940 commit434ddfbCopy full SHA for 434ddfb

File tree

2 files changed

-6

lines changed

src/test/regress
- expected
  - numeric.out
- sql
  - numeric.sql

2 files changed

-6

lines changed

`‎src/test/regress/expected/numeric.out`

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -1668,10 +1668,10 @@ select 1.000000000123 ^ (-2147483648);`
`1668`	`1668`	`0.7678656556403084`
`1669`	`1669`	`(1 row)`
`1670`	`1670`
`1671`		`-select 0.9999999999 ^ 23300000000000 = 0 as rounds_to_zero;`
	`1671`	`+selectcoalesce(nullif(0.9999999999 ^ 23300000000000, 0), 0) as rounds_to_zero;`
`1672`	`1672`	`rounds_to_zero`
`1673`	`1673`	`----------------`
`1674`		`-t`
	`1674`	`+ 0`
`1675`	`1675`	`(1 row)`
`1676`	`1676`
`1677`	`1677`	`-- cases that used to error out`
`@@ -1687,10 +1687,10 @@ select 0.5678 ^ (-85);`
`1687`	`1687`	`782333637740774446257.7719390061997396`
`1688`	`1688`	`(1 row)`
`1689`	`1689`
`1690`		`-select 0.9999999999 ^ 70000000000000 = 0 as underflows;`
	`1690`	`+selectcoalesce(nullif(0.9999999999 ^ 70000000000000, 0), 0) as underflows;`
`1691`	`1691`	`underflows`
`1692`	`1692`	`------------`
`1693`		`-t`
	`1693`	`+ 0`
`1694`	`1694`	`(1 row)`
`1695`	`1695`
`1696`	`1696`	`-- negative base to integer powers`

`‎src/test/regress/sql/numeric.sql`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -907,12 +907,12 @@ select 3.789 ^ 35;`
`907`	`907`	`select1.2 ^345;`
`908`	`908`	`select0.12 ^ (-20);`
`909`	`909`	`select1.000000000123 ^ (-2147483648);`
`910`		`-select0.9999999999 ^23300000000000=0as rounds_to_zero;`
	`910`	`+selectcoalesce(nullif(0.9999999999 ^23300000000000,0),0)as rounds_to_zero;`
`911`	`911`
`912`	`912`	`-- cases that used to error out`
`913`	`913`	`select0.12 ^ (-25);`
`914`	`914`	`select0.5678 ^ (-85);`
`915`		`-select0.9999999999 ^70000000000000=0as underflows;`
	`915`	`+selectcoalesce(nullif(0.9999999999 ^70000000000000,0),0)as underflows;`
`916`	`916`
`917`	`917`	`-- negative base to integer powers`
`918`	`918`	`select (-1.0) ^2147483646;`

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!

Commit434ddfb

File tree

2 files changed

2 files changed

`‎src/test/regress/expected/numeric.out`

`‎src/test/regress/sql/numeric.sql`

0 commit comments