Comment 11 for bug 1968343

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to neutron (stable/wallaby)

Reviewed: https://review.opendev.org/c/openstack/neutron/+/837330
Committed: https://opendev.org/openstack/neutron/commit/5598510c80b4accb97ed7fc62f63ee400e4237ec
Submitter: "Zuul (22348)"
Branch: stable/wallaby

commit 5598510c80b4accb97ed7fc62f63ee400e4237ec
Author: Andrew Karpow <email address hidden>
Date: Fri Apr 8 18:32:03 2022 +0200

    Force security_group_id uuid validation of sg rules

    security_groups_db._check_security_group is supposed to check the
    security_group_id of the _create_security_group_rule payload.
    When using an integer e.g. 0, as security_group_id, the check
    succededs because mysql accepts following query:

    SELECT * FROM securitygroups WHERE id in (0)

    Forcing validation of security_group_id as uuid fixes the problem

    Closes-Bug: #1968343
    Change-Id: I7c36b09309c1ef66608afacfb281b6f4b06ea5b8
    (cherry picked from commit c0bf560fa36aac798ad8783749fa78ddf766bdec)