@Alienmario thanks for filing this issue. To clarify, are you suggesting that we need to update the dataType documentation here to add additional supported DBs?

No, I am asking to implement/allow specifying dataType for additional databases, similiar to mentioned PR.

@Alienmario ok. If a DB has support for dataType it should automatically work unless it's in this list. That list does include HSQLDB and MSSQL so we can start by rechecking those and removing them from the list.

Are you open to submitting a PR for those changes?

@lbadam Sure, I can have a try at it.

Browsing the CreateSequenceGenerator code, i'm noticing additional discrepancies between databases:

• The "IF NOT EXISTS" keyword automatically appended in Postgres is also available at least in HSQLDB. Would it be desirable to have it added?
• For databases HsqlDatabase and Db2zDatabase "AS BIGINT" is currently forced, ignoring the specified datatype. I'm assuming this is because these databases default to INTEGER data type, if not specified. However, since both support specifying dataType, I would like to change this behavior to only run when no dataType is specified in liquibase.
• I would also add "normal" DB2Database to the above as it also defaults to INTEGER for sequences. 1, 2
• The "cacheSize" parameter support does not correspond with documentation. However, that can be handled in another issue.