Bug 33194 - RPT: filter "IS NOT NULL" becomes "IS NULL"
Summary: RPT: filter "IS NOT NULL" becomes "IS NULL"
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-16 15:10 UTC by Lionel Elie Mamane
Modified: 2012-10-08 17:05 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Lionel Elie Mamane 2011-01-16 15:10:17 UTC
Edit a report.
In the report's data properties, set a filter on some_column "NOT NULL", e.g. through the graphical interface.

The generated SQL condition snippet is correct, and shows: (some_column IS NOT NULL).

Click the "..." next to the filter to edit the filter through the graphical interface. It shows some_column NULL, instead of "NOT NULL". If one presses OK, the generated SQL condition snippet becomes: (some_column IS NULL).

Expected behaviour: filter stays the same, i.e. "some_column IS NOT NULL".
Comment 1 Björn Michaelsen 2011-12-23 11:46:50 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 2 Lionel Elie Mamane 2012-07-11 13:01:18 UTC
Cannot reproduce on branch features/base-preview, which means it is fixed in 3.5.6, or maybe only 3.6.0.

My guess is that is fixed far earlier, though.
Comment 3 Alex Thurgood 2012-10-08 17:05:07 UTC
*** Bug 55703 has been marked as a duplicate of this bug. ***