c2c-oerpscenario team mailing list archive

[Stéphane Bidoul <870099@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

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

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

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