Commit007f812

committed

Update alternate float8 output files to match current float8.sql.

1 parent738a9ca commit007f812Copy full SHA for 007f812

File tree

+38

-2

lines changed

+38

-2

lines changed

Lines changed: 19 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -149,7 +149,19 @@ SELECT '' AS five, f.f1, f.f1 % AS round_f1`
`149`	`149`	`\| 1.2345678901234e-200 \| 0`
`150`	`150`	`(5 rows)`
`151`	`151`
	`152`	`+SELECT sqrt(float8 '64') AS eight;`
	`153`	`+ eight`
	`154`	`+-------`
	`155`	`+ 8`
	`156`	`+(1 row)`
	`157`	`+`
`152`	`158`	`-- square root`
	`159`	`+SELECT \|/ float8 '64' AS eight;`
	`160`	`+ eight`
	`161`	`+-------`
	`162`	`+ 8`
	`163`	`+(1 row)`
	`164`	`+`
`153`	`165`	`SELECT '' AS three, f.f1, \|/f.f1 AS sqrt_f1`
`154`	`166`	`FROM FLOAT8_TBL f`
`155`	`167`	`WHERE f.f1 > '0.0';`
`@@ -172,6 +184,12 @@ SELECT '' AS three, f.f1, exp(ln(f.f1)) AS exp_ln_f1`
`172`	`184`	`(3 rows)`
`173`	`185`
`174`	`186`	`-- cube root`
	`187`	`+SELECT \|\|/ float8 '27' AS three;`
	`188`	`+ three`
	`189`	`+-------`
	`190`	`+ 3`
	`191`	`+(1 row)`
	`192`	`+`
`175`	`193`	`SELECT '' AS five, f.f1, \|\|/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;`
`176`	`194`	`five \| f1 \| cbrt_f1`
`177`	`195`	`------+----------------------+-----------------------`
`@@ -217,7 +235,7 @@ SELECT '' AS five, FLOAT8_TBL.*;`
`217`	`235`	`\| -1.2345678901234e-200`
`218`	`236`	`(5 rows)`
`219`	`237`
`220`		`--- test for over andunder flow`
	`238`	`+-- test for over- andunderflow`
`221`	`239`	`INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');`
`222`	`240`	`ERROR: Input '10e400' is out of range for float8`
`223`	`241`	`INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');`

Lines changed: 19 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -149,7 +149,19 @@ SELECT '' AS five, f.f1, f.f1 % AS round_f1`
`149`	`149`	`\| 1.2345678901234e-200 \| 0`
`150`	`150`	`(5 rows)`
`151`	`151`
	`152`	`+SELECT sqrt(float8 '64') AS eight;`
	`153`	`+ eight`
	`154`	`+-------`
	`155`	`+ 8`
	`156`	`+(1 row)`
	`157`	`+`
`152`	`158`	`-- square root`
	`159`	`+SELECT \|/ float8 '64' AS eight;`
	`160`	`+ eight`
	`161`	`+-------`
	`162`	`+ 8`
	`163`	`+(1 row)`
	`164`	`+`
`153`	`165`	`SELECT '' AS three, f.f1, \|/f.f1 AS sqrt_f1`
`154`	`166`	`FROM FLOAT8_TBL f`
`155`	`167`	`WHERE f.f1 > '0.0';`
`@@ -172,6 +184,12 @@ SELECT '' AS three, f.f1, exp(ln(f.f1)) AS exp_ln_f1`
`172`	`184`	`(3 rows)`
`173`	`185`
`174`	`186`	`-- cube root`
	`187`	`+SELECT \|\|/ float8 '27' AS three;`
	`188`	`+ three`
	`189`	`+-------`
	`190`	`+ 3`
	`191`	`+(1 row)`
	`192`	`+`
`175`	`193`	`SELECT '' AS five, f.f1, \|\|/f.f1 AS cbrt_f1 FROM FLOAT8_TBL f;`
`176`	`194`	`five \| f1 \| cbrt_f1`
`177`	`195`	`------+----------------------+----------------------`
`@@ -217,7 +235,7 @@ SELECT '' AS five, FLOAT8_TBL.*;`
`217`	`235`	`\| -1.2345678901234e-200`
`218`	`236`	`(5 rows)`
`219`	`237`
`220`		`--- test for over andunder flow`
	`238`	`+-- test for over- andunderflow`
`221`	`239`	`INSERT INTO FLOAT8_TBL(f1) VALUES ('10e400');`
`222`	`240`	`ERROR: Input '10e400' is out of range for float8`
`223`	`241`	`INSERT INTO FLOAT8_TBL(f1) VALUES ('-10e400');`

Comments

(0)