Commitb402503

committed

Adjust data types in some of the UNION tests to avoid potentially

platform-dependent results, as per example from Larry Rosenman.

1 parenteeaf5f0 commitb402503Copy full SHA for b402503

File tree

-7

lines changed

-7

lines changed

Lines changed: 4 additions & 4 deletions

Original file line number	Diff line number	Diff line change
`@@ -74,7 +74,7 @@ SELECT 1 AS two UNION SELECT 2.2;`
`74`	`74`	`2.2`
`75`	`75`	`(2 rows)`
`76`	`76`
`77`		`-SELECT 1 AS one UNION SELECT 1.0;`
	`77`	`+SELECT 1 AS one UNION SELECT 1.0::float8;`
`78`	`78`	`one`
`79`	`79`	`-----`
`80`	`80`	`1`
`@@ -87,10 +87,10 @@ SELECT 1.1 AS two UNION ALL SELECT 2;`
`87`	`87`	`2`
`88`	`88`	`(2 rows)`
`89`	`89`
`90`		`-SELECT 1.0 AS two UNION ALL SELECT 1;`
	`90`	`+SELECT 1.0::float8 AS two UNION ALL SELECT 1;`
`91`	`91`	`two`
`92`	`92`	`-----`
`93`		`-1.0`
	`93`	`+ 1`
`94`	`94`	`1`
`95`	`95`	`(2 rows)`
`96`	`96`
`@@ -102,7 +102,7 @@ SELECT 1.1 AS three UNION SELECT 2 UNION SELECT 3;`
`102`	`102`	`3`
`103`	`103`	`(3 rows)`
`104`	`104`
`105`		`-SELECT 1.1 AS two UNION SELECT 2 UNION SELECT 2.0;`
	`105`	`+SELECT 1.1::float8 AS two UNION SELECT 2 UNION SELECT 2.0::float8;`
`106`	`106`	`two`
`107`	`107`	`-----`
`108`	`108`	`1.1`

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -26,15 +26,15 @@ SELECT 1.1 AS two UNION SELECT 2;`
`26`	`26`
`27`	`27`	`SELECT1AS twoUNIONSELECT2.2;`
`28`	`28`
`29`		`-SELECT1AS oneUNIONSELECT1.0;`
	`29`	`+SELECT1AS oneUNIONSELECT1.0::float8;`
`30`	`30`
`31`	`31`	`SELECT1.1AS twoUNION ALLSELECT2;`
`32`	`32`
`33`		`-SELECT1.0AS twoUNION ALLSELECT1;`
	`33`	`+SELECT1.0::float8AS twoUNION ALLSELECT1;`
`34`	`34`
`35`	`35`	`SELECT1.1AS threeUNIONSELECT2UNIONSELECT3;`
`36`	`36`
`37`		`-SELECT1.1AS twoUNIONSELECT2UNIONSELECT2.0;`
	`37`	`+SELECT1.1::float8AS twoUNIONSELECT2UNIONSELECT2.0::float8;`
`38`	`38`
`39`	`39`	`SELECT1.1AS threeUNIONSELECT2UNION ALLSELECT2;`
`40`	`40`

Comments

(0)