wrong result set as a result of outer join with named result table

[Alexey Gaidukov]

create table i
(
   counter integer
)
//
create table d
(
   counter integer,
   doc varchar(10) UNICODE,
   not_ready boolean
)
//
create table docs
(
   id varchar(10)
)
//
insert into docs values ('d1')
//
insert into i values (1)
//
insert into d values (1,null,null)
//
CREATE DBPROC TTT.get AS
VAR
   sqlText varchar(100);
BEGIN
   TRY
       SET sqlText = 'DECLARE INV CURSOR FOR
        select counter from ttt.i FOR REUSE';
        EXECUTE sqlText;
   CATCH
       STOP($rc, $errmsg);
END;
//
call ttt.get
//
select v.counter,dd.not_ready,dd.doc
from inv v,ttt.d dd,ttt.docs d
where v.counter=dd.counter(+) and dd.doc=d.id(+)  and dd.not_ready=true





If change the select

select v.counter,dd.not_ready,dd.doc
from inv v,ttt.d dd,ttt.docs d
where v.counter=dd.counter(+) and dd.doc=d.id(+)  and dd.not_ready=true
and dd.not_ready is not null


then result will be correct


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]