yahoo-eng-team team mailing list archive

[Matt Riedemann <mriedem@xxxxxxxxxx>]

Public bug reported:

The test_list_servers_filtered_by_name_regex test added here:

https://review.openstack.org/#/c/119081/

Doesn't work with DB2 since DB2 doesn't support querying with a regex
like MySQL or PostgreSQL.

DB2 uses the LIKE predicate for pattern queries:

http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.1.0/com.ibm.db2.udb.admin.doc/doc/r0000751.htm

So either we'd have to make that work somehow, or just get the full
results back from the DB2 query and then apply the pattern on the result
set in the nova python code, which is ugly but would satisfy the
filtering requirement for the nova API.

** Affects: nova
     Importance: Low
         Status: Triaged


** Tags: db db2

** Changed in: nova
       Status: New => Triaged

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1383325

Title:
  test_list_servers_filtered_by_name_regex fails with DB2

Status in OpenStack Compute (Nova):
  Triaged

Bug description:
  The test_list_servers_filtered_by_name_regex test added here:

  https://review.openstack.org/#/c/119081/

  Doesn't work with DB2 since DB2 doesn't support querying with a regex
  like MySQL or PostgreSQL.

  DB2 uses the LIKE predicate for pattern queries:

  http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.1.0/com.ibm.db2.udb.admin.doc/doc/r0000751.htm

  So either we'd have to make that work somehow, or just get the full
  results back from the DB2 query and then apply the pattern on the
  result set in the nova python code, which is ugly but would satisfy
  the filtering requirement for the nova API.

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