Commita95eec6

committed

Add a regress test case for SELECT count(*) FROM view, so that we'll

know if that case ever breaks again...

1 parent7c22d2e commita95eec6Copy full SHA for a95eec6

File tree

+18

-0

lines changed

+18

-0

lines changed

Lines changed: 15 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1143,6 +1143,21 @@ SELECT * FROM shoelace ORDER BY sl_name;`
`1143`	`1143`	`sl8 \| 21 \| brown \| 40 \| inch \| 101.6`
`1144`	`1144`	`(9 rows)`
`1145`	`1145`
	`1146`	`+SELECT * FROM shoe ORDER BY shoename;`
	`1147`	`+ shoename \| sh_avail \| slcolor \| slminlen \| slminlen_cm \| slmaxlen \| slmaxlen_cm \| slunit`
	`1148`	`+------------+----------+------------+----------+-------------+----------+-------------+----------`
	`1149`	`+ sh1 \| 2 \| black \| 70 \| 70 \| 90 \| 90 \| cm`
	`1150`	`+ sh2 \| 0 \| black \| 30 \| 76.2 \| 40 \| 101.6 \| inch`
	`1151`	`+ sh3 \| 4 \| brown \| 50 \| 50 \| 65 \| 65 \| cm`
	`1152`	`+ sh4 \| 3 \| brown \| 40 \| 101.6 \| 50 \| 127 \| inch`
	`1153`	`+(4 rows)`
	`1154`	`+`
	`1155`	`+SELECT count(*) FROM shoe;`
	`1156`	`+ count`
	`1157`	`+-------`
	`1158`	`+ 4`
	`1159`	`+(1 row)`
	`1160`	`+`
`1146`	`1161`	`--`
`1147`	`1162`	`-- Check that ruleutils are working`
`1148`	`1163`	`--`

Lines changed: 3 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -682,6 +682,9 @@ DELETE FROM shoelace WHERE EXISTS`
`682`	`682`
`683`	`683`	`SELECT*FROM shoelaceORDER BY sl_name;`
`684`	`684`
	`685`	`+SELECT*FROM shoeORDER BY shoename;`
	`686`	`+SELECTcount(*)FROM shoe;`
	`687`	`+`
`685`	`688`
`686`	`689`	`--`
`687`	`690`	`-- Check that ruleutils are working`

Comments

(0)