Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15377 10.2+ Integer DEFAULT values missing quotes
  3. MDEV-15407

DEFAULT NULL forced when no DEFAULT set on NULL-able column

    XMLWordPrintable

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • 10.2
    • N/A
    • Documentation, Server
    • None
    • GNU/Linux

    Description

      Now this starts to smell.
      If a column is defined as NULL-able, 10.2 will automatically append DEFAULT NULL to create statements.

      10.2

        `description` text COLLATE utf8_bin DEFAULT NULL

      10.0

       `description` text COLLATE utf8_bin

      Originally the column does not have DEFAULT value set at all!

      Basically table exported from 10.2 will not work in a same way on MariaDB 10.0 or MySQL servers.

      Attachments

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15519 CHECKSUM TABLE gives different results across MariaDB 10.0 and 10.2

          • Major - Major loss of function.
          • Confirmed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-15377 10.2+ Integer DEFAULT values missing quotes

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Technical task - A technical task. MDEV-15390 information_schema returns quoted strings for default textual columns

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Technical task - A technical task. MDEV-15394 DEFAULT current_timestamp() discrepancy

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Activity

            People

              greenman Ian Gilfillan
              stamster Nemanja Stambolic
              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.