From: Robert Bohne <rbo@cpan.org>
Date: Thu, 4 Feb 2010 08:43:16 +0000 (+0100)
Subject: Fix mistake in CREATE TABLE loader_test2 statment
X-Git-Tag: 0.05001~8
X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits%2FDBIx-Class-Schema-Loader.git;a=commitdiff_plain;h=06109525562772b3d8a23748f918b42e7ea2d057

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
--- 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}
         },