"    \"COL_NUMERIC\"         DECIMAL(15,0),\n"+
"    \"COL_NUMERIC\"         FIXED(15,0),\n"+
    public void testColumnTypes() throws Exception    {        assertEqualsIgnoringWhitespaces(            "DROP TABLE \"coltype\" CASCADE;\n"+            "CREATE TABLE \"coltype\"\n"+            "(\n"+            "    \"COL_ARRAY\"           LONG BYTE,\n"+            "    \"COL_BIGINT\"          FIXED(38,0),\n"+            "    \"COL_BINARY\"          LONG BYTE,\n"+            "    \"COL_BIT\"             BOOLEAN,\n"+            "    \"COL_BLOB\"            LONG BYTE,\n"+            "    \"COL_BOOLEAN\"         BOOLEAN,\n"+            "    \"COL_CHAR\"            CHAR(15),\n"+            "    \"COL_CLOB\"            LONG,\n"+            "    \"COL_DATALINK\"        LONG BYTE,\n"+            "    \"COL_DATE\"            DATE,\n"+            "    \"COL_DECIMAL\"         DECIMAL(15,3),\n"+            "    \"COL_DECIMAL_NOSCALE\" DECIMAL(15,0),\n"+            "    \"COL_DISTINCT\"        LONG BYTE,\n"+            "    \"COL_DOUBLE\"          DOUBLE PRECISION,\n"+            "    \"COL_FLOAT\"           DOUBLE PRECISION,\n"+            "    \"COL_INTEGER\"         INTEGER,\n"+            "    \"COL_JAVA_OBJECT\"     LONG BYTE,\n"+            "    \"COL_LONGVARBINARY\"   LONG BYTE,\n"+            "    \"COL_LONGVARCHAR\"     LONG VARCHAR,\n"+            "    \"COL_NULL\"            LONG BYTE,\n"+            "    \"COL_NUMERIC\"         DECIMAL(15,0),\n"+            "    \"COL_OTHER\"           LONG BYTE,\n"+            "    \"COL_REAL\"            REAL,\n"+            "    \"COL_REF\"             LONG BYTE,\n"+            "    \"COL_SMALLINT\"        SMALLINT,\n"+            "    \"COL_STRUCT\"          LONG BYTE,\n"+            "    \"COL_TIME\"            TIME,\n"+            "    \"COL_TIMESTAMP\"       TIMESTAMP,\n"+            "    \"COL_TINYINT\"         SMALLINT,\n"+            "    \"COL_VARBINARY\"       LONG BYTE,\n"+            "    \"COL_VARCHAR\"         VARCHAR(15)\n"+            ");\n",            createTestDatabase(COLUMN_TEST_SCHEMA));    }