Commit2f806e5

committed

Tighten up a couple of regression test cases that can have platform-dependent

results due to underspecified ordering. Per report from buildfarm memberpika.

1 parent95b07bc commit2f806e5Copy full SHA for 2f806e5

File tree

-7

lines changed

-7

lines changed

Lines changed: 6 additions & 5 deletions

Original file line number	Diff line number	Diff line change
`@@ -233,26 +233,27 @@ SELECT cume_dist() OVER (PARTITION BY four ORDER BY ten), ten, four FROM tenk1 W`
`233`	`233`	`1 \| 3 \| 3`
`234`	`234`	`(10 rows)`
`235`	`235`
`236`		`-SELECT ntile(3) OVER (ORDER BY ten), ten, four FROM tenk1 WHERE unique2 < 10;`
	`236`	`+SELECT ntile(3) OVER (ORDER BY ten, four), ten, four FROM tenk1 WHERE unique2 < 10;`
`237`	`237`	`ntile \| ten \| four`
`238`	`238`	`-------+-----+------`
`239`	`239`	`1 \| 0 \| 0`
`240`		`- 1 \| 0 \| 2`
`241`	`240`	`1 \| 0 \| 0`
	`241`	`+ 1 \| 0 \| 2`
`242`	`242`	`1 \| 1 \| 1`
`243`		`- 2 \| 1 \| 3`
`244`	`243`	`2 \| 1 \| 1`
	`244`	`+ 2 \| 1 \| 3`
`245`	`245`	`2 \| 3 \| 3`
`246`	`246`	`3 \| 4 \| 0`
`247`	`247`	`3 \| 7 \| 1`
`248`	`248`	`3 \| 9 \| 1`
`249`	`249`	`(10 rows)`
`250`	`250`
`251`		`-SELECT ntile(NULL) OVER (ORDER BY ten), ten, four FROM tenk1 LIMIT1;`
	`251`	`+SELECT ntile(NULL) OVER (ORDER BY ten, four), ten, four FROM tenk1 LIMIT2;`
`252`	`252`	`ntile \| ten \| four`
`253`	`253`	`-------+-----+------`
`254`	`254`	`\| 0 \| 0`
`255`		`-(1 row)`
	`255`	`+ \| 0 \| 0`
	`256`	`+(2 rows)`
`256`	`257`
`257`	`258`	`SELECT lag(ten) OVER (PARTITION BY four ORDER BY ten), ten, four FROM tenk1 WHERE unique2 < 10;`
`258`	`259`	`lag \| ten \| four`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -54,9 +54,9 @@ SELECT percent_rank() OVER (PARTITION BY four ORDER BY ten), ten, four FROM tenk`
`54`	`54`
`55`	`55`	`SELECT cume_dist() OVER (PARTITION BY fourORDER BY ten), ten, fourFROM tenk1WHERE unique2<10;`
`56`	`56`
`57`		`-SELECT ntile(3) OVER (ORDER BY ten), ten, fourFROM tenk1WHERE unique2<10;`
	`57`	`+SELECT ntile(3) OVER (ORDER BY ten, four), ten, fourFROM tenk1WHERE unique2<10;`
`58`	`58`
`59`		`-SELECT ntile(NULL) OVER (ORDER BY ten), ten, fourFROM tenk1LIMIT1;`
	`59`	`+SELECT ntile(NULL) OVER (ORDER BY ten, four), ten, fourFROM tenk1LIMIT2;`
`60`	`60`
`61`	`61`	`SELECT lag(ten) OVER (PARTITION BY fourORDER BY ten), ten, fourFROM tenk1WHERE unique2<10;`
`62`	`62`

Comments

(0)