X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F72-sqlite-add-drop-fields.t;h=1fb0ab30c2974204548b30d4519a100caac7d8f5;hb=ac8d330a378aa569a21c2952ffa784afbbab18dc;hp=bdc3f93ea692ccc2990acbaccfcc60e120a1e160;hpb=1e54de2f59c32f7eb22ae4272b77d4c0eaeeb595;p=dbsrgits%2FSQL-Translator.git diff --git a/t/72-sqlite-add-drop-fields.t b/t/72-sqlite-add-drop-fields.t index bdc3f93..1fb0ab3 100644 --- a/t/72-sqlite-add-drop-fields.t +++ b/t/72-sqlite-add-drop-fields.t @@ -40,27 +40,27 @@ eq_or_diff($upgrade_sql, <<'## END OF DIFF', "Diff as expected"); BEGIN; -CREATE TEMPORARY TABLE "Foo_temp_alter" ( - "foo" INTEGER PRIMARY KEY NOT NULL, - "bar" VARCHAR(10) NOT NULL, - "baz" VARCHAR(10), - "doomed" VARCHAR(10) +CREATE TEMPORARY TABLE Foo_temp_alter ( + foo INTEGER PRIMARY KEY NOT NULL, + bar VARCHAR(10) NOT NULL, + baz VARCHAR(10), + doomed VARCHAR(10) ); -INSERT INTO "Foo_temp_alter"( "foo", "bar") SELECT "foo", "bar" FROM "Foo"; +INSERT INTO Foo_temp_alter( foo, bar) SELECT foo, bar FROM Foo; -DROP TABLE "Foo"; +DROP TABLE Foo; -CREATE TABLE "Foo" ( - "foo" INTEGER PRIMARY KEY NOT NULL, - "bar" VARCHAR(10) NOT NULL, - "baz" VARCHAR(10), - "doomed" VARCHAR(10) +CREATE TABLE Foo ( + foo INTEGER PRIMARY KEY NOT NULL, + bar VARCHAR(10) NOT NULL, + baz VARCHAR(10), + doomed VARCHAR(10) ); -INSERT INTO "Foo" SELECT "foo", "bar", "baz", "doomed" FROM "Foo_temp_alter"; +INSERT INTO Foo SELECT foo, bar, baz, doomed FROM Foo_temp_alter; -DROP TABLE "Foo_temp_alter"; +DROP TABLE Foo_temp_alter; COMMIT;