Bjorn Olsen created AIRFLOW-6366:
------------------------------------
Summary: Fix migrations for MS SQL Server
Key: AIRFLOW-6366
URL: https://issues.apache.org/jira/browse/AIRFLOW-6366
Project: Apache Airflow
Issue Type: Bug
Components: database
Affects Versions: 1.10.7
Reporter: Bjorn Olsen
Assignee: Bjorn Olsen
Although MS SQL Server is not officially supported, I am using it via PyODBC
and found a minor issue with migration from 1.10.6 to 1.10.7.
Below is a log excerpt showing the issue:
INFO [alembic.runtime.migration] Running upgrade 6e96a59344a4 -> d38e04c12aa2,
add serialized_dag table
sqlalchemy.exc.ProgrammingError: (pyodbc.ProgrammingError) ('42000', "[42000]
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'JSON_VALID' is not a
recognized built-in function name. (195) (SQLExecDirectW)")
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
