From 5608317a38db7b63115e3b467d182a3e5cc31580 Mon Sep 17 00:00:00 2001 From: Thodoris Sotiropoulos Date: Thu, 11 Jun 2020 16:50:44 +0300 Subject: [PATCH] Fixes: #5395 Add 'exists' to SQLite's reserved keywords Fixes: https://github.com/sqlalchemy/sqlalchemy/issues/5395 --- lib/sqlalchemy/dialects/sqlite/base.py | 1 + test/dialect/test_sqlite.py | 1 + 2 files changed, 2 insertions(+) diff --git a/lib/sqlalchemy/dialects/sqlite/base.py b/lib/sqlalchemy/dialects/sqlite/base.py index 15d125ce0e..a203e786e2 100644 --- a/lib/sqlalchemy/dialects/sqlite/base.py +++ b/lib/sqlalchemy/dialects/sqlite/base.py @@ -1334,6 +1334,7 @@ class SQLiteIdentifierPreparer(compiler.IdentifierPreparer): "escape", "except", "exclusive", + "exists", "explain", "false", "fail", diff --git a/test/dialect/test_sqlite.py b/test/dialect/test_sqlite.py index fabbfa4a41..719834d4a6 100644 --- a/test/dialect/test_sqlite.py +++ b/test/dialect/test_sqlite.py @@ -639,6 +639,7 @@ class DialectTest( Column("true", Integer), Column("false", Integer), Column("column", Integer), + Column("exists", Integer), ) try: meta.create_all() -- 2.47.3