Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.1.2
-
None
Description
An SQL Query that does not touch ColumnStore tables running on a MariaDB ColumnStore
version "10.2.10-MariaDB-log - Columnstore 1.1.2-1" fails when the same query run against MariaDB version "10.1.26-MariaDB-0+deb9u1 - Debian 9.1" executes successfully when a hash (#) follows an escaped single quote (\').
Below queries do not need any tables to be set up beforehand.
Example Query:
SELECT `test_col` |
FROM `test_table` |
WHERE test_table.test_col = '\' #' |
Expected Result:
#1146 - Table '<database>.test_table' doesn't exist
Result on "10.2.10-MariaDB-log - Columnstore 1.1.2-1":
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''\'' at line 1
Result on "10.1.26-MariaDB-0+deb9u1 - Debian 9.1"
#1146 - Table '<database>.test_table' doesn't exist
Unfortunately I do not currently have a newer version of MariaDB Columnstore to test against.