[MXS-2733] UTC_TIMESTAMP not recognized as a built-in function Created: 2019-10-28  Updated: 2020-08-25  Resolved: 2019-10-28

Status: Closed
Project: MariaDB MaxScale
Component/s: qc_sqlite
Affects Version/s: 2.3.12
Fix Version/s: 2.3.13, 2.4.3

Type: Bug Priority: Major
Reporter: markus makela Assignee: Johan Wikman
Resolution: Fixed Votes: 1
Labels: None


 Description   

The following query is treated as a write:

SELECT UTC_TIMESTAMP();

The log_info output:

2019-10-28 07:54:47   info   : (1) > Autocommit: [enabled], trx is [not open], cmd: (0x03) COM_QUERY, plen: 27, type: QUERY_TYPE_READ|QUERY_TYPE_WRITE, stmt: SELECT UTC_TIMESTAMP()



 Comments   
Comment by MikaH [ 2019-10-28 ] 

SELECT NOW() - INTERVAL <nbr> HOUR;

works as a workaround?

Generated at Thu Feb 08 04:16:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.