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

            Assignee:
            bertrandop Olivier Bertrand
            Reporter:
            bertrandop Olivier Bertrand
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration