Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.7.3, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL)
-
10.7.3-MariaDB-1:10.7.3+maria~focal-log from docker image for both source and CONNECT servers. `dpkg -s mariadb-plugin-connect | grep Version` reports `Version: 1:10.7.3+maria~focal` for connect plugin
Description
Hello,
I have noticed that the connect engine does not properly quote columns in WHERE when the table type is MySQL. For example, issuing the following query against a CONNECT database:
SELECT `ID` FROM t1 WHERE t1.`spaced col` = 'C-003'; |
will issue the following against the main server:
SELECT `ID`, `spaced col` FROM `t1` WHERE spaced col= 'C-003'; |
Note how the WHERE clause is unquoted, which raises a syntax error.
Attachments
Issue Links
- links to