COUNT(*) bug

[pateljm]

The following sequence of queries give surprising results:

CREATE TABLE Foo (a INT, b INT);
CREATE TABLE Bar (a INT, b INT);
INSERT INTO Foo SELECT i, i%2 FROM generate_series(0, 1) AS gs(i);
INSERT INTO Bar SELECT i, i%2 FROM generate_series(0, 1) AS gs(i);

SELECT COUNT(a) FROM (SELECT Foo.a FROM Foo, Bar WHERE Foo.a = Bar.b) AS A(a);
SELECT COUNT(*) FROM (SELECT Foo.a FROM Foo, Bar WHERE Foo.a = Bar.b) AS A(a);

The second SELECT query returns 0 instead of 2.

[hbdeshmukh]

I guess this is the same issue as this

[pateljm]

@hbdeshmukh Yup -- but need it here in this repo too.