Re: [Firebird-devel] FB3.0 Bug in nested join

[Thomas B. <tho...@as...>]

Thanks alot, Dimitry, I didn't know about the new (SQL spec conforming)
restirction you mentioned in your prior post!

Thomas

> Sorry, I thought that your issue was caused by the i.RDB$RELATION_NAME = 
> rf.RDB$RELATION_NAME condition, but it's not. So there's only one error 
> and it's explained in my prior message. No bugs here, everything is as 
> designed. The query should be rewritten as:
> 
> select
>    rf.RDB$RELATION_NAME,
>    rf.RDB$FIELD_NAME,
>    s.RDB$INDEX_NAME
> from RDB$RELATION_FIELDS rf
> left join (
>    RDB$INDICES i
>    join RDB$INDEX_SEGMENTS s
>      on i.RDB$INDEX_NAME = s.RDB$INDEX_NAME
>    join RDB$RELATION_CONSTRAINTS rc
>      on rc.RDB$INDEX_NAME = s.RDB$INDEX_NAME
>        and rc.RDB$CONSTRAINT_TYPE = 'FOREIGN KEY'
>    ) on i.RDB$RELATION_NAME = rf.RDB$RELATION_NAME
>      and s.RDB$FIELD_NAME = rf.RDB$FIELD_NAME
> where
>    rf.RDB$FIELD_SOURCE starting with 'D_FK_'
> 
> 
> Dmitry
> 
> 
> ------------------------------------------------------------------------------
> Own the Future-Intel® Level Up Game Demo Contest 2013
> Rise to greatness in Intel's independent game demo contest.
> Compete for recognition, cash, and the chance to get your game 
> on Steam. $5K grand prize plus 10 genre and skill prizes. 
> Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d
> Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
> 

-- 
Mit freundlichen Grüßen,

Thomas Beckmann
Diplom-Informatiker

Wielandstraße 14c • 23558 Lübeck
Tel +49 (04 51) 399 04 - 525 • Fax +49 (04 51) 399 04 - 559
Mail tho...@as... <mailto:tho...@as...>

ASSFINET-Logo

*ASSFINET Dienstleistungs-GmbH*
Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn
in...@as... <mailto:in...@as...> • www.assfinet.de
<http://www.assfinet.de/>

Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann
Registergericht Koblenz HRB 23331

Diese E-Mail enthält vertrauliche Informationen. Wenn Sie nicht der
richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist
nicht gestattet.