Incorrect message "Cannot use an aggregate or window function in a GROUP BY clause." when field if from outside context -----------------------------------------------------------------------------------------------------------------------
Key: CORE-6167 URL: http://tracker.firebirdsql.org/browse/CORE-6167 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.4, 3.0.5 Reporter: Karol Bieniaszewski Priority: Minor do nota analyse logic here, this is only a sample on system tables ----------------------- SELECT R.RDB$RELATION_NAME, ( SELECT SUM(RF.RDB$FIELD_ID) FROM RDB$RELATION_FIELDS RF WHERE RF.RDB$RELATION_NAME=R.RDB$RELATION_NAME GROUP BY R.RDB$RELATION_NAME /* here should be RF not R */ ) FROM RDB$RELATIONS R ----------------------- SQL error code = -104 Cannot use an aggregate or window function in a GROUP BY clause. --------------------------- Message should be maybe "cannot 'group by' by outside context" or something else but current one is not appropriate. -- 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 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel