[
https://issues.apache.org/jira/browse/AIRFLOW-6366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17004010#comment-17004010
]
ASF subversion and git services commented on AIRFLOW-6366:
----------------------------------------------------------
Commit 0205b74341c39547d20abe1524ce326e9861db20 in airflow's branch
refs/heads/master from Bjorn Olsen
[ https://gitbox.apache.org/repos/asf?p=airflow.git;h=0205b74 ]
[AIRFLOW-6366] Fix migrations for MS SQL Server (#6920)
> 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
> Priority: Minor
> Fix For: 2.0.0
>
>
> Although MS SQL Server is not officially supported as a backend database, 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)
