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

UNIX_TIMESTAMP(CURRENT_TIME()) return null ?!?

Details

    Description

      Hello,
      It seems that UNIX_TIMESTAMP(CURRENT_TIME()) returns null, but not UNIX_TIMESTAMP(CURRENT_TIMESTAMP())
      Is it wanted?
      Or is it a bug?
      Thank you for your reply

      – --------------------------------------
      SELECT
      UNIX_TIMESTAMP(CURRENT_TIME()),
      UNIX_TIMESTAMP(CURRENT_TIMESTAMP()),
      UNIX_TIMESTAMP(NOW())
      – --------------------------------------
      ;

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          c.devel Christophe DEVEL created issue -
          alice Alice Sherepa made changes -
          Field Original Value New Value
          Affects Version/s 10.4 [ 22408 ]
          Affects Version/s 10.5 [ 23123 ]
          Affects Version/s 10.6 [ 24028 ]
          alice Alice Sherepa made changes -
          Labels innodb
          alice Alice Sherepa made changes -
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Fix Version/s 10.6 [ 24028 ]
          alice Alice Sherepa added a comment -

          Thanks!
          I repeated on 10.4-10.6, while 10.3 returns the correct result.

          alice Alice Sherepa added a comment - Thanks! I repeated on 10.4-10.6, while 10.3 returns the correct result.
          alice Alice Sherepa made changes -
          Assignee Alexander Barkov [ bar ]
          alice Alice Sherepa made changes -
          Status Open [ 1 ] Confirmed [ 10101 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 125928 ] MariaDB v4 [ 144416 ]
          julien.fritsch Julien Fritsch made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          bar Alexander Barkov added a comment - - edited

          The same problem is repeatable with this statement:

          MariaDB [test]> SELECT UNIX_TIMESTAMP(TIME'10:20:30');
          		 
          +--------------------------------+
          		 
          | UNIX_TIMESTAMP(TIME'10:20:30') |
          		 
          +--------------------------------+
          		 
          |                           NULL |
          		 
          +--------------------------------+

          Also repeatable in this script:

          CREATE OR REPLACE TABLE t1 (a TIME);
          		 
          INSERT INTO t1 VALUES ('10:20:30');
          		 
          SELECT UNIX_TIMESTAMP(a) FROM t1;


          +-------------------+
          		 
          | UNIX_TIMESTAMP(a) |
          		 
          +-------------------+
          		 
          |              NULL |
          		 
          +-------------------+
          		 
          1 row in set, 1 warning (1.767 sec)

          bar Alexander Barkov added a comment - - edited The same problem is repeatable with this statement: MariaDB [test]> SELECT UNIX_TIMESTAMP( TIME '10:20:30' ); + --------------------------------+ | UNIX_TIMESTAMP( TIME '10:20:30' ) | + --------------------------------+ | NULL | + --------------------------------+ Also repeatable in this script: CREATE OR REPLACE TABLE t1 (a TIME ); INSERT INTO t1 VALUES ( '10:20:30' ); SELECT UNIX_TIMESTAMP(a) FROM t1; +-------------------+ | UNIX_TIMESTAMP(a) | +-------------------+ | NULL | +-------------------+ 1 row in set, 1 warning (1.767 sec)
          bar Alexander Barkov made changes -
          Labels regression-10.4
          bar Alexander Barkov made changes -
          issue.field.resolutiondate 2023-03-29 08:55:47.0 2023-03-29 08:55:47.226
          bar Alexander Barkov made changes -
          Fix Version/s 10.4.29 [ 28510 ]
          Fix Version/s 10.5.20 [ 28512 ]
          Fix Version/s 10.6.13 [ 28514 ]
          Fix Version/s 10.8.8 [ 28518 ]
          Fix Version/s 10.9.6 [ 28520 ]
          Fix Version/s 10.10.4 [ 28522 ]
          Fix Version/s 10.11.3 [ 28524 ]
          Fix Version/s 10.7.8 [ 28515 ]
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Fix Version/s 10.6 [ 24028 ]
          Resolution Fixed [ 1 ]
          Status Confirmed [ 10101 ] Closed [ 6 ]
          mariadb-jira-automation Jira Automation (IT) made changes -
          Zendesk Related Tickets 139210

          People

            bar Alexander Barkov
            c.devel Christophe DEVEL
            Votes:
            1 Vote for this issue
            Watchers:
            7 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.