Attempting to use count() in a query that requires an alias (for example, with DISTINCT, GROUP BY, or LIMIT clauses) throws a syntax exception if the table name includes the schema name.
This occurs because the alias name created in count() concatenates the full table name with a dot character.
The alias now uses the table name without a schema prefix and sanitized of quotations, if present.
Attempting to use
count()
in a query that requires an alias (for example, with DISTINCT, GROUP BY, or LIMIT clauses) throws a syntax exception if the table name includes the schema name.This occurs because the alias name created in
count()
concatenates the full table name with a dot character.The alias now uses the table name without a schema prefix and sanitized of quotations, if present.