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

Error 1758 doesnt have a SQLSTATE?

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.0.4
    • N/A
    • OTHER

    Description

      This is a MySQL bug, but as you know I prefer not to give lots of my personal data to Oracle.

      As far as I can tell, error 1758 seems to have not a SQLSTATE:

      MariaDB [(none)]> \W
      Show warnings enabled.
      MariaDB [(none)]> GET DIAGNOSTICS CONDITION 0 @a = MYSQL_ERRNO;
      Query OK, 0 rows affected, 1 warning (0.10 sec)
       
      Error (Code 1758): Invalid condition number

      From the documentation, SQLSTATE should be '35000':
      http://dev.mysql.com/doc/refman/5.6/en/error-messages-server.html

      This causes some trivial problems:

      • DECLARE HANDLER FOR '35000' doesnt handle it
      • Same for SQLEXCEPTION and other classes
      • mysqld reports it as a warning, not an error (see above)

      Attachments

        Activity

          People

            Unassigned Unassigned
            f_razzoli Federico Razzoli
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.