For some databases, column names are put in square brackets even though the database doesn’t require it.
This makes some post-processing we do on the generated SQL fail.
Is there a way to turn of [bracket] generation?
For some databases, column names are put in square brackets even though the database doesn’t require it.
This makes some post-processing we do on the generated SQL fail.
Is there a way to turn of [bracket] generation?
Nothing built in controls that, but you can create a Database extension that changes the logic. Liquibase tries to just put brackets around column names that it thinks will be a problem. What database and column names are you seeing the problem with?
Nathan
The generated SQL is correct, it just makes it harder to do fixups with ModifySql. We need the modify because CreateIndex doesn’t support asc/desc on columns.
The real solution is of course to support asc/desc on CreateIndex 
I understand the problem.
I created https://liquibase.jira.com/browse/CORE-1683 to track the asc/desc logic.
I also created https://liquibase.jira.com/browse/CORE-1684 to track improvements to modifySQL
Nathan