SQLite3 iterdump ordering

[JamieSpence]

BPO	16885
Nosy	@ezio-melotti, @bitdancer

^{Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.}

Show more details

GitHub fields:

assignee = None
closed_at = None
created_at = <Date 2013-01-07.14:43:50.088>
labels = ['type-bug']
title = 'SQLite3 iterdump ordering'
updated_at = <Date 2019-11-12.18:11:48.196>
user = 'https://bugs.python.org/JamieSpence'

bugs.python.org fields:

activity = <Date 2019-11-12.18:11:48.196>
actor = 'serhiy.storchaka'
assignee = 'ghaering'
closed = False
closed_date = None
closer = None
components = []
creation = <Date 2013-01-07.14:43:50.088>
creator = 'Jamie.Spence'
dependencies = []
files = []
hgrepos = []
issue_num = 16885
keywords = []
message_count = 4.0
messages = ['179267', '179771', '179791', '248836']
nosy_count = 4.0
nosy_names = ['ghaering', 'ezio.melotti', 'r.david.murray', 'Jamie.Spence']
pr_nums = []
priority = 'normal'
resolution = None
stage = 'needs patch'
status = 'pending'
superseder = None
type = 'behavior'
url = 'https://bugs.python.org/issue16885'
versions = ['Python 2.7', 'Python 3.2', 'Python 3.3', 'Python 3.4']

[JamieSpence]

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 table view query in dump.py by ID fix this issue?

[ezio-melotti]

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.

[bitdancer]

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.

[ghaering]

http://bugs.python.org/issue20463 (gh-64662)¹ is related.

Footnotes

1. gh link added for convenience by EAA ↩

[erlend-aasland]

Since there is no reproducer, I suggest to close this issue.