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

sql_mode=ORACLE: TRUNCATE TABLE t1 [ {DROP|REUSE} STORAGE ]

    XMLWordPrintable

    Details

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

      Description

      When running with sql_mode=ORACLE, MariaDB will support an optional STORAGE clause.

      Example:

      TRUNCATE TABLE t1 DROP STORAGE;
      

      An open question is if the parser should just consume and ignore the STORAGE clause, or the underlying engine should perform some actions, depending on the choice between DROP or REUSE.

      The default behavior is DROP STORAGE.

      Note, although REUSE is a reserved keyword in Oracle, we won't reserve it even in sql_mode=ORACLE under terms of this task, as REUSE does not introduce grammar conflicts.

        Attachments

          Activity

            People

            • Assignee:
              bar Alexander Barkov
              Reporter:
              bar Alexander Barkov
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: