[GitHub] [airflow] saryeHaddadi edited a comment on issue #9926: Scheduler errors when using MSSQL as the backend database

[GitBox <gi...@apache.org>]

saryeHaddadi edited a comment on issue #9926:
URL: https://github.com/apache/airflow/issues/9926#issuecomment-831208627


   Concerning this issue. The part of the query triggering the error is :
   `WHERE dag.is_paused IS 1`
   
   As part of [Ms-SQL Doc](https://docs.microsoft.com/fr-fr/sql/t-sql/queries/is-null-transact-sql?view=sql-server-ver15), the IS operator is only to be used with [NULL / NOT NULL].
   So, I assume that replacing this part by `dag.is_paused = 1` would fix the issue.
   
   --
   As a side node, my company is full Microsoft, and as many companies we need a flexible orchestrator like Airflow. We would also like to have Ms-SQL officially supported. I read the discussion and understood that you can not add support for all what users ask for, but I wanted to say it.
   
   We are Okay with Python based tool, Python being the Data Science language, and [Microsoft recently announced](https://devblogs.microsoft.com/python/supporting-the-python-community/) that they "are committed to supporting Python as a first-class language across our products and services."
   
   But in term of internal compentencies, DB management, and IT coherence, we have big reticences to bring in another DB technology.
   
   


-- 
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:
users@infra.apache.org