Comment 1 for bug 1807262

FYI there is [1] now (since an hour), which is building atm.
The delta added is [2] to

The code that seems to be related and not working is not using a view, but who knows [3]
  self.append('ALTER TABLE %s RENAME TO migration_tmp' % table_name)
(If that is the right code at all, I need to check the package)

I first reproduced it locally with cinder as corey has shown.
it worked with 3.24 and got massive (not just this) errors with 3.26

Note: by enabling cosmic, disco and disco-proposed repos you can up and downgrade to all three.
Also useful [4] on how to run isolated tests of cinder.

Much more tests fail BTW, it seems all of the same class of tests fail. So maybe it is a DB setup issue with the new sqlite.

sqlite 3.24.0-1: works
sqlite 3.26.0-1: fails
sqlite 3.26.0-2: fails

So the next version is not a fix that will unblock us.
Also [5] changelog isn't pointing to anything obvious (I'm sure once we know it later it will be obvious).

We need to isolate the first fail as all others could be follow on issues.
So far it refused be isolated to a reasonable subset of tests.
But I didn't focus on that yet, I'll go back to 3.24 and try to shrink the set.

[1]: https://launchpad.net/ubuntu/+source/sqlite3/3.26.0-2
[2]: http://launchpadlibrarian.net/400530194/sqlite3_3.26.0-1_3.26.0-2.diff.gz
[3]: https://gitlab.cern.ch/cloud-infrastructure/rally/commit/3995f1fcd03b76f923637f39cc1b12f599fa61f6?expanded=1#21dac577876a8712e411fa71aa768fbd11a87883_108_0
[4]: https://docs.openstack.org/cinder/latest/contributor/testing.html
[5]: https://www.sqlite.org/changes.html