Commitca1d1b7

committed

Wups, stuck ORDER BY on wrong query while trying to eliminate random

ordering of GROUP BY output due to hash-based aggregation.

1 parent63c3840 commitca1d1b7Copy full SHA for ca1d1b7

File tree

-4

lines changed

-4

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -858,7 +858,7 @@ select * from rtest_view3;`
`858`	`858`
`859`	`859`	`delete from rtest_view3;`
`860`	`860`	`insert into rtest_view4 select * from rtest_vview4 where 3 > refcount;`
`861`		`-select * from rtest_view4;`
	`861`	`+select * from rtest_view4 order by a, b;`
`862`	`862`	`a \| b \| c`
`863`	`863`	`---+--------+---`
`864`	`864`	`2 \| item 2 \| 2`
`@@ -868,7 +868,7 @@ select * from rtest_view4;`
`868`	`868`
`869`	`869`	`delete from rtest_view4;`
`870`	`870`	`insert into rtest_view4 select * from rtest_vview5 where a > 2 and refcount = 0;`
`871`		`-select * from rtest_view4 order by a, b;`
	`871`	`+select * from rtest_view4;`
`872`	`872`	`a \| b \| c`
`873`	`873`	`---+--------+---`
`874`	`874`	`3 \| item 3 \| 0`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -467,11 +467,11 @@ select * from rtest_view3;`
`467`	`467`	`deletefrom rtest_view3;`
`468`	`468`
`469`	`469`	`insert into rtest_view4select*from rtest_vview4where3> refcount;`
`470`		`-select*from rtest_view4;`
	`470`	`+select*from rtest_view4order by a, b;`
`471`	`471`	`deletefrom rtest_view4;`
`472`	`472`
`473`	`473`	`insert into rtest_view4select*from rtest_vview5where a>2and refcount=0;`
`474`		`-select*from rtest_view4order by a, b;`
	`474`	`+select*from rtest_view4;`
`475`	`475`	`deletefrom rtest_view4;`
`476`	`476`	`--`
`477`	`477`	`-- Test for computations in views`

Comments

(0)