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 > from RDB$RELATION_FIELDS F2 > join RDB$RELATIONS R2 on F2.RDB$RELATION_NAME=R1.RDB$RELATION_NAME > where F2.RDB$FIELD_NAME ='PHONE_EXT')); > > that was valid in FB 2.5 leads to > > Statement failed, SQLSTATE = 42S22 > Dynamic SQL Error > -SQL error code = -206 > -Column unknown > -R1.RDB$RELATION_NAME > -At line 8, column 32 > > in head. > > > I'm not sure whether this is a bug or a new restriction according to > some obscure standard.
It smells like a bug caused by the new restriction ;-) I will investigate that, thanks. Dmitry ------------------------------------------------------------------------------ Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
