sqlite regexp() function doesn't behave like mysql
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack Compute (nova) |
Won't Fix
|
Low
|
Unassigned | ||
Icehouse |
Won't Fix
|
Low
|
Unassigned |
Bug Description
In bug 1298494 I recently saw a case where the unit tests (using sqlite) behaved differently than devstack with mysql.
The issue seems to be when we do
filters = {'uuid': group.members, 'deleted_at': None}
instances = instance_
Eventually down in db/sqlalchemy/
query = query.filter(
where str(filters[
When using mysql, a regexp comparison of the string 'None' against a NULL field fails to match.
Since sqlite doesn't have its own regexp function we provide one in openstack/
This is a bug, we want the unit tests to behave like the real system.
tags: | added: compute db |
tags: | removed: compute |
Changed in nova: | |
importance: | Undecided → Medium |
status: | New → Confirmed |
Changed in nova: | |
status: | Confirmed → Won't Fix |
If this is "fix released" in icehouse, could someone point to the patch that fixed it?