liquibase defaultValue vs defaultValueNumeric

Question

Can anyone tell me the difference between specifying a defaultValue="0" vs a defaultValueNumeric="0" in a changeset? It's for a bigint column.

http://www.liquibase.org/manual/add_default_value doesn't really go into detail here.

Answer 1

The difference is that defaultValue puts quotes around the value in the resulting SQL. Many database will interpret inserting '42' into a numeric field as the number 42, but some fail. defaultValueNumeric tells liquibase it is a number and therefore will not be quoted and will work on all database types.