Hello,
using SQLcl 25.4.1, default settings.
Table contains a column, whose name matches one of the reserved words - “COMMENT”.
There's a comment on this column.
When exporting schema using project export, column comment definition is invalid, as column name is left unquoted.
Steps to reproduce
1. Create table, add comment:
create table T1
(
"COMMENT" NVARCHAR2(2000)
);
comment on column T1."COMMENT" is 'text';
2. Run project export
Produces script:
comment on column dummy.t1.comment is 'text';
Which results in error during deployment.
-
Regards,
Arvydas