Commit2c30f96

committed

Tweak new regression test case for more portability.

Ensure that same index gets selected on 32-bit and 64-bit machines.Per buildfarm results.

1 parent6d295b6 commit2c30f96Copy full SHA for 2c30f96

File tree

-7

lines changed

-7

lines changed

Lines changed: 5 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -1266,19 +1266,19 @@ ORDER BY thousand, tenthous;`
`1266`	`1266`	`(7 rows)`
`1267`	`1267`
`1268`	`1268`	`explain (costs off)`
`1269`		`-SELECT thousand, tenthous FROM tenk1`
	`1269`	`+SELECT thousand, tenthous, thousand+tenthous AS x FROM tenk1`
`1270`	`1270`	`UNION ALL`
`1271`		`-SELECT 42, 42 FROM tenk1`
	`1271`	`+SELECT 42, 42, hundred FROM tenk1`
`1272`	`1272`	`ORDER BY thousand, tenthous;`
`1273`		`-QUERY PLAN`
`1274`		`------------------------------------------------------------------------`
	`1273`	`+ QUERY PLAN`
	`1274`	`+-----------------------------------------------------------------`
`1275`	`1275`	`Result`
`1276`	`1276`	`-> Merge Append`
`1277`	`1277`	`Sort Key: public.tenk1.thousand, public.tenk1.tenthous`
`1278`	`1278`	`-> Index Only Scan using tenk1_thous_tenthous on tenk1`
`1279`	`1279`	`-> Sort`
`1280`	`1280`	`Sort Key: (42), (42)`
`1281`		`- -> Index Only Scan usingtenk1_thous_tenthous on tenk1`
	`1281`	`+ -> Index Only Scan usingtenk1_hundred on tenk1`
`1282`	`1282`	`(7 rows)`
`1283`	`1283`
`1284`	`1284`	`explain (costs off)`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -423,9 +423,9 @@ SELECT thousand, thousand FROM tenk1`
`423`	`423`	`ORDER BY thousand, tenthous;`
`424`	`424`
`425`	`425`	`explain (costs off)`
`426`		`-SELECT thousand, tenthousFROM tenk1`
	`426`	`+SELECT thousand, tenthous, thousand+tenthousAS xFROM tenk1`
`427`	`427`	`UNION ALL`
`428`		`-SELECT42,42FROM tenk1`
	`428`	`+SELECT42,42, hundredFROM tenk1`
`429`	`429`	`ORDER BY thousand, tenthous;`
`430`	`430`
`431`	`431`	`explain (costs off)`

Comments

(0)