"    \"COL_NOT_NULL_DEFAULT\" NUMBER(38) DEFAULT '-2.0' NOT NULL,\n"+
"    \"COL_NOT_NULL_DEFAULT\" NUMBER(38) DEFAULT -2.0 NOT NULL,\n"+
    public void testColumnConstraints() throws Exception    {        assertEqualsIgnoringWhitespaces(            "DROP TABLE \"constraints\" CASCADE CONSTRAINTS;\n" +            "DROP TRIGGER \"trg_constraints_L_PK_AUTO_INCR\";\n"+            "DROP SEQUENCE \"seq_constraints_L_PK_AUTO_INCR\";\n" +            "DROP TRIGGER \"trg_constraints_COL_AUTO_INCR\";\n"+            "DROP SEQUENCE \"seq_constraints_COL_AUTO_INCR\";\n" +            "CREATE SEQUENCE \"seq_constraints_L_PK_AUTO_INCR\";\n" +            "CREATE SEQUENCE \"seq_constraints_COL_AUTO_INCR\";\n" +            "CREATE TABLE \"constraints\"\n"+            "(\n"+            "    \"COL_PK\"               VARCHAR2(32),\n"+            "    \"COL_PK_AUTO_INCR\"     NUMBER(20,0),\n"+            "    \"COL_NOT_NULL\"         RAW(100) NOT NULL,\n"+            "    \"COL_NOT_NULL_DEFAULT\" NUMBER(38) DEFAULT '-2.0' NOT NULL,\n"+            "    \"COL_DEFAULT\"          CHAR(4) DEFAULT 'test',\n"+            "    \"COL_AUTO_INCR\"        NUMBER(38,0),\n"+            "    PRIMARY KEY (\"COL_PK\", \"COL_PK_AUTO_INCR\")\n"+            ");\n"+            "CREATE OR REPLACE TRIGGER \"trg_constraints_L_PK_AUTO_INCR\" BEFORE INSERT ON \"constraints\" FOR EACH ROW\n"+            "BEGIN\n"+            "  SELECT \"seq_constraints_L_PK_AUTO_INCR\".nextval INTO :new.\"COL_PK_AUTO_INCR\" FROM dual;\n"+            "END;\n"+            "CREATE OR REPLACE TRIGGER \"trg_constraints_COL_AUTO_INCR\" BEFORE INSERT ON \"constraints\" FOR EACH ROW\n"+            "BEGIN\n"+            "  SELECT \"seq_constraints_COL_AUTO_INCR\".nextval INTO :new.\"COL_AUTO_INCR\" FROM dual;\n"+            "END;\n",            createTestDatabase(COLUMN_CONSTRAINT_TEST_SCHEMA));    }