Comment 5 for bug 1646247

Revision history for this message
Matthew Oliver (matt-0) wrote :

I managed to create one using these steps.

 - Grab or create a container (I used ipython and a ContainerBroker).
 - Open the db in sqlite:

  sqlite3 my_malfored_schema.db

 - Turn on editable schemas:

   PRAGMA writable_schema=ON

 - Update (put a syntax error in the existing schema)

   update sqlite_master set sql = 'CRREAT TABLE object (ROWID INTEGER name TEXT)' where type='table' and name='object';

 - for safe measure I turned off the updateable schemas:

   PRAGMA writable_schema=OFF

 And there you have it.

sqlite> select * from object;
Error: malformed database schema (object_delete_policy_stat) - no such table: main.object

Attached you'll find the one I currupted.