The changesSet should include autoIncrement=“true” so liquibase understands that you intend it to be autoincrement. Liquibase should generate the correct sql per database, including not including any identity clause for sqlite since it is implied.
I have not really dealt with sqlite before to know the best way to test it out, different versions in use, etc. Is there anyone who can help with the sqlite support in 2.0? I can let you know what to do from a liquibase code standpoint, but I don’t know sqlite well enough to know what to change the liquibase code to.
Nathan