--- In firebird-support@yahoogroups.com, "emb_blaster" <EMB_Blaster@...> wrote:

>
>
>
> --- In firebird-support@yahoogroups.com, "emb_blaster" <EMB_Blaster@> wrote:
> >
> >
> >
> > --- In firebird-support@yahoogroups.com, "Ismael L. Donis García" <ismael@> wrote:
> > >
> > > select * from
> > > t1_proc T1
> > > LEFT JOIN
> > > (
> > > SELECT 10 AS VALX FROM rdb$database
> > > ) T2
> > > ON T1.VAL=T2.VALX
> > > UNION
> > > select * from
> > > t1_proc T1
> > > LEFT JOIN
> > > (
> > > SELECT 20 AS VALX FROM rdb$database
> > > ) T2
> > > ON T1.VAL=T2.VALX
> > >
> > > Regards
> > > =========
> > > || ISMAEL ||
> > > =========
> > > ----- Original Message -----
> > > From: emb_blaster
> > > To: firebird-support@yahoogroups.com
> > > Sent: Friday, February 25, 2011 3:32 PM
> > > Subject: [firebird-support] Possible BUG in Left join on Stored Procedures...
> > >
> >
> > Hi Ismael,
> >
> > I am not sure why you write that as you didn't provide any explanation. This only expand the bug to a union of selects. Maybe my English was not clear enough (blame my English teacher!!! \o/ ). If is that, I am sorry.
> > Anyway, I just found that you don't need to create a procedure to reproduce. See query below:
> > select * from
> > (SELECT 1 as val from rdb$database
> > UNION SELECT 2 FROM rdb$database
> > UNION SELECT 3 FROM rdb$database
> > UNION SELECT 4 FROM rdb$database) T1
> > LEFT JOIN
> > (
> > SELECT 10 AS VAL FROM rdb$database
> >
> > ) T2
> > ON T1.VAL=T2.VAl
> >
> > Expected result set:
> > VAL VAL1
> > 1 NULL
> > 2 NULL
> > 3 NULL
> > 4 NULL
> >
> >
> > Result Set found:
> >
> > VAL VAL1
> > 1 10
> > 2 10
> > 3 10
> > 4 10
> >
> > Am I working too much?
> >
>
> ohh Hi again...
>
> Just found it is a already knew bug, but it is marked as fixed only to 2.5.0 and 3.0 Alpha. But as said before, I'm using a ODS 11.0 and 2.1.3 server. It is known that this bug affects 2.1.X? Should I do something about?
> http://tracker.firebirdsql.org/browse/CORE-3090

this is known bug
but is not plan to backport fix for 2.1.x version
as Dimitry Yemanow say me :/

look here
http://tech.dir.groups.yahoo.com/group/firebird-support/message/112273
and follow link to core

Karol Bieniaszewski

>