Hi,
I’m testing liquibase to know how it’s works and I will to use it in the future.
I do a liquibase update and the store entries in databasechangelog. Like this entry:
ID AUTHOR FILENAME DATEEXECUTED ORDEREXECUTED EXECTYPE MD5SUM DESCRIPTION COMMENTS TAG LIQUIBASE
1 3 bob ./DataBaseChanges/BAT/JIRA/example.xml 01-APR-11 11.05.24.000000 AM 2 EXECUTED 3:a86f8a1dcc0e0903e93166c3861e8f39 Insert Row (x2) 2.0.1
This it’s fine for me but I tried to do rollback using the date(rollbackDate). I execute the ant command and I put a future date and I expect that it’s not necessary to do rollback because I hope that the rollback start in the date that I put.
In this example I put: rollbackdate=“03/05/2011 23:59:59” and do the rollback successfully, ¿It’s normal? I think that It’s a bug.
I’m using liquibase-2.0.1-bin:
- Oracle Database.
2. Update:
<updateDatabase
changeLogFile="${liquibase.changeLogFile}"
driver="${liquibase.database.driver}"
url="${liquibase.database.url}"
username="${liquibase.database.username}"
password="${liquibase.database.password}"
promptOnNonLocalDatabase=“false”
dropFirst=“false”
contexts=“test”
classpathref=“liquibase.classpath”
/>
3. Rollback:
<rollbackDatabase
changeLogFile="${liquibase.changeLogFile}"
driver="${liquibase.database.driver}"
url="${liquibase.database.url}"
username="${liquibase.database.username}"
password="${liquibase.database.password}"
rollbackdate=“03/05/2011 23:59:59”
classpathref=“liquibase.classpath”
/>