Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-10142 PL/SQL parser
  3. MDEV-10343

sql_mode=ORACLE: Providing compatibility for basic SQL data types

Details

    • 10.2.2-3, 10.2.2-1, 10.2.2-2, 10.2.2-4, 10.1.18

    Description

      The following should be supported in MariaDB when running with sql_mode=ORACLE:

      • VARCHAR2 - a synonym to VARCHAR
      • NUMBER - a synonym to DECIMAL
      • DATE (with time portion) - a synonym to MariaDB DATETIME
      • RAW - a synonym to VARBINARY
      • CLOB - a synonym to LONGTEXT
      • BLOB - a synonym to LONGBLOB

      Attachments

        Activity

          doublep Paul Pogonyshev added a comment -

          Why wasn't NVARCHAR2 made a synonym to NVARCHAR too? In our (currently Oracle) database NVARCHAR2 is used even more often than VARCHAR2..

          doublep Paul Pogonyshev added a comment - Why wasn't NVARCHAR2 made a synonym to NVARCHAR too? In our (currently Oracle) database NVARCHAR2 is used even more often than VARCHAR2..

          People

            bar Alexander Barkov
            dmtolpeko Dmitry Tolpeko
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.