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

Strange error message when using unknown JSON function with default database

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.5.5
    • N/A
    • N/A
    • None

    Description

      Consider this

      MariaDB [(none)]> select json_unique("abcd");
      ERROR 1305 (42000): FUNCTION json_unique does not exist
      

      Not surprising as that function does not exist. But then

      MariaDB [(none)]> use test;
      Reading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
       
      Database changed
      MariaDB [test]> select json_unique("abcd");
      ERROR 1728 (HY000): Cannot load from mysql.proc. The table is probably corrupted
      

      That is, with a default database the error message leads you astray.

      Attachments

        Activity

          People

            johan.wikman Johan Wikman
            johan.wikman Johan Wikman
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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