[Firebird-devel] Sourceforge services down

2012-10-23 Thread Mark Rotteveel
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 fast

Re: [Firebird-devel] subselects in head

2012-10-23 Thread Frank
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 qu

Re: [Firebird-devel] subselects in head

2012-10-23 Thread Kjell Rilbe
Den 2012-10-23 13:16 skrev Frank såhär: > On 23/10/12 11:21, Kjell Rilbe wrote: >> 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$FIE

Re: [Firebird-devel] subselects in head

2012-10-23 Thread Frank
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 faithfu

Re: [Firebird-devel] subselects in head

2012-10-23 Thread Frank
On 23/10/12 11:21, Kjell Rilbe wrote: > 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(sel

Re: [Firebird-devel] subselects in head

2012-10-23 Thread Dmitry Yemanov
23.10.2012 12:32, Frank wrote: > > the following statement > > 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

Re: [Firebird-devel] subselects in head

2012-10-23 Thread Kjell Rilbe
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 >

[Firebird-devel] subselects in head

2012-10-23 Thread Frank
Hi, the following statement 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 from RDB$RELATION_FIEL