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

10.2+ Integer DEFAULT values missing quotes

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.2(EOL)
    • N/A
    • Documentation
    • None
    • GNU/Linux

    Description

      SHOW CREATE TABLE test\G;
      

      MariaDB server 10.0:

        `link` tinyint(1) NOT NULL DEFAULT '1',
      

      MariaDB server 10.2:

        `link` tinyint(1) NOT NULL DEFAULT 1,
      

      I believe this change was intentional - not to quote integers. But both MySQL and MariaDB (prior to 10.2) had been behaving opposite on this - e.g. always quoted DEFAULT values. And now if some app relies on those outputs - it produces bad results across older vs. latest MariaDB server versions. I agree that it is bad to rely on such statements at first place in your app - but in our legacy app that was exactly the case.

      I doubt there is a flag to get back the old behavior?

      Note that this https://mariadb.com/kb/en/library/show-create-table/ is totally unrelated - that's for column names quotes, not DEFAULT values.

      Attachments

        Issue Links

          There are no Sub-Tasks for this issue.

          Activity

            People

              greenman Ian Gilfillan
              stamster Nemanja Stambolic
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.