Adam Trump created AIRFLOW-5342:
-----------------------------------
Summary: Can't run initdb using Microsoft SQL server
Key: AIRFLOW-5342
URL: https://issues.apache.org/jira/browse/AIRFLOW-5342
Project: Apache Airflow
Issue Type: Bug
Components: configuration, core, database
Affects Versions: 1.10.4
Reporter: Adam Trump
I'm using Microsoft SQL server 2016 as metadata db (for the sql_alchemy_conn),
and pymssql as the Python driver.
When running airflow initdb, airflow creates a table named `TaskInstance` with
column `pool` that is initially Nullable (when the table is created).
Later, an index named `ti_pool` on a few columns, including `pool` column in
table `TaskInstance`.
Then, airflow will try to alter table `TaskInstance` and change the column
`pool` to `NOT NULL`.
This does not work on Microsoft SQL Server since a column with an index defined
on it cannot be changed, unless the index is deleted before.
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
