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

view of timestamp returning datetime /* 5.3 */ format

Details

    Description

      From https://mariadb.com/kb/en/converting-datetime-to-new-temporal-format/,

      10.3,10.4

      		 
      MariaDB [test]> CREATE OR REPLACE VIEW v1 AS SELECT timestamp'2001-01-01 10:10:10' AS c1, now() AS c2;
      		 
      Query OK, 0 rows affected (0.001 sec)
      		 
       
      		 
      MariaDB [test]> SHOW COLUMNS IN v1;
      		 
      +-------+----------+------+-----+---------------------+-------+
      		 
      | Field | Type     | Null | Key | Default             | Extra |
      		 
      +-------+----------+------+-----+---------------------+-------+
      		 
      | c1    | datetime | NO   |     | 0000-00-00 00:00:00 |       |
      		 
      | c2    | datetime | NO   |     | 0000-00-00 00:00:00 |       |
      		 
      +-------+----------+------+-----+---------------------+-------+

      10.5

      		 
      CREATE OR REPLACE VIEW v1 AS SELECT timestamp'2001-01-01 10:10:10' AS c1, now() AS c2;
      		 
      SHOW COLUMNS IN v1;
      		 
      +-------+----------------------------+------+-----+---------------------+-------+
      		 
      | Field | Type                       | Null | Key | Default             | Extra |
      		 
      +-------+----------------------------+------+-----+---------------------+-------+
      		 
      | c1    | datetime /* mariadb-5.3 */ | NO   |     | 0000-00-00 00:00:00 |       |
      		 
      | c2    | datetime /* mariadb-5.3 */ | NO   |     | 0000-00-00 00:00:00 |       |
      		 
      +-------+----------------------------+------+-----+---------------------+-------+

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-19906 Show internal type for TIMESTAMP, DATETIME, and TIME columns

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Activity

            People

              bar Alexander Barkov
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.