IMHO,Stringifying None and then expecting the *string* to match NULL is wrong.
Could we check to see if `filters[filter_name]` is None and deal with that case separately
(i.e `if filters[filter_name] is None:
filter = column_is_null_check
else:
filter = column_attr.op(db_regexp_op)(
str(filters[filter_name]))`)?
Best Regards,
Solly Ross
----- Original Message -----
From: "Chris Friesen" <chris.friesen at windriver.com>
To: "OpenStack Development Mailing List (not for usage questions)" <openstack-dev at lists.openstack.org>
Sent: Monday, March 31, 2014 10:57:04 AM
Subject: Re: [openstack-dev] [nova] [bug] unit tests sqlite regexp() function doesn't behave like mysql
On 03/31/2014 08:54 AM, Chris Friesen wrote:
>
> I mentioned this last week in another thread but I suspect it got lost.
I forgot to mention...I've opened this as a bug
(https://bugs.launchpad.net/nova/+bug/1298690) but I wanted to get some
wider suggestions as to the proper way to deal with it.
Chris
_______________________________________________
OpenStack-dev mailing list
OpenStack-dev at lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-dev