[MDEV-34829] LOCALTIME returns a wrong data type - Jira

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 10.5, (14)
10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4, 11.5(EOL), 11.6(EOL), 11.7(EOL)
Fix Version/s: 11.6.2
Component/s: Data types, Temporal Types
Labels:
None

MariaDB [test]> select localtime;

+---------------------+

| localtime           |

+---------------------+

| 2024-08-28 13:48:03 |

+---------------------+

Looks wrong. According to the standard, LOCALTIME should return the TIME data type as follows:

a) If <time precision> TP is specified, then LOCALTIME(TP) is equivalent to:

  CAST (CURRENT_TIME(TP) AS TIME(TP) WITHOUT TIME ZONE)

b) Otherwise, LOCALTIME is equivalent to:

  CAST (CURRENT_TIME AS TIME WITHOUT TIME ZONE)

LOCALTIME and LOCALTIMESTAMP are implemented as aliases to CURRENT_TIMESTAMP:

lex.h:  { "LOCALTIME",	SYM(NOW_SYM)},

lex.h:  { "LOCALTIMESTAMP",	SYM(NOW_SYM)},

The alias for LOCALTIME is wrong. It should alias to CURRENT_TIME instead of CURRENT_TIMESTAMP.

relates to

MDEV-15751 CURRENT_TIMESTAMP should return a TIMESTAMP (WITH TIME ZONE?)

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

MariaDB Server