[
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)
