Bug in SqlBase9.0.1

forum.gupta.bugreport (2005-2010)
John

Bug in SqlBase9.0.1

Post by John » 24 Mar 2006, 09:30

 Posted by:  John 

I execute the following statement :
' SELECT Name FROM SYSADM.GRANDFATHER
WHERE EXISTS( SELECT *
FROM SYSADM.FATHER
WHERE EXISTS( SELECT *
FROM SYSADM.CHILD
WHERE CHILD.LINK = FATHER.PRIMARY AND
CHILD.NAME = 'AAA')
AND FATHER.LINK = GRANDFATHER.PRIMARY )'
The result was 0 Rows.
I tried the same statement in SqlBase 7.5 and the Result was 23 rows!!.

Then I execute the statement in other way:
' SELECT GRANDFATHER.Name
FROM SYSADM.GRANDFATHER ,SYSADM.FATHER , SYSADM.CHILD
WHERE CHILD.LINK = FATHER.PRIMARY AND CHILD.NAME = 'AAA'AND FATHER.LINK
= GRANDFATHER.PRIMARY'
the Result was 23 rows in Both SqlBase7.5 and SQlBase 9!!
Any ideas?

Best Regards

Mike Vandine

Re: Bug in SqlBase9.0.1

Post by Mike Vandine » 28 Mar 2006, 01:19

 Posted by:  Mike Vandine 

Hi John,

We have reproduced this problem and created a defect for it:

86161 - A three level correlated subquery contains EXISTS clause gives
incorrect results.

Please watch the 'fixes' files in future releases to see when this defect is
fixed.

Best regards,

Mike

Return to “gupta.bugreport”

Who is online

Users browsing this forum: [Ccbot] and 0 guests