[
https://issues.apache.org/jira/browse/AIRFLOW-3945?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16799100#comment-16799100
]
ASF subversion and git services commented on AIRFLOW-3945:
----------------------------------------------------------
Commit e7f96860f4d8ca72ccc1a47d223f310b938d7a31 in airflow's branch
refs/heads/v1-10-stable from diederikwp
[ https://gitbox.apache.org/repos/asf?p=airflow.git;h=e7f9686 ]
[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)
