Fix mistake in CREATE TABLE loader_test2 statment

Problem with t/14ora_common.t :

DBD::Oracle::db do failed: ORA-00907: missing right parenthesis (DBD ERROR: error possibly near <*> indicator at char 175 in '
            CREATE TABLE loader_test2 (
                id INTEGER NOT NULL PRIMARY KEY,
                dat VARCHAR(32) NOT NULL,
                dat2 VARCHAR(32) NOT NULL <*>DEFAULT 'foo',
                UNIQUE (dat2, dat)
            )
        ') [for Statement "
            CREATE TABLE loader_test2 (
                id INTEGER NOT NULL PRIMARY KEY,
                dat VARCHAR(32) NOT NULL,
                dat2 VARCHAR(32) NOT NULL DEFAULT 'foo',
                UNIQUE (dat2, dat)
            )
        "] at t/lib/dbixcsl_common_tests.pm line 1173.

diff --git a/t/lib/dbixcsl_common_tests.pm b/t/lib/dbixcsl_common_tests.pm
index 03d7ecd..e899d42 100644 (file)
--- a/t/lib/dbixcsl_common_tests.pm
+++ b/t/lib/dbixcsl_common_tests.pm
@@ -781,7 +781,7 @@ sub create {
             CREATE TABLE loader_test2 (
                 id $self->{auto_inc_pk},
                 dat VARCHAR(32) NOT NULL,
-                dat2 VARCHAR(32) NOT NULL DEFAULT 'foo',
+                dat2 VARCHAR(32) DEFAULT 'foo' NOT NULL,
                 UNIQUE (dat2, dat)
             ) $self->{innodb}
         },