W dniu 2016-06-23 13:39:12 użytkownik Dmitry Yemanov <[email protected]> napisał: > 23.06.2016 13:59, liviuslivius wrote: > > > > i have attached file to http://tracker.firebirdsql.org/browse/CORE-1117 > > I see that it fails way before the 64KB limit, with just the first union > part (simplified): > > SELECT * > FROM > UMOWA U > INNER JOIN WARUNKI W ON W.UMOWA_ID = U.UMOWA_ID AND W.DYR_ID = > U.DYR_ID AND W.UMOWA_ID_SEQ = U.UMOWA_ID_SEQ > LEFT JOIN RODZAJ_UMOWY RU ON RU.RODZ_UMOWY_ID = U.RODZ_UMOWY_ID AND > RU.TYP_UMOWY_ID = U.TYP_UMOWY_ID > LEFT JOIN RODZAJ_DZIAL RD ON RD.RODZ_UMOWY_ID = U.RODZ_UMOWY_ID AND > RD.TYP_UMOWY_ID = U.TYP_UMOWY_ID AND RD.RODZ_DZIAL_ID = W.RODZ_DZIAL_ID > WHERE > (W.RODZ_DZIAL_ID = 'MZ3') > -- skipped lots of conditions > OR (W.RODZ_DZIAL_ID = 'M33') > -- till this point it works > OR (W.RODZ_DZIAL_ID = 'M34') > -- this raises error > > Statement failed, SQLSTATE = 42000 > Dynamic SQL Error > -SQL error code = -104 > -Unexpected end of command - line 8, column 4094 > > i.e. it's not about the total query length (just 4.5 KB), but about > number of ORed elements in the WHERE clause. Some kind of parser > limitation, I suspect. > > > Dmitry > >
Do you mean that this ored limitation is sumarize of all unions? Because if i remove e.g first, last or any other union query work as expected regards, Karol Bieniaszewski ------------------------------------------------------------------------------ Attend Shape: An AT&T Tech Expo July 15-16. Meet us at AT&T Park in San Francisco, CA to explore cutting-edge tech and listen to tech luminaries present their vision of the future. This family event has something for everyone, including kids. Get more information and register today. http://sdm.link/attshape Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
