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

Remove SQLite reserved keywords from sql scripts #1175

Open
limwa opened this issue Mar 1, 2024 · 0 comments · May be fixed by #1277
Open

Remove SQLite reserved keywords from sql scripts #1175

limwa opened this issue Mar 1, 2024 · 0 comments · May be fixed by #1277
Assignees

Comments

@limwa
Copy link
Member

limwa commented Mar 1, 2024

CREATE TABLE exams(id TEXT, subject TEXT, begin TEXT, end TEXT,

: super('userdata.db', ['CREATE TABLE userdata(key TEXT, value TEXT)']);

BEGIN, END and KEY are all reserved SQLite keywords and should be removed to avoid errors in some SQLite implementations.

SQLite reserved keywords: https://sqlite.org/lang_keywords.html

@vitormpp vitormpp linked a pull request Jul 19, 2024 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: 🏗 In progress
Development

Successfully merging a pull request may close this issue.

2 participants