Group by fails if subselect-column is involved
----------------------------------------------
Key: CORE-4084
URL: http://tracker.firebirdsql.org/browse/CORE-4084
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 1
Environment: W7/64, WI-T3.0.0.30338 Firebird 3.0 Unstable
Reporter: Thomas Beckmann
Priority: Critical
The following statement works as expected in FB2.5 but fails in 3.0, returning
"SQL error code = -104. Invalid expression in the select list (not contained in
either an aggregate function or the GROUP BY clause)."
select
iif(D is null, 10, 0) + SYS as SYS,
count(*)
from (select
(select d.RDB$RELATION_ID from RDB$DATABASE d) as D,
coalesce(r.RDB$SYSTEM_FLAG, 0) as SYS
from RDB$RELATIONS r)
group by 1
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Precog is a next-generation analytics platform capable of advanced
analytics on semi-structured data. The platform includes APIs for building
apps and a phenomenal toolset for data science. Developers can use
our toolset for easy data analysis & visualization. Get a free account!
http://www2.precog.com/precogplatform/slashdotnewsletter
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
