[#MXS-2621] Incorrect SQL if lower_case_table

[MXS-2621] Incorrect SQL if lower_case_table_names is used. Created: 2019-08-02 Updated: 2019-08-02 Resolved: 2019-08-02
Status:	Closed
Project:	MariaDB MaxScale
Component/s:	mysqlauth
Affects Version/s:	2.3.10
Fix Version/s:	2.3.11

Type:

Bug

Priority:

Critical

Reporter:

Johan Wikman

Assignee:

Johan Wikman

Resolution:

Fixed

Votes:

Labels:

None

Issue Links:

Relates
relates to	~~MXS-2502~~	Specifying 'information_schema' as de...	Closed

Description

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).

Generated at Thu Feb 08 04:15:28 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.