On 03/31/2014 03:56 PM, Vishvananda Ishaya wrote:
On Mar 27, 2014, at 4:38 PM, Chris Friesen <chris.frie...@windriver.com> wrote:
On 03/27/2014 04:47 PM, Chris Friesen wrote:
Interestingly, unit test
nova.tests.api.openstack.compute.contrib.test_server_groups.ServerGroupTest.test_display_members
passes just fine, and it seems to be running the same sqlalchemy code.
Is this a case where sqlite behaves differently from mysql?
Sorry to keep replying to myself, but this might actually hit us other places.
Down in db/sqlalchemy/api.py we end up calling
query = query.filter(column_attr.op(db_regexp_op)('None’))
Sqlalchemy handles mapping None to NULL in many cases, so it appears that the
problem is that we are passing
None as a string here?
I think fundamentally it makes no sense to try and regex match a NULL
database field. So in instance_get_all_by_filters() if we want to test
for None it should be done separate from the regex filter.
Chris
_______________________________________________
OpenStack-dev mailing list
OpenStack-dev@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev
