diff options
| author | Joe Conway | 2007-11-10 05:00:41 +0000 |
|---|---|---|
| committer | Joe Conway | 2007-11-10 05:00:41 +0000 |
| commit | 01496439e939f4528d46d1946950a13daa39878b (patch) | |
| tree | a909fc788d793129d5b87bae973d206c511776ad /contrib/tablefunc/sql | |
| parent | f19c8577eb565eeebd8e7211d2fc2e858be76d67 (diff) | |
Have crosstab variants treat NULL rowid as a category in its own right,
per suggestion from Tom Lane. This fixes crash-bug reported by Stefan
Schwarzer.
Diffstat (limited to 'contrib/tablefunc/sql')
| -rw-r--r-- | contrib/tablefunc/sql/tablefunc.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/contrib/tablefunc/sql/tablefunc.sql b/contrib/tablefunc/sql/tablefunc.sql index c6054c8efc9..815ef3e86be 100644 --- a/contrib/tablefunc/sql/tablefunc.sql +++ b/contrib/tablefunc/sql/tablefunc.sql @@ -61,6 +61,11 @@ insert into cth values(DEFAULT,'test2','02 March 2003','temperature','53'); insert into cth values(DEFAULT,'test2','02 March 2003','test_result','FAIL'); insert into cth values(DEFAULT,'test2','02 March 2003','test_startdate','01 March 2003'); insert into cth values(DEFAULT,'test2','02 March 2003','volts','3.1234'); +-- next group tests for NULL rowids +insert into cth values(DEFAULT,NULL,'25 October 2007','temperature','57'); +insert into cth values(DEFAULT,NULL,'25 October 2007','test_result','PASS'); +insert into cth values(DEFAULT,NULL,'25 October 2007','test_startdate','24 October 2007'); +insert into cth values(DEFAULT,NULL,'25 October 2007','volts','1.41234'); -- return attributes as plain text SELECT * FROM crosstab( |