Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-16464

Oracle Comp.: Sql-Error on "SELECT name, comment FROM mysql.proc"

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.7
    • Fix Version/s: 10.3.8
    • Component/s: Parser
    • Labels:
      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

            People

            • Assignee:
              bar Alexander Barkov
              Reporter:
              Estabillo Mebo
            • Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: