[issue16885] SQLite3 iterdump ordering

Change by Serhiy Storchaka : -- status: open -> pending ___ Python tracker ___ ___ Python-bugs-list mailing list Unsubscribe:

[issue16885] SQLite3 iterdump ordering

Gerhard Häring added the comment: http://bugs.python.org/issue20463 is related. -- assignee: - ghaering ___ Python tracker rep...@bugs.python.org http://bugs.python.org/issue16885 ___

[issue16885] SQLite3 iterdump ordering

R. David Murray added the comment: When you say sometimes, do you mean randomly on the same schema, or do you mean depending on the specific schema sometimes it doesn't work? The code is the same in the other python versions, so I'm adding them as the bug doubtless exists there as well.

[issue16885] SQLite3 iterdump ordering

Ezio Melotti added the comment: Can you provide a minimal script to reproduce the issue? If you can then turn the script in a unittest, you can try to patch the code and order the sqlite_master table and see if that fixes the problem. -- nosy: +ezio.melotti, ghaering, r.david.murray

[issue16885] SQLite3 iterdump ordering

New submission from Jamie Spence: After dumping a database with iterdump, trying to execute the dumped SQL sometimes results in an error because the statement order may be wrong. In my case, it is a view that is being created before the view it is referencing. Would ordering the sqlite_master