Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Chokes on fields whose name contains 'check' #3

Open
henrywood opened this issue Apr 3, 2019 · 0 comments
Open

Chokes on fields whose name contains 'check' #3

henrywood opened this issue Apr 3, 2019 · 0 comments

Comments

@henrywood
Copy link

henrywood commented Apr 3, 2019

Just a short note to inform you that sqlite-parser chokes whenever it encounters a table when one or more fields contains the string 'check'.

Given this CREATE STATEMENT:

CREATE TABLE queue_items_results_machinedata (
                                        createdby TEXT,
                                        uploaded INTEGER DEFAULT 0,
                                        enabled INTEGER DEFAULT 0,
                                        needsupervisor INTEGER DEFAULT 0,
                                        checkedsupervisor INTEGER DEFAULT 0,
                                        markedfordeletion INTEGER DEFAULT 0,
                                        queueID TEXT,
                                        systemname TEXT,
                                        entityname TEXT,
                                        createddate INTEGER DEFAULT 0,
                                        mimetype TEXT,
                                        source TEXT,
                                        content TEXT,
                                        match TEXT,
                                        flags TEXT DEFAULT '{}',
                                        contextkey TEXT,
                                        size INTEGER DEFAULT 0,
                                        picture INTEGER DEFAULT 0,
                                        checked INTEGER DEFAULT 0,
                                        rawdata TEXT,
                                        crossout_json TEXT,
                                        crossout_imagedata TEXT
                                , deleted INTEGER DEFAULT '0')

(as returned from SQLite3)

it chokes with an exception such as:

Expect ')': 'ed INTEGER DEFAULT 0, rawdata TE...' FROM 'CREATE TABLE queue_items_results_machinedata ( createdby TEXT, uploaded INTEGER DEFAULT 0, enabled INTEGER DEFAULT 0, markedfordeletion INTEGER DEFAULT 0, queueID TEXT, systemname TEXT, entityname TEXT, createddate INTEGER DEFAULT 0, mimetype TEXT, source TEXT, content TEXT, match TEXT, flags TEXT DEFAULT '{}', contextkey TEXT, size INTEGER DEFAULT 0, picture INTEGER DEFAULT 0, checked INTEGER DEFAULT 0, rawdata TEXT, crossout_json TEXT, crossout_imagedata TEXT )'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant