fix for when we are adding /dropping columns in sqlite and need to roundtrip via...

[dbsrgits/SQL-Translator.git] / t / 30sqlt-new-diff-sqlite.t

diff --git a/t/30sqlt-new-diff-sqlite.t b/t/30sqlt-new-diff-sqlite.t
index d77e7b7..926162a 100644 (file)
--- a/t/30sqlt-new-diff-sqlite.t
+++ b/t/30sqlt-new-diff-sqlite.t
@@ -102,7 +102,7 @@ CREATE TEMPORARY TABLE "employee_temp_alter" (
   FOREIGN KEY ("employee_id") REFERENCES "person"("person_id")
 );
 
-INSERT INTO "employee_temp_alter" SELECT "position", "employee_id" FROM "employee";
+INSERT INTO "employee_temp_alter"( "position", "employee_id") SELECT "position", "employee_id" FROM "employee";
 
 DROP TABLE "employee";
 
@@ -131,7 +131,7 @@ CREATE TEMPORARY TABLE "person_temp_alter" (
   "physical_description" text
 );
 
-INSERT INTO "person_temp_alter" SELECT "person_id", "name", "age", "weight", "iq", "is_rock_star", "physical_description" FROM "person";
+INSERT INTO "person_temp_alter"( "person_id", "name", "age", "weight", "iq", "is_rock_star", "physical_description") SELECT "person_id", "name", "age", "weight", "iq", "is_rock_star", "physical_description" FROM "person";
 
 DROP TABLE "person";