[jira] [Created] (AIRFLOW-6931) One migration failed during "airflow initdb" in mssql server 2017

["Baoshan Gu (Jira)" <ji...@apache.org>]

Baoshan Gu created AIRFLOW-6931:
-----------------------------------

             Summary: One migration failed during "airflow initdb" in mssql server 2017
                 Key: AIRFLOW-6931
                 URL: https://issues.apache.org/jira/browse/AIRFLOW-6931
             Project: Apache Airflow
          Issue Type: Bug
          Components: database
    Affects Versions: 1.10.9
         Environment: microsoft sqlserver 2017
            Reporter: Baoshan Gu


Running "airflw initdb" got error:
{code:java}
 _mssql.MSSQLDatabaseException: (5074, b"The object 'UQ__dag_run__F78A9899295C1915' is dependent on column 'execution_date'.DB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\nDB-Lib error message 20018, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")
{code}

The issue is migration file {{74effc47d867_change_datetime_to_datetime2_6_on_mssql_.py}} does not find all constraints. 
Specifically in line #234:
{code}74effc47d867_change_datetime_to_datetime2_6_on_mssql_.py{code}

Confirmed that changing it to case-insensitive selection works:
{code}(tc.CONSTRAINT_TYPE = 'PRIMARY KEY' or LOWER(tc.CONSTRAINT_TYPE) = 'unique'){code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)