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

SQL_MODE="ORACLE" fails to catch keywords

    XMLWordPrintable

    Details

      Description

      The following conditions should be handled by setting SQL_MODE to ORACLE:

      • CHAR and VARCHAR column definition can be written as "...CHAR( 20 BYTE )". In reading Oracle's SQL Reference it is not clear if the intended behavior should honor multi-byte character sets. Ours does not understand, if even to just ignore it, the "BYTE" keyword.

      CREATE TABLE may be closed with the following parameters:
      NOLOGGING
      NOCOMPRESS
      NOPARALLEL

      • Each of these has a positive counterpart, LOGGING, COMPRESS, PARALLEL to enable these features explicitly. It appears the SQLDeveloper tools explicitly disable them in DDL exports regardless of the default values. This prompted this bug to be filed as it relates to migration projects.

      I do not see feature parity in MariaDB 10.3 except for COMPRESS. We could translate this to " ROW_FORMAT=COMPRESSED". At a minimum we should ignore these key words under the ORACLE sql_mode.

      • CREATE VIEW ( ... ) WITH READ ONLY; in Oracle defines the view as read-only. It does not seem like we have an explicit control for this when defining views.

        Attachments

          Activity

            People

            Assignee:
            bar Alexander Barkov
            Reporter:
            ae Adam Erickson (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated: