X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F44-xml-to-db2-array.t;h=c09d85066c596c23f2e5cb394d1484591c867c09;hb=3910f24828cc4aade90168adc7a99b284211b0aa;hp=931b7e4451a40c1dc0e8745377c8dc3f57a367e9;hpb=330e46868e86373801db03341df19a3aedbe75f1;p=dbsrgits%2FSQL-Translator.git diff --git a/t/44-xml-to-db2-array.t b/t/44-xml-to-db2-array.t index 931b7e4..c09d850 100644 --- a/t/44-xml-to-db2-array.t +++ b/t/44-xml-to-db2-array.t @@ -59,7 +59,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();',