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

extra warning "Unknown error" after update with invalid xmltype

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 12.3
    • 12.3
    • XML
    • None

    Description

      MariaDB [test]>   CREATE TABLE t (x XMLTYPE);
      Query OK, 0 rows affected (0,032 sec)
       
      MariaDB [test]> INSERT INTO t VALUES ('<a/>'),('<b>1</b>'),('<n>4.5</n>'),('<c/>');
      Query OK, 4 rows affected (0,016 sec)
      Records: 4  Duplicates: 0  Warnings: 0
       
      MariaDB [test]> UPDATE t SET x = 'xxx';
      ERROR 1525 (HY000): Incorrect XMLTYPE value: 'xxx'
      MariaDB [test]> show warnings;
      +-------+------+--------------------------------+
      | Level | Code | Message                        |
      +-------+------+--------------------------------+
      | Error | 1525 | Incorrect XMLTYPE value: 'xxx' |
      | Error | 1105 | Unknown error                  |
      +-------+------+--------------------------------+
      2 rows in set (0,001 sec)
      

      Attachments

        Issue Links

          Activity

            People

              holyfoot Alexey Botchkov
              alice Alice Sherepa
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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