[Firebird-devel] [FB-Tracker] Reopened: (CORE-6080) Attempt to drop existing user randomly fails with "336723990 : record not found for user"

2019-07-02 Thread Vlad Khorsun (JIRA)
[ 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

[Firebird-devel] Can this case have more informative message?

2019-07-02 Thread liviuslivius
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