c2c-oerpscenario team mailing list archive

["Jignesh Rathod\(OpenERP\)" <870099@xxxxxxxxxxxxxxxxxx>]

Hello Stéphane Bidoul ,

I am confirming this issue as per postgresql documentation.

Thank you.

** Changed in: openobject-addons
   Importance: Undecided => Low

** Changed in: openobject-addons
       Status: New => Confirmed

** Changed in: openobject-addons
     Assignee: (unassigned) => OpenERP R&D Addons Team 3 (openerp-dev-addons3)

-- 
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):
  Confirmed

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