"    \"COL_FLOAT\"         REAL,\n"+
"    \"COL_FLOAT\"         DOUBLE,\n"+
    public void testColumnTypes() throws Exception    {        assertEqualsIgnoringWhitespaces(            "DROP TABLE \"coltype\";\n"+            "CREATE TABLE \"coltype\"\n"+            "(\n"+            "    \"COL_ARRAY\"         BLOB,\n"+            "    \"COL_BIGINT\"        BIGINT,\n"+            "    \"COL_BINARY\"        CHAR(254) FOR BIT DATA,\n"+            "    \"COL_BIT\"           SMALLINT,\n"+            "    \"COL_BLOB\"          BLOB,\n"+            "    \"COL_BOOLEAN\"       SMALLINT,\n"+            "    \"COL_CHAR\"          CHAR(15),\n"+            "    \"COL_CLOB\"          CLOB,\n"+            "    \"COL_DATALINK\"      DATALINK,\n"+            "    \"COL_DATE\"          DATE,\n"+            "    \"COL_DECIMAL\"       DECIMAL(15,3),\n"+            "    \"COL_DECIM_NOSCALE\" DECIMAL(15,0),\n"+       // only 18 characters allowed for identifiers            "    \"COL_DISTINCT\"      DISTINCT,\n"+            "    \"COL_DOUBLE\"        DOUBLE,\n"+            "    \"COL_FLOAT\"         REAL,\n"+            "    \"COL_INTEGER\"       INTEGER,\n"+            "    \"COL_JAVA_OBJECT\"   BLOB,\n"+            "    \"COL_LONGVARBINARY\" LONG VARCHAR FOR BIT DATA,\n"+            "    \"COL_LONGVARCHAR\"   LONG VARCHAR,\n"+            "    \"COL_NULL\"          LONG VARCHAR FOR BIT DATA,\n"+            "    \"COL_NUMERIC\"       NUMERIC(15,0),\n"+            "    \"COL_OTHER\"         BLOB,\n"+            "    \"COL_REAL\"          REAL,\n"+            "    \"COL_REF\"           REF,\n"+            "    \"COL_SMALLINT\"      SMALLINT,\n"+            "    \"COL_STRUCT\"        BLOB,\n"+            "    \"COL_TIME\"          TIME,\n"+            "    \"COL_TIMESTAMP\"     TIMESTAMP,\n"+            "    \"COL_TINYINT\"       SMALLINT,\n"+            "    \"COL_VARBINARY\"     VARCHAR(15) FOR BIT DATA,\n"+            "    \"COL_VARCHAR\"       VARCHAR(15)\n"+            ");\n",            createTestDatabase(COLUMN_TEST_SCHEMA));    }