Commited7f780

committed

Fix ordering regression problem on freebsd/alpha by adding ORDER BY.

1 parentf486f92 commited7f780Copy full SHA for ed7f780

File tree

-2

lines changed

-2

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -1002,7 +1002,7 @@ SELECT * FROM shoelace ORDER BY sl_name;`
`1002`	`1002`	`sl8 \| 1 \| brown \| 40 \| inch \| 101.6`
`1003`	`1003`	`(8 rows)`
`1004`	`1004`
`1005`		`-SELECT * FROM shoe_ready WHERE total_avail >= 2;`
	`1005`	`+SELECT * FROM shoe_ready WHERE total_avail >= 2 ORDER BY 1;`
`1006`	`1006`	`shoename \| sh_avail \| sl_name \| sl_avail \| total_avail`
`1007`	`1007`	`------------+----------+------------+----------+-------------`
`1008`	`1008`	`sh1 \| 2 \| sl1 \| 5 \| 2`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -585,7 +585,7 @@ INSERT INTO shoelace_data VALUES ('sl8', 1, 'brown', 40 , 'inch');`
`585`	`585`
`586`	`586`	`-- SELECTs in doc`
`587`	`587`	`SELECT*FROM shoelaceORDER BY sl_name;`
`588`		`-SELECT*FROM shoe_readyWHERE total_avail>=2;`
	`588`	`+SELECT*FROM shoe_readyWHERE total_avail>=2ORDER BY1;`
`589`	`589`
`590`	`590`	`CREATETABLEshoelace_log (`
`591`	`591`	`sl_namechar(10),-- shoelace changed`

Comments

(0)