Hi Jiri Dmitry responded, it seems to be a bug that is in the fb engine since 2.0.1. It was reported early in 2007. I don't think it is the core team's highest priority. Since they expect you to write proper sql anyway, with inners first and then the outers.
I was thinking... Maybe we can reorder the joins in the final generated statement. I know it is not the cleanest solution out there, but it would mean a huge performance impact on my structure. It is my biggest, most used table that is actually causing this behavior :(. Another solution / temporary workaround could also be to remove the reason (FK) why it is causing this left outer join. But adapting the db design to do a bugfix is actually worse... Although... it solves my issue... Any thoughts are appreciated. Thanks Alexander -----Original Message----- From: Alexander Muylaert [mailto:amuylaert_gel...@hotmail.com] Sent: zondag 11 april 2010 0:38 To: 'For users and developers of the Firebird .NET providers' Subject: [Firebird-net-provider] EF query > natural scan Hi Jiri I just discover something weird in FB RC2. I posted it on tracker, but maybe you might be able to solve (workaround) it? Could you have a quick look at this? Maybe I'm just plain wrong. http://tracker.firebirdsql.org/browse/CORE-2963 Thanks Alexander ---------------------------------------------------------------------------- -- Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider ------------------------------------------------------------------------------ Download Intel® Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
