c2c-oerpscenario team mailing list archive

["Daniel Watkins \(credativ\)" <677509@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

For an act_window definition, we have the following domain set:
  domain=[('unallocated_products', '!=', '0')]

This works fine.  However, if we have:
  domain=[('unallocated_products', '!=', 0)]
(i.e. without the quotes around 0) then we end up with qu1 and qu2 in the search() method on osv.orm containining
  ((1=1)  AND  (made_batches_batch.stock_move_id in (%s,%s,%s,%s,%s,%s,%s,%s))) AND (made_batches_batch.unallocated_products != %s)
and
  [43, 46, 49, 50, 51, 52, 53, 101, None]

This will produce a WHERE clause including
"(made_batches_batch.unallocated_products != None".  Needless to say,
this meant that nothing was working as expected, and should be fixed.

** Affects: openobject-server
     Importance: Undecided
         Status: New

-- 
Unquoted 0 in domain is converted to None when generating SQL
https://bugs.launchpad.net/bugs/677509
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Server: New

Bug description:
For an act_window definition, we have the following domain set:
  domain=[('unallocated_products', '!=', '0')]

This works fine.  However, if we have:
  domain=[('unallocated_products', '!=', 0)]
(i.e. without the quotes around 0) then we end up with qu1 and qu2 in the search() method on osv.orm containining
  ((1=1)  AND  (made_batches_batch.stock_move_id in (%s,%s,%s,%s,%s,%s,%s,%s))) AND (made_batches_batch.unallocated_products != %s)
and
  [43, 46, 49, 50, 51, 52, 53, 101, None]

This will produce a WHERE clause including "(made_batches_batch.unallocated_products != None".  Needless to say, this meant that nothing was working as expected, and should be fixed.