Comment 1 for bug 1406314

I would like to see a move to eliminate SQLite from use in Keystone instead of trying to rely on it to "test" migrations. SQLite does not mirror any real production worthy system and tends to result in weird edge-cases.

Instead of "fixing" these migration tests we should move towards the functional test suite doing tests against MySQL and pgsql (in infra-gate) directly and drop SQLite support completely.

SQL migration tests need to be re-worked as well to mirror how nova handles them for pre-upgrade/upgrade/post-upgrade checks (and downgrades).