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

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.