Some basic datatypes and functions in oracle compatibility mode do not work (MDEV-19162)

[MDEV-20023] sql_mode="oracle" does not support TRUNC() function Created: 2019-07-10  Updated: 2019-09-10

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Technical task Priority: Major
Reporter: Faisal Saeed (Inactive) Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: Compatibility


 Description   

This function is commonly used in Oracle PL/SQL or queries to truncate various data types for instance;

1. TRUNCATE a fraction from a number
2. TRUNCATE a timestamp portion of a date/datetime/timestamp values

TRUNC(DATE/DATETIME/TIMESTAMP): https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions201.htm

TRUNC(NUMBER): https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions200.htm
Generated at Thu Feb 08 08:56:09 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.