If DB2 uses LIKE then it sounds like it should work given the default in the code:
https://github.com/openstack/nova/blob/master/nova/db/sqlalchemy/api.py#L1932 ** Changed in: nova Status: New => Invalid ** Bug watch added: code.google.com/p/sqlalchemy-migrate/issues #151 http://code.google.com/p/sqlalchemy-migrate/issues/detail?id=151 -- 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/1217918 Title: List servers filtered by name wildcard failed for database do not support REGEXP Status in OpenStack Compute (Nova): Invalid Bug description: For non MySQL database(such as DB2 or others), try to list servers using filter and provide partial server name, it's failed! --- [root@localhost sqlalchemy]# nova list +--------------------------------------+---------+--------+------------+-------------+-------------------+ | ID | Name | Status | Task State | Power State | Networks | +--------------------------------------+---------+--------+------------+-------------+-------------------+ | 17ebc832-7947-40a1-9aeb-423bded822bd | fortest | ACTIVE | None | Running | network1=10.0.1.4 | | 7ca3b1f5-7a17-4217-92b0-4175ecfa3c94 | mabc%2 | ACTIVE | None | Running | network1=10.0.1.3 | +--------------------------------------+---------+--------+------------+-------------+-------------------+ [root@localhost sqlalchemy]# --- Try to list this server with below request. --- http://10.1.0.40:8774/v2/58e344d219b44eb8b16f40d0b78dace9/servers?name=m --- Response: --- { "servers": [] } --- But for MySQL database, it's worked. Request: --- http://10.1.0.40:8774/v2/58e344d219b44eb8b16f40d0b78dace9/servers?name=m --- reponse: --- { "servers": [ { "id": "7ca3b1f5-7a17-4217-92b0-4175ecfa3c94", "links": [ { "href": "http://10.1.0.40:8774/v2/58e344d219b44eb8b16f40d0b78dace9/servers/7ca3b1f5-7a17-4217-92b0-4175ecfa3c94";, "rel": "self" }, { "href": "http://10.1.0.40:8774/58e344d219b44eb8b16f40d0b78dace9/servers/7ca3b1f5-7a17-4217-92b0-4175ecfa3c94";, "rel": "bookmark" } ], "name": "mabc%2" } ] } --- To manage notifications about this bug go to: https://bugs.launchpad.net/nova/+bug/1217918/+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
