X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F48xml-to-sqlite.t;h=f35846fb12b04ed3060dd9247015b18f55126fe2;hb=a25ac5d2649e414439ab60a075297361f2e5819d;hp=3473824008bb96c720abbd6bdb071a1b3958c988;hpb=75b8fbe8947a071a0ed53750af2e6f24a0ab2a40;p=dbsrgits%2FSQL-Translator.git

diff --git a/t/48xml-to-sqlite.t b/t/48xml-to-sqlite.t
index 3473824..f35846f 100644
--- a/t/48xml-to-sqlite.t
+++ b/t/48xml-to-sqlite.t
@@ -62,9 +62,9 @@ CREATE TABLE Another (
 );
 
 
-CREATE VIEW email_list AS (
-    SELECT email FROM Basic WHERE email IS NOT NULL
-  );
+DROP VIEW IF EXISTS email_list;
+CREATE VIEW email_list AS
+    SELECT email FROM Basic WHERE email IS NOT NULL;
 
 
 COMMIT;