projects
/
dbsrgits/SQL-Translator.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
Pg views and sqlite views, patch from wreis
[dbsrgits/SQL-Translator.git]
/
t
/
48xml-to-sqlite.t
diff --git
a/t/48xml-to-sqlite.t
b/t/48xml-to-sqlite.t
index
3473824
..
f35846f
100644
(file)
--- 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;