[jira] [Commented] (AIRFLOW-6185) SQLAlchemy Connection model schema not aligned with Alembic schema

["Xinbin Huang (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/AIRFLOW-6185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16989289#comment-16989289 ] 

Xinbin Huang commented on AIRFLOW-6185:
---------------------------------------

After some digging, the current migration script does not detect column changes with `COMPARE_TYPE = FALSE` in the env.py

> SQLAlchemy Connection model schema not aligned with Alembic schema
> ------------------------------------------------------------------
>
>                 Key: AIRFLOW-6185
>                 URL: https://issues.apache.org/jira/browse/AIRFLOW-6185
>             Project: Apache Airflow
>          Issue Type: Bug
>          Components: database
>    Affects Versions: 1.10.6
>            Reporter: Xinbin Huang
>            Priority: Blocker
>         Attachments: connection_schema.PNG
>
>
> The SQLAlchemy model for the `Connection` table declare password as `String(5000)` while Alembic migration script (i.e. `current_schema.py`) declare password as `String(length=500)`, and the final table schema for password is varchar(500)
>  * Alembic schema: [https://github.com/apache/airflow/blob/ce873afc22efee171a320344b5cbee657018aed0/airflow/migrations/versions/e3a246e0dc1_current_schema.py#L54]
>  * models/connections.py
>  [https://github.com/apache/airflow/blob/ce873afc22efee171a320344b5cbee657018aed0/airflow/models/connection.py#L62]



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