"    \"COL_PK\"               VARCHAR(32),\n"+
"    \"COL_PK\"               VARCHAR(32) NULL,\n"+
    public void testColumnConstraints() throws Exception    {        // this is not valid sql as a table can have only one identity column at most         assertEqualsIgnoringWhitespaces(            "SET quoted_identifier on;\n"+            "SET quoted_identifier on;\n"+            "IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'constraints')\n"+            "BEGIN\n"+            "    DROP TABLE \"constraints\"\n"+            "END;\n"+            "SET quoted_identifier on;\n"+            "CREATE TABLE \"constraints\"\n"+            "(\n"+            "    \"COL_PK\"               VARCHAR(32),\n"+            "    \"COL_PK_AUTO_INCR\"     INT IDENTITY,\n"+            "    \"COL_NOT_NULL\"         BINARY(100) NOT NULL,\n"+            "    \"COL_NOT_NULL_DEFAULT\" DOUBLE PRECISION DEFAULT -2.0 NOT NULL,\n"+            "    \"COL_DEFAULT\"          CHAR(4) DEFAULT 'test',\n"+            "    \"COL_AUTO_INCR\"        DECIMAL(19,0) IDENTITY,\n"+            "    PRIMARY KEY (\"COL_PK\", \"COL_PK_AUTO_INCR\")\n"+            ");\n",            createTestDatabase(COLUMN_CONSTRAINT_TEST_SCHEMA));    }