"DROP GENERATOR \"gen_constraints_OL_PK_AUTO_INCR\";\n" + "DROP GENERATOR \"gen_constraints_COL_AUTO_INCR\";\n" +
    public void testColumnConstraints() throws Exception    {        assertEqualsIgnoringWhitespaces(            "DROP TABLE \"constraints\";\n"+            "DROP GENERATOR \"gen_constraints_OL_PK_AUTO_INCR\";\n" +            "DROP GENERATOR \"gen_constraints_COL_AUTO_INCR\";\n" +            "CREATE TABLE \"constraints\"\n"+            "(\n"+            "    \"COL_PK\"               VARCHAR(32),\n"+            "    \"COL_PK_AUTO_INCR\"     INTEGER,\n"+            "    \"COL_NOT_NULL\"         BLOB(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\"        BIGINT,\n"+            "    PRIMARY KEY (\"COL_PK\", \"COL_PK_AUTO_INCR\")\n"+            ");\n"+            "CREATE GENERATOR \"gen_constraints_OL_PK_AUTO_INCR\";\n" +            "--TERM--;\n"+            "CREATE TRIGGER \"trg_constraints_OL_PK_AUTO_INCR\" FOR \"constraints\"\n"+            "ACTIVE BEFORE INSERT POSITION 0 AS\n"+            "BEGIN\n"+            "  IF (NEW.\"COL_PK_AUTO_INCR\" IS NULL) THEN\n"+            "    NEW.\"COL_PK_AUTO_INCR\" = GEN_ID(\"gen_constraints_OL_PK_AUTO_INCR\", 1);\n"+            "END;\n"+            "--TERM--;\n"+            "CREATE GENERATOR \"gen_constraints_COL_AUTO_INCR\";\n" +            "--TERM--;\n"+            "CREATE TRIGGER \"trg_constraints_COL_AUTO_INCR\" FOR \"constraints\"\n"+            "ACTIVE BEFORE INSERT POSITION 0 AS\n"+            "BEGIN\n"+            "  IF (NEW.\"COL_AUTO_INCR\" IS NULL) THEN\n"+            "    NEW.\"COL_AUTO_INCR\" = GEN_ID(\"gen_constraints_COL_AUTO_INCR\", 1);\n"+            "END;\n"+            "--TERM--;\n",            createTestDatabase(COLUMN_CONSTRAINT_TEST_SCHEMA));    }