This is no longer a problem in 7.1. The bug here was the same one
introduced by the wrong version of Gunner's bytearray pooling patch
being applied. It was fixed in current sources by Peter commenting out
the bytearray pooling.
thanks,
--Barry
Bruce Momjian wrote:
>
> Anyone fixing this bug?
On Oracle 9.2 you get 0, 0, 0, and 2 rows.
--Barry
SQL> create table tab (col integer);
Table created.
SQL> select 1 from tab having 1=0;
no rows selected
SQL> select 1 from tab having 1=1;
no rows selected
SQL> insert into tab values (1);
1 row created.
SQL> insert into tab values (2);