c2c-oerpscenario team mailing list archive

["Bharat Devnani \(Open ERP\)" <870099@xxxxxxxxxxxxxxxxxx>]

Hello Stéphane Bidoul,

Thanks for reply and your contribution, we have found that the order of
columns are not preserved with UNION,  the solution of this bug will be
merged in main addons soon. Following are Revision ID and Revision
Number of the proposed branch :

Revision ID : bde@xxxxxxxxxxx-20111018133315-attph5jtw8adh4ww
Revision Number : 5391

Thanks & Regards, 
Devnani Bharat R.

** Changed in: openobject-addons
       Status: In Progress => Fix Committed

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to OpenERP Project Group.
https://bugs.launchpad.net/bugs/870099

Title:
  accounting report filter: period start and end are sometimes swapped

Status in OpenERP Addons (modules):
  Fix Committed

Bug description:
  In the accounting reports wizard, when the Period filter is selected,
  *sometimes* the start and end period are inverted.

  This bug is due to the UNION statement in the query, which attempts to
  eliminate duplicates and does not preserve order (see
  http://www.postgresql.org/docs/8.4/interactive/queries-union.html).

  Using UNION ALL instead solves the problem.

  Patch attached.

  Best regards,

  -sbi

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/870099/+subscriptions