test_list_servers_filtered_by_name_regex fails with DB2

Bug #1383325 reported by Matt Riedemann
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack Compute (nova)
Won't Fix
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.

Tags: db db2
Revision history for this message
Matt Riedemann (mriedem) wrote :

We can track this against the blueprint db2-database.

Changed in nova:
status: New → Triaged
importance: Undecided → Low
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to nova (master)

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

Changed in nova:
assignee: nobody → Qin Zhao (zhaoqin)
status: Triaged → In Progress
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Change abandoned on nova (master)

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.

Revision history for this message
Davanum Srinivas (DIMS) (dims-v) wrote :

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
Revision history for this message
jichenjc (jichenjc) wrote :

DB2 is removed

Changed in nova:
status: Confirmed → Won't Fix
Revision history for this message
OpenStack Infra (hudson-openstack) wrote :

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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.