diff options
| author | Ashutosh Bapat | 2011-06-15 04:16:47 +0000 |
|---|---|---|
| committer | Ashutosh Bapat | 2011-06-15 04:27:14 +0000 |
| commit | bcfa7b115f2a76e0146016dee36995df6eab89d0 (patch) | |
| tree | ddd5dc4e39b8ad305e96fd6c61883f9dd41fa18c /src/test | |
| parent | ca34131f203bfc21c57b928b0fc3fd6ccef0195c (diff) | |
Fix for bug 3286054. The aggregates like count() can return integral value 0,
which is equivalent to (Datum)NULL. We should not return NULL tuple when we
encounter integral value 0 as aggregation result in ExecRemoteQuery().
For aggregate count(), the initial collection value should be 0 just like the
initial transition value.
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/tsearch_1.out | 12 |
1 files changed, 8 insertions, 4 deletions
diff --git a/src/test/regress/expected/tsearch_1.out b/src/test/regress/expected/tsearch_1.out index 4d1f1b131a..94238cbf06 100644 --- a/src/test/regress/expected/tsearch_1.out +++ b/src/test/regress/expected/tsearch_1.out @@ -1045,26 +1045,30 @@ DETAIL: The feature is not currently supported SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty'); count ------- -(0 rows) + 0 +(1 row) INSERT INTO test_tsvector (t) VALUES ('345 qwerty'); SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty'); count ------- -(0 rows) + 0 +(1 row) UPDATE test_tsvector SET t = null WHERE t = '345 qwerty'; ERROR: Partition column can't be updated in current version SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty'); count ------- -(0 rows) + 0 +(1 row) INSERT INTO test_tsvector (t) VALUES ('345 qwerty'); SELECT count(*) FROM test_tsvector WHERE a @@ to_tsquery('345&qwerty'); count ------- -(0 rows) + 0 +(1 row) -- test finding items in GIN's pending list create table pendtest (ts tsvector); |