diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2000-04-20 00:32:57 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2000-04-20 00:32:57 +0000 |
| commit | a95eec6792f94d623a16cc5276021fe1ad9fc48f (patch) | |
| tree | ea6f8ab617a4d81d8be4a5f1e6ca2e026aef2ad2 /src | |
| parent | 7c22d2e5f09ec325eb796ac2817e6362104e8218 (diff) | |
| download | postgresql-a95eec6792f94d623a16cc5276021fe1ad9fc48f.tar.gz postgresql-a95eec6792f94d623a16cc5276021fe1ad9fc48f.zip | |
Add a regress test case for SELECT count(*) FROM view, so that we'll
know if that case ever breaks again...
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/rules.out | 15 | ||||
| -rw-r--r-- | src/test/regress/sql/rules.sql | 3 |
2 files changed, 18 insertions, 0 deletions
diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out index ab332b49e68..edb066f116e 100644 --- a/src/test/regress/expected/rules.out +++ b/src/test/regress/expected/rules.out @@ -1143,6 +1143,21 @@ SELECT * FROM shoelace ORDER BY sl_name; sl8 | 21 | brown | 40 | inch | 101.6 (9 rows) +SELECT * FROM shoe ORDER BY shoename; + shoename | sh_avail | slcolor | slminlen | slminlen_cm | slmaxlen | slmaxlen_cm | slunit +------------+----------+------------+----------+-------------+----------+-------------+---------- + sh1 | 2 | black | 70 | 70 | 90 | 90 | cm + sh2 | 0 | black | 30 | 76.2 | 40 | 101.6 | inch + sh3 | 4 | brown | 50 | 50 | 65 | 65 | cm + sh4 | 3 | brown | 40 | 101.6 | 50 | 127 | inch +(4 rows) + +SELECT count(*) FROM shoe; + count +------- + 4 +(1 row) + -- -- Check that ruleutils are working -- diff --git a/src/test/regress/sql/rules.sql b/src/test/regress/sql/rules.sql index 7f44412561a..2b7aa33a8cf 100644 --- a/src/test/regress/sql/rules.sql +++ b/src/test/regress/sql/rules.sql @@ -682,6 +682,9 @@ DELETE FROM shoelace WHERE EXISTS SELECT * FROM shoelace ORDER BY sl_name; +SELECT * FROM shoe ORDER BY shoename; +SELECT count(*) FROM shoe; + -- -- Check that ruleutils are working |