X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F44-xml-to-db2-array.t;h=d4f5a5438edf798e235babe0c703db59387739c6;hb=4c0d31c125be1c212c2b984f4a4d806a61b2bd6e;hp=065fc35954d0db5fcdca68e7db9339680f0976bc;hpb=bc2ed06a8bade37c1bfdc8a918c41b6cab49474d;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/44-xml-to-db2-array.t b/t/44-xml-to-db2-array.t
index 065fc35..d4f5a54 100644
--- a/t/44-xml-to-db2-array.t
+++ b/t/44-xml-to-db2-array.t
@@ -37,7 +37,7 @@ q|CREATE TABLE Basic (
   id INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL,
   title VARCHAR(100) NOT NULL DEFAULT 'hello',
   description VARCHAR(0) DEFAULT '',
-  email VARCHAR(255),
+  email VARCHAR(500),
   explicitnulldef VARCHAR(0),
   explicitemptystring VARCHAR(0) DEFAULT '',
   emptytagdef VARCHAR(0) DEFAULT '',
@@ -51,6 +51,7 @@ q|CREATE TABLE Basic (
 
 q|CREATE TABLE Another (
   id INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1) NOT NULL,
+  num NUMERIC(10,2),
   PRIMARY KEY (id)
 );|,
 
@@ -59,7 +60,7 @@ q|CREATE TABLE Another (
 'CREATE INDEX titleindex ON Basic ( title );',
 
 'CREATE VIEW email_list AS
-SELECT email FROM Basic WHERE email IS NOT NULL;',
+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();',