c2c-oerpscenario team mailing list archive

[Stéphane Bidoul <870099@xxxxxxxxxxxxxxxxxx>]

Hello,

I have tested by backporting the "p.special = false" line in the 6.0
code, and the inversion shown in my video is still there.

The problem is not in each individual SELECT but comes from the fact
that UNION does not garantee to return the result of the first SELECT
before the second, where UNION ALL does.

Best regards,

-sbi

-- 
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