[
http://tracker.firebirdsql.org/browse/CORE-6080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Vlad Khorsun reopened CORE-6080:
Re-opened to fix a bug, introduced by initial attempt
> Attempt to drop existing user randomly fails w
Hi
simple query raise an error
"Cannot use an aggregate or window function in a WHERE clause, use HAVING (for
aggregate only) instead."
SELECT
*
FROM
RDB$RELATIONS R
WHERE
R.RDB$SYSTEM_FLAG = 1
AND
(SELECT
COUNT(DISTINCT R.RDB$RELATION_NAME)
FROM
RDB$RELATION_FIELDS RF
WHERE
RF.RDB$