Den 2012-10-23 10:32 skrev Frank såhär:
select R1.RDB$RELATION_NAME
from RDB$RELATION_FIELDS F1
join RDB$RELATIONS R1 on F1.RDB$RELATION_NAME = R1.RDB$RELATION_NAME
where F1.RDB$FIELD_NAME ='EMP_NO' and
(not exists(select R2.RDB$RELATION_NAME
On 23/10/12 11:24, Dmitry Yemanov wrote:
It smells like a bug caused by the new restriction ;-)
I will investigate that, thanks.
thank you
Frank
--
Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful
Am 23.10.2012 13:37, schrieb Kjell Rilbe:
But your query still seems strange... Just trying to be helpful, so I
hope I'm not being a pain... :-)
...
OK, but then why is R2 even
present in the subselect?
To demonstrate an error in joins in subselects in FB3.0
You can simplify your query
Various services of SourceForge (including CVS and Subversion) are down:
https://sourceforge.net/blog/various-sourceforge-services-down/
--
Mark Rotteveel
--
Everyone hates slow websites. So do we.
Make your web apps