[
https://issues.apache.org/jira/browse/AIRFLOW-3945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16798968#comment-16798968
]
ASF subversion and git services commented on AIRFLOW-3945:
----------------------------------------------------------
Commit fc987bb56aa9e58ae52da01bf9435d7779909c2d in airflow's branch
refs/heads/v1-10-stable from diederikwp
[ https://gitbox.apache.org/repos/asf?p=airflow.git;h=fc987bb ]
[AIRFLOW-3945] Stop inserting row when permission views unchanged (#4764)
- Stop inserting a row where only the id is not NULL in table
ab_permission_view_role when there are no permission views to update.
- Add a test for above issue
> Row of NULLs inserted when not changing permission views
> --------------------------------------------------------
>
> Key: AIRFLOW-3945
> URL: https://issues.apache.org/jira/browse/AIRFLOW-3945
> Project: Apache Airflow
> Issue Type: Bug
> Components: webserver
> Affects Versions: 1.10.2
> Reporter: Diederik Perdok
> Assignee: Diederik Perdok
> Priority: Minor
> Fix For: 1.10.3
>
>
> When creating new permission views in
> AirflowSecurityManager.create_custom_dag_permission_view in file
> airflow/www/security.py, the list of permission views to update might be
> empty because everything is still up to date. In that case, a row in which
> only the id is not NULL will still be inserted in table
> ab_permission_view_role every time.
> This is a minor bug when using PostgreSQL. When using a SQL Server backend,
> this causes the webserver to crash as SQL Server disallows multiple NULLs in
> a unique constraint (by default).
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
