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

Invalid default value on DEFAULT NULL TIMESTAMP

Details

    Description

      On mariadb 10.5.4 it seen not possible to create a TIMESTAMP column with null default value.

      For exemple :
      CREATE TABLE Test (
      test TIMESTAMP DEFAULT NULL
      );

      Return :
      Error Code: 1067
      Invalid default value for 'test'

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Alice Sherepa made transition -
          Open Closed
          		1h 20m 1

          People

            Unassigned Unassigned
            fmartin35 Florent
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.