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

[dbsrgits/SQL-Translator.git] / t / 51-xml-to-oracle.t

diff --git a/t/51-xml-to-oracle.t b/t/51-xml-to-oracle.t
index 5d01ae1..ec115b1 100644 (file)
--- a/t/51-xml-to-oracle.t
+++ b/t/51-xml-to-oracle.t
@@ -62,7 +62,7 @@ my $want = [
   PRIMARY KEY (id)
 )',
           'CREATE VIEW email_list AS
-SELECT email FROM Basic WHERE email IS NOT NULL',
+SELECT email FROM Basic WHERE (email IS NOT NULL)',
           'ALTER TABLE Basic ADD CONSTRAINT Basic_another_id_fk FOREIGN KEY (another_id) REFERENCES Another (id)',
           'CREATE OR REPLACE TRIGGER ai_Basic_id
 BEFORE INSERT ON Basic
@@ -129,7 +129,7 @@ CREATE TABLE Another (
 );
 
 CREATE VIEW email_list AS
-SELECT email FROM Basic WHERE email IS NOT NULL;
+SELECT email FROM Basic WHERE (email IS NOT NULL);
 
 ALTER TABLE Basic ADD CONSTRAINT Basic_another_id_fk01 FOREIGN KEY (another_id) REFERENCES Another (id);