quote SQLite identifiers

[dbsrgits/SQL-Translator.git] / t / 57-class-dbi.t

diff --git a/t/57-class-dbi.t b/t/57-class-dbi.t
index ace3f53..b2a5ecc 100644 (file)
--- a/t/57-class-dbi.t
+++ b/t/57-class-dbi.t
@@ -23,7 +23,7 @@ use SQL::Translator::Producer::SQLite;
     my $view1_sql1 =
       [ SQL::Translator::Producer::SQLite::create_view( $view1, $create_opts ) ];
 
-    my $view_sql_replace = [ "CREATE TEMPORARY VIEW IF NOT EXISTS view_foo AS
+    my $view_sql_replace = [ "CREATE TEMPORARY VIEW IF NOT EXISTS 'view_foo' AS
     SELECT id, name FROM thing" ];
     is_deeply( $view1_sql1, $view_sql_replace, 'correct "CREATE TEMPORARY VIEW" SQL' );
 
@@ -35,7 +35,7 @@ use SQL::Translator::Producer::SQLite;
 
     my $view1_sql2 =
       [ SQL::Translator::Producer::SQLite::create_view( $view2, $create_opts ) ];
-    my $view_sql_noreplace = [ "CREATE VIEW view_foo AS
+    my $view_sql_noreplace = [ "CREATE VIEW 'view_foo' AS
     SELECT id, name FROM thing" ];
     is_deeply( $view1_sql2, $view_sql_noreplace, 'correct "CREATE VIEW" SQL' );
 }