Comment 18 for bug 1968343

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

Reviewed: https://review.opendev.org/c/openstack/neutron/+/837334
Committed: https://opendev.org/openstack/neutron/commit/f5fa74c5c6926eb46403f6b0b5e0bd81a90cf234
Submitter: "Zuul (22348)"
Branch: stable/train

commit f5fa74c5c6926eb46403f6b0b5e0bd81a90cf234
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)