[
https://issues.apache.org/jira/browse/AIRFLOW-6366?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17004009#comment-17004009
]
ASF GitHub Bot commented on AIRFLOW-6366:
-----------------------------------------
potiuk commented on pull request #6920: [AIRFLOW-6366] Fix migrations for MS
SQL Server
URL: https://github.com/apache/airflow/pull/6920
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> 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
>
> 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)
