Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19162 Some basic datatypes and functions in oracle compatibility mode do not work
  3. MDEV-18510

sql_mode="oracle" does not support COMMENT statements in PL/SQL

Details

    • Technical task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      Please add support for commands such as 

      COMMENT ON  COLUMN tablename.columnname  IS "some comment";

      https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_4009.htm

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          dmtolpeko Dmitry Tolpeko added a comment -

          Should be single quoted string: IS 'some comment'

          dmtolpeko Dmitry Tolpeko added a comment - Should be single quoted string: IS 'some comment'
          manjot Manjot Singh (Inactive) added a comment -

          PL/SQL supports double quote.

          manjot Manjot Singh (Inactive) added a comment - PL/SQL supports double quote.
          karlsson Anders Karlsson added a comment -

          I propose that we add support for this, but that an optional first implementation might be a non-operation.

          karlsson Anders Karlsson added a comment - I propose that we add support for this, but that an optional first implementation might be a non-operation.
          bar Alexander Barkov added a comment -

          It looks like adding a new verb statement COMMENT mapping into ALTER TABLE for TABLE and COLUMN level comments should be simple enough and do not need the non-operation step.

          bar Alexander Barkov added a comment - It looks like adding a new verb statement COMMENT mapping into ALTER TABLE for TABLE and COLUMN level comments should be simple enough and do not need the non-operation step.

          People

            Unassigned Unassigned
            manjot Manjot Singh (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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