Reviewed: https://review.openstack.org/521683 Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=5c601bebeb01876f1ea744e0ae95f83d1c30120d Submitter: Zuul Branch: master
commit 5c601bebeb01876f1ea744e0ae95f83d1c30120d Author: Hongbin Lu <[email protected]> Date: Mon Nov 20 23:19:31 2017 +0000 Support filtering port with IP address substring Neutron currently supports filtering ports by matching the exact IP address. This patch adds support for substring matching using "LIKE" SQL operator. This patch also added a new API extension to show whether or not the substring matching capability is available. APIImpact add IP address substring filtering on listing ports API-ref: I97259b85a2dce5a54bb6ea2cb9d9779ec0a25504 Co-Authored-By: Zhenyu Zheng <[email protected]> Change-Id: I9549b2ba676e1bad0812682c3f3f3c97de15f5f6 Closes-Bug: #1718605 ** Changed in: neutron Status: In Progress => Fix Released -- You received this bug notification because you are a member of Yahoo! Engineering Team, which is subscribed to neutron. https://bugs.launchpad.net/bugs/1718605 Title: [RFE] Support sub-string matching when filtering port with IP address Status in neutron: Fix Released Bug description: Problem ======= The GET /ports API only support exact matching when filtering by IP address. Providing support for more powerful regex matching filtering could be very useful. Usecase ======= Nova allows filtering instance by IP address and it is in regex matching manner, but it now has serious performance issue [1]. How to enhance the performance of this filter has been discussed in Queens PTG [2]. When filtering instance by IP addresses, first calling Neutron port list API with IP address filtering, and then retrieve the instance UUID in Nova side could be a possible solution to improve the performance. As Nova allows regex manner filtering, it could be better to make Neutron also support regex matching. Proposal ======== Adding regex matching support in DB layer using "LIKE" SQL phrase. References ========== [1] https://bugs.launchpad.net/nova/+bug/1711303 [2] http://lists.openstack.org/pipermail/openstack-dev/2017-September/122258.html To manage notifications about this bug go to: https://bugs.launchpad.net/neutron/+bug/1718605/+subscriptions -- Mailing list: https://launchpad.net/~yahoo-eng-team Post to : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
