Search on many2many with negative operator gives wrong results
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Odoo Server (MOVED TO GITHUB) |
New
|
Medium
|
OpenERP's Framework R&D | ||
Therp Backports (Deprecated) |
In Progress
|
Medium
|
Stefan Rijnhart (Opener) |
Bug Description
When you have a category X and assigned it to one or more partners, it is currently impossible to search for partners that do not have this category.
Steps to reproduce
===============
On a new database,
Create partner A
Create partner B
Create partner C
Create partner AB
Create category A
Create category B
Assign category A to partner A
Assign category B to partner B
Assign both categories A and B to partner AB
Do not assign any categories to partner C
Now search for partner with advanced filter on category 'not equal to' A
Expected results
=============
All partners that are not assigned category A (i.e. partners B and C)
Actual results
===========
All partners that are assigned any category other than A, including partners that also have category A (i.e. partners B and AB)
Related branches
- OpenERP Core Team: Pending requested
-
Diff: 120 lines (+30/-26)2 files modifiedopenerp/addons/base/tests/test_expression.py (+6/-0)
openerp/osv/expression.py (+24/-26)
- Therp: Pending requested
-
Diff: 102 lines (+24/-25)1 file modifiedopenerp/osv/expression.py (+24/-25)
Changed in openobject-server: | |
assignee: | nobody → OpenERP's Framework R&D (openerp-dev-framework) |
importance: | Undecided → Medium |
status: | New → Confirmed |
Changed in therp-backports: | |
assignee: | nobody → Stefan Rijnhart (Therp) (stefan-therp) |
importance: | Undecided → Critical |
importance: | Critical → Medium |
status: | New → Triaged |
milestone: | none → 6.1-maintenance |
Changed in therp-backports: | |
milestone: | 6.1-maintenance → 7.0-maintenance |
Changed in therp-backports: | |
status: | Triaged → Fix Committed |
Changed in therp-backports: | |
status: | Fix Committed → In Progress |
Hi,
I've added some tests, visible in this branch lp:~openerp-dev/openobject-server/trunk-in-not-in-m2m-tests-vmt.
I think I have covered the case you give in this bug report. I can't reproduce your situation.
If you think there is still a problem, please add a test case to examplify it and re-open the bug report (I will close it now).