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

DEFAULT current_timestamp() discrepancy

    XMLWordPrintable

Details

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

    Description

      Another linked discrepancy on this matter.

      10.0

      createdTS timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

      10.2

      createdTS timestamp NOT NULL DEFAULT current_timestamp()

      What is the background on this one? Standards compliance or it's nicer to use functions instead of built-in constants?

      Attachments

        Issue Links

          is part of

          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
          relates to

          Technical task - A technical task. MDEV-15407 DEFAULT NULL forced when no DEFAULT set on NULL-able column

          • 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:
              4 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.