SQLLite seems to quote wrong #334

Closed
tommarien opened this Issue Nov 12, 2012 · 2 comments

Comments

Projects
None yet
1 participant
Owner

tommarien commented Nov 12, 2012

---- Issue from Fluentmigrator user group -----

Hi,
I have a problem migrating down with a SQLite database: when I migrate:up, the schema is created successfully and the entries of each migration is written into the VersionInfo table correctly. When I try to migrate down, the tables are changed accordingly to the migrations, but the entries in the VersionInfo table don't get deleted.

The output tells me, that it executes:

DELETE FROM 'VersionInfo' WHERE 'Version' = 201211070736

But the correct format (at least, the one working for me manually with a sql tool) should be

DELETE FROM "VersionInfo" WHERE "Version" = 201211070736

So, double quotes instead of single quotes. I'm new to SQLite. Is this maybe a OS issue (I'm on Win7)?

Greetings,
Tobias

Owner

tommarien commented Feb 1, 2013

This seems fixed by pull #358 Closing issue

@tommarien tommarien closed this Feb 1, 2013

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment