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

CHAR(36) columns are unconditionally regarded as GUID

    XMLWordPrintable

Details

    Description

      For example:

      CREATE TABLE tbs (id INT, bs CHAR(36));
      INSERT INTO tbs VALUES(1,'anything');    -- Ok
      SELECT * FROM tbs;   -- Error
      

      This raised an error message saying:

      Guid must contain 32 digits and 4 dashes
      (xxxxxxxx-xxxx-xxxx-xxxxxxxxxxxx)
      

      This is not documented and may occur unexpectedly when column definitions are made via Discovery.

      Note: This does not occur when using VARCHAR(36).

      Attachments

        Activity

          People

            bertrandop Olivier Bertrand
            bertrandop Olivier Bertrand
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.