【Bug?】Wrong result when using Subquery in SELECT clause

[hiroyuki0415]

SELECT r.crf3c_rank0_3id,
       r.crf3c_integer_column,
       r.owningbusinessunit,
       (SELECT count(*)
        FROM   crf3c_rank0_3 AS sub
        WHERE  sub.crf3c_integer_column <= r.crf3c_integer_column) AS cnt
FROM   crf3c_rank0_3 AS r;

The result of this SQL is below. this result is correct:

	crf3c_rank0_3id	crf3c_integer_column	owningbusinessunit	cnt
	2f0384fb-5b14-ee11-9cbe-002248627e12	2	866c34a9-2021-ec11-b6e6-002248622ce3	2
	63aecf0d-5c14-ee11-9cbe-002248627e12	5	866c34a9-2021-ec11-b6e6-002248622ce3	5
	13a93ef8-5b14-ee11-9cbe-002248627ef1	1	866c34a9-2021-ec11-b6e6-002248622ce3	1
	b51e0406-5c14-ee11-9cbe-002248627ef1	3	866c34a9-2021-ec11-b6e6-002248622ce3	3
	08a15f0d-5c14-ee11-9cbe-002248627ef1	4	866c34a9-2021-ec11-b6e6-002248622ce3	4

But when I add one condition to the subquery, it returns wrong result:

SELECT r.crf3c_rank0_3id,
       r.crf3c_integer_column,
       r.owningbusinessunit,
       (SELECT count(*)
        FROM   crf3c_rank0_3 AS sub
        WHERE  sub.owningbusinessunit = r.owningbusinessunit --add other condition
               AND sub.crf3c_integer_column <= r.crf3c_integer_column) AS cnt
FROM   crf3c_rank0_3 AS r;

wrong result:

	crf3c_rank0_3id	crf3c_integer_column	owningbusinessunit	cnt
	2f0384fb-5b14-ee11-9cbe-002248627e12	2	866c34a9-2021-ec11-b6e6-002248622ce3	2
	63aecf0d-5c14-ee11-9cbe-002248627e12	5	866c34a9-2021-ec11-b6e6-002248622ce3	2
	13a93ef8-5b14-ee11-9cbe-002248627ef1	1	866c34a9-2021-ec11-b6e6-002248622ce3	2
	b51e0406-5c14-ee11-9cbe-002248627ef1	3	866c34a9-2021-ec11-b6e6-002248622ce3	2
	08a15f0d-5c14-ee11-9cbe-002248627ef1	4	866c34a9-2021-ec11-b6e6-002248622ce3	2

Thanks in advance for your support.

[MarkMpn]

Thanks, yes this appears to be a bug which is triggered when you combine an = correlated condition in the subquery with another condition. I've opened issue #316 to track this.