we tried to run following create table script using Liquibase 2.0.1 against a DB2 9.7
<?xml version="1.0" encoding="UTF-8"?>
DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=NUMBER, DRIVER=4.7.85
This DB2 error means that the generated SQL by Liquibase is wrong, the SQL data type should have been NUMERIC instead of NUMBER.
Running this script against a MSSQL 2005, or an Oracle 11g R1 works fine.
Is this a bug in LB, or is there something wrong with our script?