Subject Re: [firebird-support] Re: Query stop working after upgrade from 2.1.5 to 2.1.6
Author Mark Rotteveel
On Wed, 03 Sep 2014 10:31:46 +0400, "Dmitry Yemanov
dimitr@... [firebird-support]"
<> wrote:
> 03.09.2014 09:44, Macma wrote:
>> I found that after upgrade from FireBird 2.1.5 Update 1 to 2.1.6 my
>> query stop working with error "Dynamic SQL Error SQL error code = -104
>> Invalid expression in the select list (not contained in either an
>> aggregate function or the GROUP BY clause)". The same error occur on
>> 2.5.3
> Interesting. The stricter checks were not really intended, it looks like

> an indirect result of some bugfix. I hope this issue doesn't reject
> formally correct queries.

At first glance I would have expected this query to have failed in all
previous Firebird versions as well (I believe most SQL dialects, and afaik
also in Firebird) using the alias defined in the select in any other clause
on the same level doesn't work. The fact that it worked in 2.1.5 might be
the anomaly, not that it doesn't work in 2.1.6.