Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19144

sql_mode="oracle" does not support interval data type

    Details

      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/

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                manjot Manjot Singh
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: