I'm sorry for asking this question here: In firebird-support, I got 2 answers of people who where obviously as little sure than I whether the described behaviour is a bug or SQL standard compliant, so:
Please consider the following example: with recursive CTE_CNT as (select 1 as I from RDB$DATABASE union all select I + 1 from CTE_CNT where I < 20) select i.I, j.I, k.I from CTE_CNT i left join CTE_CNT j on i.I = j.I and j.I<10 join CTE_CNT k on j.I = k.I I would expect this to behave as select i.I, j.I, k.I from CTE_CNT i left join (CTE_CNT j join CTE_CNT k on j.I = k.I) on i.I = j.I and j.I<10 But it does not: It behaves like select i.I, j.I, k.I from CTE_CNT i join CTE_CNT j on i.I = j.I and j.I<10 join CTE_CNT k on j.I = k.I Can someone explain this to me? Is this as intended or is this a bug? Thanks alot! Thomas -- Mit freundlichen Grüßen, Thomas Beckmann Diplom-Informatiker Wielandstraße 14c • 23558 Lübeck Tel +49 (22 25) 91 34 - 545 • Fax +49 (22 25) 91 34 - 604 Mail thomas.beckm...@assfinet.de <mailto:thomas.beckm...@assfinet.de> ASSFINET-Logo *ASSFINET Dienstleistungs-GmbH* Max-Planck-Straße 14 • 53501 Grafschaft bei Bonn i...@assfinet.de <mailto:i...@assfinet.de> • www.assfinet.de <http://www.assfinet.de/> Geschäftsführer: Dipl. Wirtschaftsinformatiker Marc Rindermann Registergericht KoblenI 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. __._,_.___ Reply via web post <https://groups.yahoo.com/neo/groups/firebird-support/conversations/messages/124148;_ylc=X3oDMTJyM2x2bzdiBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzEyNDE0OARzZWMDZnRyBHNsawNycGx5BHN0aW1lAzEzOTUzMzgzMjE-?act=reply&messageNum=124148> Reply to sender <mailto:thomas.beckm...@assfinet.de?subject=Re%3A%20Bug%20with%20JOIN%3F> Reply to group <mailto:firebird-supp...@yahoogroups.com?subject=Re%3A%20Bug%20with%20JOIN%3F> Start a New Topic <https://groups.yahoo.com/neo/groups/firebird-support/conversations/newtopic;_ylc=X3oDMTJlZzdrZzlyBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA250cGMEc3RpbWUDMTM5NTMzODMyMQ--> Messages in this topic <https://groups.yahoo.com/neo/groups/firebird-support/conversations/topics/124148;_ylc=X3oDMTM4dWUyaDh2BF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BG1zZ0lkAzEyNDE0OARzZWMDZnRyBHNsawN2dHBjBHN0aW1lAzEzOTUzMzgzMjEEdHBjSWQDMTI0MTQ4> (1) ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit Your Group <https://groups.yahoo.com/neo/groups/firebird-support/info;_ylc=X3oDMTJlbWlkZmwwBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZnaHAEc3RpbWUDMTM5NTMzODMyMQ--> * New Members <https://groups.yahoo.com/neo/groups/firebird-support/members/all;_ylc=X3oDMTJmMTlsbHFuBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwN2dGwEc2xrA3ZtYnJzBHN0aW1lAzEzOTUzMzgzMjE-> 2 Yahoo! Groups <https://groups.yahoo.com/neo;_ylc=X3oDMTJkODByc29zBF9TAzk3MzU5NzE0BGdycElkAzI0NDI0MDYEZ3Jwc3BJZAMxNzA1MTE1Mzg2BHNlYwNmdHIEc2xrA2dmcARzdGltZQMxMzk1MzM4MzIx> • Privacy <https://info.yahoo.com/privacy/us/yahoo/groups/details.html> • Unsubscribe <mailto:firebird-support-unsubscr...@yahoogroups.com?subject=Unsubscribe> • Terms of Use <https://info.yahoo.com/legal/us/yahoo/utos/terms/> . __,_._,___ ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/13534_NeoTech Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
