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

          Ascending order - Click to sort in descending order
          dmtolpeko Dmitry Tolpeko created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Assignee Dmitry Tolpeko [ dmtolpeko ]
          bar Alexander Barkov made changes -
          Component/s OTHER [ 10125 ]
          Fix Version/s 10.2.2 [ 22013 ]
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          alvinr Alvin Richards (Inactive) made changes -
          Labels Compatibility
          alvinr Alvin Richards (Inactive) made changes -
          Labels Compatibility
          bar Alexander Barkov made changes -
          Assignee Dmitry Tolpeko [ dmtolpeko ] Alexander Barkov [ bar ]
          bar Alexander Barkov made changes -
          Fix Version/s 10.3.0 [ 22127 ]
          Fix Version/s 10.2.2 [ 22013 ]
          alvinr Alvin Richards (Inactive) made changes -
          Labels Compatibility
          alvinr Alvin Richards (Inactive) made changes -
          Labels Compatibility Compatibility NRE-307517
          alvinr Alvin Richards (Inactive) made changes -
          alvinr Alvin Richards (Inactive) made changes -
          alvinr Alvin Richards (Inactive) made changes -
          Labels Compatibility NRE-307517 Approved Compatibility NRE-307517
          alvinr Alvin Richards (Inactive) made changes -
          nre-project NRE-307517
          alvinr Alvin Richards (Inactive) made changes -
          Labels Approved Compatibility NRE-307517 Approved Compatibility
          alvinr Alvin Richards (Inactive) made changes -
          NRE Approved Yes [ 10304 ]
          alvinr Alvin Richards (Inactive) made changes -
          Labels Approved Compatibility Compatibility
          bar Alexander Barkov made changes -
          Labels Compatibility Compatibility need_review
          bar Alexander Barkov made changes -
          Component/s Parser [ 10201 ]
          bar Alexander Barkov made changes -
          Summary Providing compatibility for basic SQL data types sql_mode=ORACLE: Providing compatibility for basic SQL data types
          bar Alexander Barkov made changes -
          Description The following should be supported in MariaDB:

          * VARCHAR2
          * NUMBER
          * DATE (with time portion)
          * RAW
          * CLOB (as a large object)
          * BLOB (as a large object)           		The following should be supported in MariaDB when running with {{sql_mode=ORACLE}}:

          * VARCHAR2
          * NUMBER
          * DATE (with time portion)
          * RAW
          * CLOB (as a large object)
          * BLOB (as a large object)
          bar Alexander Barkov made changes -
          Description The following should be supported in MariaDB when running with {{sql_mode=ORACLE}}:

          * VARCHAR2
          * NUMBER
          * DATE (with time portion)
          * RAW
          * CLOB (as a large object)
          * BLOB (as a large object)           		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}}
          * {{CLOB}} (as a large object)
          * {{BLOB}} (as a large object)
          bar Alexander Barkov made changes -
          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}}
          * {{CLOB}} (as a large object)
          * {{BLOB}} (as a large object)           		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}}
          *
          bar Alexander Barkov made changes -
          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}}
          *           		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}}
          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..
          serg Sergei Golubchik made changes -
          Labels Compatibility need_review Compatibility
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 76365 ] MariaDB v4 [ 150592 ]

          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.