On Wed, 03 Sep 2014 10:31:46 +0400, "Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]" <firebird-support@yahoogroups.com> 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. Mark