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

sql_mode="oracle" does not support interval data type

    XMLWordPrintable

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

              serg Sergei Golubchik
              manjot Manjot Singh (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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