Commit997439f

committed

Add ORDER BY to a couple of test queries whose output ordering is not

as predictable as it used to be, due to recycling of free space withnew VACUUM.

1 parent1e3eacc commit997439fCopy full SHA for 997439f

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -55,13 +55,13 @@ DELETE FROM onek;`
`55`	`55`
`56`	`56`	`COPY onek FROM '@abs_builddir@/results/onek.data';`
`57`	`57`
`58`		`-SELECT unique1 FROM onek WHERE unique1 < 2;`
	`58`	`+SELECT unique1 FROM onek WHERE unique1 < 2 ORDER BY unique1;`
`59`	`59`
`60`	`60`	`DELETE FROM onek2;`
`61`	`61`
`62`	`62`	`COPY onek2 FROM '@abs_builddir@/results/onek.data';`
`63`	`63`
`64`		`-SELECT unique1 FROM onek2 WHERE unique1 < 2;`
	`64`	`+SELECT unique1 FROM onek2 WHERE unique1 < 2 ORDER BY unique1;`
`65`	`65`
`66`	`66`	`COPY BINARY stud_emp TO '@abs_builddir@/results/stud_emp.data';`
`67`	`67`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -42,7 +42,7 @@ DROP TABLE tmp;`
`42`	`42`	`COPY onek TO '@abs_builddir@/results/onek.data';`
`43`	`43`	`DELETE FROM onek;`
`44`	`44`	`COPY onek FROM '@abs_builddir@/results/onek.data';`
`45`		`-SELECT unique1 FROM onek WHERE unique1 < 2;`
	`45`	`+SELECT unique1 FROM onek WHERE unique1 < 2 ORDER BY unique1;`
`46`	`46`	`unique1`
`47`	`47`	`---------`
`48`	`48`	`0`
`@@ -51,7 +51,7 @@ SELECT unique1 FROM onek WHERE unique1 < 2;`
`51`	`51`
`52`	`52`	`DELETE FROM onek2;`
`53`	`53`	`COPY onek2 FROM '@abs_builddir@/results/onek.data';`
`54`		`-SELECT unique1 FROM onek2 WHERE unique1 < 2;`
	`54`	`+SELECT unique1 FROM onek2 WHERE unique1 < 2 ORDER BY unique1;`
`55`	`55`	`unique1`
`56`	`56`	`---------`
`57`	`57`	`0`

Comments

(0)