[MDEV-26765] UNIX_TIMESTAMP(CURRENT_TIME()) return null ?!? - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.5.12, 10.4(EOL), 10.5, 10.6
Fix Version/s: 10.11.3, 10.4.29, 10.5.20, 10.6.13, 10.7.8, 10.8.8, 10.9.6, 10.10.4
Component/s: Data types
Labels:
- regression-10.4
Environment:
Debian 10.10

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

Alice Sherepa added a comment - 2021-10-05 09:48

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

Alice Sherepa added a comment - 2021-10-05 09:48 Thanks! I repeated on 10.4-10.6, while 10.3 returns the correct result.

Alexander Barkov added a comment - 2023-03-29 06:35 - 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)

Alexander Barkov added a comment - 2023-03-29 06:35 - 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)

People

Assignee:: Alexander Barkov

Reporter:: Christophe DEVEL

Votes:: 1 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2021-10-04 20:36

Updated:: 2024-07-07 21:01

Resolved:: 2023-03-29 08:55

Git Integration

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

MariaDB Server