I run liquibase 1.9.5 on an Oracle 10 database.
I run generateChangeLog in order to get a snapshot of the database as it looks like. On of the indeces we have is defined like this if you look at it in TOAD.
CREATE INDEX myIndex ON myTable (UPPER(“myColumn”))
The generateChangeLog generates a createIndex changeSet with column name = SYS_NC00007$ which obiously is not the name of the column. The result is that when I run the changeLog I get “ORA-00904: SYS_NC00007$: Invalid identifier”
Is that something that is possible to do something about?
Best regards /Lasse