diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2021-03-24 12:00:16 -0400 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2021-03-24 12:02:33 -0400 |
| commit | 3fc9f11c23e39e95e4d33572d04e74f74b0f20ed (patch) | |
| tree | 749cb9125c12068d51dc8eff295476d6262494a1 | |
| parent | a22b4dfbc44c78cb4fce27c33cf74cf57878a3b1 (diff) | |
| download | sqlalchemy-3fc9f11c23e39e95e4d33572d04e74f74b0f20ed.tar.gz | |
open up window functions (ha ha) for mysql / mariadb
MySQL 8 and MariaDB 10.2 support window functions so this
should be turned on.
Change-Id: Ic1fdd328f1f0def7dfc8451385c16ea81902074c
| -rw-r--r-- | lib/sqlalchemy/sql/elements.py | 3 | ||||
| -rw-r--r-- | test/requirements.py | 9 |
2 files changed, 9 insertions, 3 deletions
diff --git a/lib/sqlalchemy/sql/elements.py b/lib/sqlalchemy/sql/elements.py index b3b041385..20c3e8991 100644 --- a/lib/sqlalchemy/sql/elements.py +++ b/lib/sqlalchemy/sql/elements.py @@ -3777,8 +3777,7 @@ class Over(ColumnElement): This is a special operator against a so-called "window" function, as well as any aggregate function, which produces results relative to the result set - itself. It's supported only by certain database - backends. + itself. Most modern SQL backends now support window functions. """ diff --git a/test/requirements.py b/test/requirements.py index 33f5e7fd0..21e009188 100644 --- a/test/requirements.py +++ b/test/requirements.py @@ -751,7 +751,14 @@ class DefaultRequirements(SuiteRequirements): @property def window_functions(self): return only_if( - ["postgresql>=8.4", "mssql", "oracle", "sqlite>=3.25.0"], + [ + "postgresql>=8.4", + "mssql", + "oracle", + "sqlite>=3.25.0", + "mysql>=8", + "mariadb>=10.2", + ], "Backend does not support window functions", ) |