test_list_servers_filtered_by_name_regex fails with DB2

Bug #1383325 reported by Matt Riedemann on 2014-10-20
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
Low
Unassigned

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.

Matt Riedemann (mriedem) wrote :

We can track this against the blueprint db2-database.

Changed in nova:
status: New → Triaged
importance: Undecided → Low

Fix proposed to branch: master
Review: https://review.openstack.org/130174

Changed in nova:
assignee: nobody → Qin Zhao (zhaoqin)
status: Triaged → In Progress

Change abandoned by Sean Dague (<email address hidden>) on branch: master
Review: https://review.openstack.org/130174
Reason: This review is > 4 weeks without comment, and failed Jenkins the last time it was checked. We are abandoning this for now. Feel free to reactivate the review by pressing the restore button and leaving a 'recheck' comment to get fresh test results.

Removing "In Progress" status and assignee as change is abandoned.

Changed in nova:
status: In Progress → Confirmed
assignee: Qin Zhao (zhaoqin) → nobody
Changed in nova:
assignee: nobody → Man Li Qi (qimanli)
status: Confirmed → In Progress
Changed in nova:
assignee: Man Li Qi (qimanli) → Qin Zhao (zhaoqin)
Changed in nova:
assignee: Qin Zhao (zhaoqin) → nobody
status: In Progress → Confirmed
jichenjc (jichenjc) wrote :

DB2 is removed

Changed in nova:
status: Confirmed → Won't Fix

Change abandoned by Michael Still (<email address hidden>) on branch: master
Review: https://review.openstack.org/130174
Reason: This patch is quite old, so I am abandoning it to keep the review queue manageable. Feel free to restore the change if you're still interested in working on it.

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers