"DELETE FROM RDB$GENERATOR WHERE RDB$GENERATOR_NAME = \"gen_constraints_OL_PK_AUTO_INCR\";\n" + "COMMIT;\n"+ "DELETE FROM RDB$GENERATOR WHERE RDB$GENERATOR_NAME = \"gen_constraints_COL_AUTO_INCR\";\n" + "COMMIT;\n"+
    public void testColumnConstraints() throws Exception    {        assertEqualsIgnoringWhitespaces(            "DELETE FROM RDB$GENERATOR WHERE RDB$GENERATOR_NAME = \"gen_constraints_OL_PK_AUTO_INCR\";\n" +            "COMMIT;\n"+            "DELETE FROM RDB$GENERATOR WHERE RDB$GENERATOR_NAME = \"gen_constraints_COL_AUTO_INCR\";\n" +            "COMMIT;\n"+            "DROP TABLE \"constraints\";\n"+            "COMMIT;\n"+            "CREATE TABLE \"constraints\"\n"+            "(\n"+            "    \"COL_PK\"               VARCHAR(32),\n"+            "    \"COL_PK_AUTO_INCR\"     INTEGER,\n"+            "    \"COL_NOT_NULL\"         CHAR(100) CHARACTER SET OCTETS 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(38,0),\n"+            "    PRIMARY KEY (\"COL_PK\", \"COL_PK_AUTO_INCR\")\n"+            ");\n"+            "COMMIT;\n"+            "CREATE GENERATOR \"gen_constraints_OL_PK_AUTO_INCR\";\n" +            "COMMIT;\n"+            "SET 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"+            "SET TERM ; !!\n"+            "COMMIT;\n"+            "CREATE GENERATOR \"gen_constraints_COL_AUTO_INCR\";\n" +            "COMMIT;\n"+            "SET 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"+            "SET TERM ; !!\n"+            "COMMIT;\n",            createTestDatabase(COLUMN_CONSTRAINT_TEST_SCHEMA));    }