[MDEV-19144] sql_mode="oracle" does not support interval data type Created: 2019-04-02  Updated: 2019-05-14  Resolved: 2019-04-03

Status: Closed
Project: MariaDB Server
Component/s: Temporal Types
Fix Version/s: N/A

Type: Task Priority: Major
Reporter: Manjot Singh (Inactive) Assignee: Sergei Golubchik
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
is duplicated by MDEV-12513 INTERVAL data type Open

 Description   

Tried a tutorial creation:

MariaDB [test]> CREATE TABLE candidates (
    ->     candidate_id NUMBER,
    ->     first_name VARCHAR2(50) NOT NULL,
    ->     last_name VARCHAR2(50) NOT NULL,
    ->     job_title VARCHAR2(255) NOT NULL,
    ->     year_of_experience INTERVAL YEAR TO MONTH,
    ->     PRIMARY KEY (candidate_id)
    -> );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'INTERVAL YEAR TO MONTH,
    PRIMARY KEY (candidate_id)
)' at line 6

Interval ddl:
http://www.oracletutorial.com/oracle-basics/oracle-interval/


Generated at Thu Feb 08 08:49:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.