modifySql is not applied to rollback and loadData

Liquibase Development
1

I have added modifySql/replace to createTable to add quotes around the table name (because my application code expects that).
Then I want to load csv data into this table using loadData with the same modifySql.
This does not work for the created INSERT statements.
Also for the rollback the modifySql is not applied.

  <changeSet author="X" id="1">
    <createTable tableName="levelx">
      <column name="value1" type="NUMBER(10)"/>
    </createTable>
    <rollback>
      <!--<dropTable tableName="levelx"/>--><!-- this does not work, have to use sql -->
      <sql>DROP TABLE "levelx"</sql>
    </rollback>
    <modifySql>
      <replace replace="levelx" with="&quot;levelx&quot;"/>
    </modifySql>
  </changeSet>

  <changeSet author="X" id="2">
    <loadData file="levelx.csv" tableName="levelx"/>
    <modifySql>
      <replace replace="levelx" with="&quot;levelx&quot;"/>
    </modifySql>
  </changeSet>

Is that expected behavior or a bug?

2

Found attribute applyToRollback which solved the problem for rollback.
But it is not applied to the SQL created by loadData.

3

For loadData, modifySql would be extremely helpful to allow inserting into IDENTITY columns of SQL Server, but unfortunately this doesn’t work:

    <modifySql>
      <prepend value="SET IDENTITY_INSERT addr ON;"/>
    </modifySql>