X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F44-xml-to-db2-array.t;h=d254af9522aae49390518365a66daafdac9c461a;hb=08d91aada45b94a16f3660b5cc10384df5616ff9;hp=d20ba89090e9bffc2e01237c257345190123e0fc;hpb=5c32ca599a05e9950d26fd2238f071cffc2c964e;p=dbsrgits%2FSQL-Translator.git diff --git a/t/44-xml-to-db2-array.t b/t/44-xml-to-db2-array.t index d20ba89..d254af9 100644 --- a/t/44-xml-to-db2-array.t +++ b/t/44-xml-to-db2-array.t @@ -41,6 +41,7 @@ email VARCHAR(255), explicitnulldef VARCHAR(0), explicitemptystring VARCHAR(0) DEFAULT '', emptytagdef VARCHAR(0) DEFAULT '', +timest TIMESTAMP, CONSTRAINT emailuniqueindex UNIQUE (email) , PRIMARY KEY(id) );|, @@ -53,4 +54,4 @@ SELECT email FROM Basic WHERE email IS NOT NULL;', 'CREATE TRIGGER foo_trigger after insert ON Basic REFERENCING OLD AS oldrow NEW AS newrow FOR EACH ROW MODE DB2SQL update modified=timestamp();' ]; -is_deeply(\@sql, $want, 'Got correct DB2 statements in list context'); \ No newline at end of file +is_deeply(\@sql, $want, 'Got correct DB2 statements in list context');