Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3.7
-
None
Description
After
SET sql_mode = 'oracle';
an error occurs with the following sql:
SELECT name, comment FROM mysql.proc
SQL Error [1064] [42000]: (conn:8) 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 'comment FROM mysql.proc
LIMIT 0, 200' at line 1
Query is : SELECT name, comment FROM mysql.proc
The problem is that this is used by several database IDEs (e.g. DBeaver, dbForge, etc.). They cannot list any packages with this error.
Apparently comment is a reserved word in SQL mode, so it has to be quoted.
| AddGeometryColumn | |
| DropGeometryColumn | |
Assigning to bar to confirm whether it's intentional.