"    \"COL_ARRAY\"           IMAGE,\n"+ "    \"COL_BIGINT\"          DECIMAL(19,0),\n"+ "    \"COL_BINARY\"          BINARY(254),\n"+ "    \"COL_BIT\"             SMALLINT,\n"+ "    \"COL_BLOB\"            IMAGE,\n"+ "    \"COL_BOOLEAN\"         SMALLINT,\n"+ "    \"COL_CHAR\"            CHAR(15),\n"+ "    \"COL_CLOB\"            TEXT,\n"+ "    \"COL_DATALINK\"        IMAGE,\n"+ "    \"COL_DATE\"            DATETIME,\n"+ "    \"COL_DECIMAL\"         DECIMAL(15,3),\n"+ "    \"COL_DECIMAL_NOSCALE\" DECIMAL(15,0),\n"+ "    \"COL_DISTINCT\"        IMAGE,\n"+ "    \"COL_DOUBLE\"          DOUBLE PRECISION,\n"+ "    \"COL_FLOAT\"           DOUBLE PRECISION,\n"+ "    \"COL_INTEGER\"         INT,\n"+ "    \"COL_JAVA_OBJECT\"     IMAGE,\n"+ "    \"COL_LONGVARBINARY\"   IMAGE,\n"+ "    \"COL_LONGVARCHAR\"     TEXT,\n"+ "    \"COL_NULL\"            IMAGE,\n"+ "    \"COL_NUMERIC\"         NUMERIC(15,0),\n"+ "    \"COL_OTHER\"           IMAGE,\n"+ "    \"COL_REAL\"            REAL,\n"+ "    \"COL_REF\"             IMAGE,\n"+ "    \"COL_SMALLINT\"        SMALLINT,\n"+ "    \"COL_STRUCT\"          IMAGE,\n"+ "    \"COL_TIME\"            DATETIME,\n"+ "    \"COL_TIMESTAMP\"       DATETIME,\n"+ "    \"COL_TINYINT\"         SMALLINT,\n"+ "    \"COL_VARBINARY\"       VARBINARY(15),\n"+ "    \"COL_VARCHAR\"         VARCHAR(15)\n"+
"    \"COL_ARRAY\"           IMAGE NULL,\n"+ "    \"COL_BIGINT\"          DECIMAL(19,0) NULL,\n"+ "    \"COL_BINARY\"          BINARY(254) NULL,\n"+ "    \"COL_BIT\"             SMALLINT NULL,\n"+ "    \"COL_BLOB\"            IMAGE NULL,\n"+ "    \"COL_BOOLEAN\"         SMALLINT NULL,\n"+ "    \"COL_CHAR\"            CHAR(15) NULL,\n"+ "    \"COL_CLOB\"            TEXT NULL,\n"+ "    \"COL_DATALINK\"        IMAGE NULL,\n"+ "    \"COL_DATE\"            DATETIME NULL,\n"+ "    \"COL_DECIMAL\"         DECIMAL(15,3) NULL,\n"+ "    \"COL_DECIMAL_NOSCALE\" DECIMAL(15,0) NULL,\n"+ "    \"COL_DISTINCT\"        IMAGE NULL,\n"+ "    \"COL_DOUBLE\"          DOUBLE PRECISION NULL,\n"+ "    \"COL_FLOAT\"           DOUBLE PRECISION NULL,\n"+ "    \"COL_INTEGER\"         INT NULL,\n"+ "    \"COL_JAVA_OBJECT\"     IMAGE NULL,\n"+ "    \"COL_LONGVARBINARY\"   IMAGE NULL,\n"+ "    \"COL_LONGVARCHAR\"     TEXT NULL,\n"+ "    \"COL_NULL\"            IMAGE NULL,\n"+ "    \"COL_NUMERIC\"         NUMERIC(15,0) NULL,\n"+ "    \"COL_OTHER\"           IMAGE NULL,\n"+ "    \"COL_REAL\"            REAL NULL,\n"+ "    \"COL_REF\"             IMAGE NULL,\n"+ "    \"COL_SMALLINT\"        SMALLINT NULL,\n"+ "    \"COL_STRUCT\"          IMAGE NULL,\n"+ "    \"COL_TIME\"            DATETIME NULL,\n"+ "    \"COL_TIMESTAMP\"       DATETIME NULL,\n"+ "    \"COL_TINYINT\"         SMALLINT NULL,\n"+ "    \"COL_VARBINARY\"       VARBINARY(15) NULL,\n"+ "    \"COL_VARCHAR\"         VARCHAR(15) NULL\n"+
    public void testColumnTypes() throws Exception    {        assertEqualsIgnoringWhitespaces(            "SET quoted_identifier on;\n"+            "SET quoted_identifier on;\n"+            "IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'coltype')\n"+            "BEGIN\n"+            "    DROP TABLE \"coltype\"\n"+            "END;\n"+            "SET quoted_identifier on;\n"+            "CREATE TABLE \"coltype\"\n"+            "(\n"+            "    \"COL_ARRAY\"           IMAGE,\n"+            "    \"COL_BIGINT\"          DECIMAL(19,0),\n"+            "    \"COL_BINARY\"          BINARY(254),\n"+            "    \"COL_BIT\"             SMALLINT,\n"+            "    \"COL_BLOB\"            IMAGE,\n"+            "    \"COL_BOOLEAN\"         SMALLINT,\n"+            "    \"COL_CHAR\"            CHAR(15),\n"+            "    \"COL_CLOB\"            TEXT,\n"+            "    \"COL_DATALINK\"        IMAGE,\n"+            "    \"COL_DATE\"            DATETIME,\n"+            "    \"COL_DECIMAL\"         DECIMAL(15,3),\n"+            "    \"COL_DECIMAL_NOSCALE\" DECIMAL(15,0),\n"+            "    \"COL_DISTINCT\"        IMAGE,\n"+            "    \"COL_DOUBLE\"          DOUBLE PRECISION,\n"+            "    \"COL_FLOAT\"           DOUBLE PRECISION,\n"+            "    \"COL_INTEGER\"         INT,\n"+            "    \"COL_JAVA_OBJECT\"     IMAGE,\n"+            "    \"COL_LONGVARBINARY\"   IMAGE,\n"+            "    \"COL_LONGVARCHAR\"     TEXT,\n"+            "    \"COL_NULL\"            IMAGE,\n"+            "    \"COL_NUMERIC\"         NUMERIC(15,0),\n"+            "    \"COL_OTHER\"           IMAGE,\n"+            "    \"COL_REAL\"            REAL,\n"+            "    \"COL_REF\"             IMAGE,\n"+            "    \"COL_SMALLINT\"        SMALLINT,\n"+            "    \"COL_STRUCT\"          IMAGE,\n"+            "    \"COL_TIME\"            DATETIME,\n"+            "    \"COL_TIMESTAMP\"       DATETIME,\n"+            "    \"COL_TINYINT\"         SMALLINT,\n"+            "    \"COL_VARBINARY\"       VARBINARY(15),\n"+            "    \"COL_VARCHAR\"         VARCHAR(15)\n"+            ");\n",            createTestDatabase(COLUMN_TEST_SCHEMA));    }