← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1264579] [NEW] Don't execute SQLAlchemy in_ expression when argument is an empty sequence

 

Public bug reported:

Noticed the following warning when running unit tests:

SAWarning: The IN-predicate on "cisco_n1kv_profile_bindings.profile_id" was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate.  Consider alternative strategies for improved performance.
  return self._in_impl(operators.in_op, operators.notin_op, other)

The Neutron code should be scanned to look for places where in_ is being
used and ensure that a short-circuit is made in those methods to verify
that the input is not an empty sequence.

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: low-hanging-fruit

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1264579

Title:
  Don't execute SQLAlchemy in_ expression when argument is an empty
  sequence

Status in OpenStack Neutron (virtual network service):
  New

Bug description:
  Noticed the following warning when running unit tests:

  SAWarning: The IN-predicate on "cisco_n1kv_profile_bindings.profile_id" was invoked with an empty sequence. This results in a contradiction, which nonetheless can be expensive to evaluate.  Consider alternative strategies for improved performance.
    return self._in_impl(operators.in_op, operators.notin_op, other)

  The Neutron code should be scanned to look for places where in_ is
  being used and ensure that a short-circuit is made in those methods to
  verify that the input is not an empty sequence.

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1264579/+subscriptions


Follow ups

References