Add parenthesis into the VIEW definition to make sure the pg parser still can deal...

[dbsrgits/SQL-Translator.git] / t / 44-xml-to-db2-array.t

diff --git a/t/44-xml-to-db2-array.t b/t/44-xml-to-db2-array.t
index 931b7e4..c09d850 100644 (file)
--- 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();',