[MXS-2621] Incorrect SQL if lower_case_table_names is used. - Jira

XML

Word

Printable

If lower_case_table_names is specified, the used SQL will be incorrect:

dbusers.c:

...

    " AND (anydb = '1' OR LOWER('%s') IN ('', 'information_schema') OR LOWER('%s') LIKE LOWER(db)"

    " LIMIT 1";

There's a missing ) after LOWER(db).

relates to

MXS-2502 Specifying 'information_schema' as default schema upon connection gives 'access denied'