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

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

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3.7
    • 10.3.8
    • Parser
    • 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

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

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 1h
                1h

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.