From d3c73ad8012e15bf47529b3fcb0bac1298fbdb90 Mon Sep 17 00:00:00 2001 From: Federico Caselli Date: Wed, 21 Apr 2021 22:49:09 +0200 Subject: Propertly ignore ``Identity`` in MySQL and MariaDb. Ensure that the MySQL and MariaDB dialect ignore the :class:`_sql.Identity` construct while rendering the ``AUTO_INCREMENT`` keyword in a create table. The Oracle and PostgreSQL compiler was updated to not render :class:`_sql.Identity` if the database version does not support it (Oracle < 12 and PostgreSQL < 10). Previously it was rendered regardless of the database version. Fixes: #6338 Change-Id: I2ca0902fdd7b4be4fc1a563cf5585504cbea9360 --- lib/sqlalchemy/testing/requirements.py | 7 +++++++ 1 file changed, 7 insertions(+) (limited to 'lib/sqlalchemy/testing/requirements.py') diff --git a/lib/sqlalchemy/testing/requirements.py b/lib/sqlalchemy/testing/requirements.py index 8a70cc692..673fa15cd 100644 --- a/lib/sqlalchemy/testing/requirements.py +++ b/lib/sqlalchemy/testing/requirements.py @@ -1417,3 +1417,10 @@ class SuiteRequirements(Requirements): or ties. basically this is "not mssql" """ return exclusions.closed() + + @property + def autoincrement_without_sequence(self): + """If autoincrement=True on a column does not require an explicit + sequence. This should be false only for oracle. + """ + return exclusions.open() -- cgit v1.2.1