Commitf851c6b

committed

Add another ORDER BY to rules test; got tired of it 'failing'

every time I tweak the optimizer...

1 parent970ef45 commitf851c6bCopy full SHA for f851c6b

File tree

-4

lines changed

-4

lines changed

Lines changed: 3 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -1018,13 +1018,13 @@ sl7 \| 6\|brown \| 60\|cm \| 60`
`1018`	`1018`	`sl8 \| 21\|brown \| 40\|inch \| 101.6`
`1019`	`1019`	`(8 rows)`
`1020`	`1020`
`1021`		`-QUERY: SELECT * FROM shoelace_log;`
	`1021`	`+QUERY: SELECT * FROM shoelace_log ORDER BY sl_name;`
`1022`	`1022`	`sl_name \|sl_avail\|log_who \|log_when`
`1023`	`1023`	`----------+--------+--------+--------`
`1024`		`-sl7 \| 6\|Al Bundy\|epoch`
	`1024`	`+sl3 \|10\|Al Bundy\|epoch`
`1025`	`1025`	`sl6 \| 20\|Al Bundy\|epoch`
	`1026`	`+sl7 \| 6\|Al Bundy\|epoch`
`1026`	`1027`	`sl8 \| 21\|Al Bundy\|epoch`
`1027`		`-sl3 \| 10\|Al Bundy\|epoch`
`1028`	`1028`	`(4 rows)`
`1029`	`1029`
`1030`	`1030`	`QUERY: CREATE VIEW shoelace_obsolete AS`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -661,7 +661,7 @@ insert into shoelace_ok select * from shoelace_arrive;`
`661`	`661`
`662`	`662`	`SELECT*FROM shoelaceORDER BY sl_name;`
`663`	`663`
`664`		`-SELECT*FROM shoelace_log;`
	`664`	`+SELECT*FROM shoelace_logORDER BY sl_name;`
`665`	`665`
`666`	`666`	`CREATEVIEWshoelace_obsoleteAS`
`667`	`667`	`SELECT*FROM shoelaceWHERE NOT EXISTS`

Comments

(0)