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.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
After
SET sql_mode = 'oracle'; an error occurs with the following sql: 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. |
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. |
| Status | Open [ 1 ] | Confirmed [ 10101 ] |
| Component/s | Parser [ 10201 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Assignee | Alexander Barkov [ bar ] |
| issue.field.resolutiondate | 2018-06-13 04:25:59.0 | 2018-06-13 04:25:59.843 |
| Fix Version/s | 10.3.8 [ 23113 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Confirmed [ 10101 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 87786 ] | MariaDB v4 [ 154497 ] |