X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F48xml-to-sqlite.t;h=61b049dea8a208e8d853f46ee1bfbc4cc8d8e8ff;hb=3910f24828cc4aade90168adc7a99b284211b0aa;hp=2beef04591ad0cd8791aeb2875d20cd2fc55b2dc;hpb=330e46868e86373801db03341df19a3aedbe75f1;p=dbsrgits%2FSQL-Translator.git diff --git a/t/48xml-to-sqlite.t b/t/48xml-to-sqlite.t index 2beef04..61b049d 100644 --- a/t/48xml-to-sqlite.t +++ b/t/48xml-to-sqlite.t @@ -65,7 +65,7 @@ CREATE TABLE Another ( DROP VIEW IF EXISTS email_list; CREATE VIEW email_list AS - SELECT email FROM Basic WHERE email IS NOT NULL; + SELECT email FROM Basic WHERE (email IS NOT NULL); DROP TRIGGER IF EXISTS foo_trigger; @@ -113,7 +113,7 @@ eq_or_diff(\@sql, )', 'DROP VIEW IF EXISTS email_list; CREATE VIEW email_list AS - SELECT email FROM Basic WHERE email IS NOT NULL', + SELECT email FROM Basic WHERE (email IS NOT NULL)', 'DROP TRIGGER IF EXISTS foo_trigger', 'CREATE TRIGGER foo_trigger after insert on Basic BEGIN update modified=timestamp(); END', 'DROP TRIGGER IF EXISTS bar_trigger_insert',