Apache OpenOffice (AOO) Bugzilla – Issue 92117
(german:)Autofilter kann nicht mehr nach Boolean filtern
Last modified: 2010-02-22 14:43:49 UTC
Wenn man in einer Abfrage versucht, mit dem Autofilter nach einem Boolean Wert zu filtern, erhält man folgende Fehlermeldung: Fehler beim Setzen der Filter-Kriterien SQL-Status: HY000 Fehler-Code: 1000 Syntax error in SQL expression SELECT "ID", "Name", "ausgeschieden" FROM "Tabelle1" WHERE "Tabelle1"."ausgeschieden" = 1 = 1 syntax error, unexpected SQL_EQUAL, expecting $end Der Fehler besteht seit 2.4.1.
Created attachment 55398 [details] document to reproduce the bug case
(please note that the language of choice in IssueZilla is English. You will not always have the luck some German native speaker will first encounter your issue ...) English issue description: - open the attached database document - open the contained table by double-clicking it - in the table data view, move the cursor to the boolean column - press the "Auto Filter..." button in the toolbar => a message box pops up saying something about a syntax error
adding "regression" keyword - the scenario used to work in OOo 2.3.1, but not in OOo 2.4/.1. Targeting, correcting priority (http://www.openoffice.org/scdocs/ddIssues_EnterModify.html#priority)
fs->oj: please take this ...
Fixed in cws dba31c
*** Issue 93165 has been marked as a duplicate of this issue. ***
Please verify. Thanks.
verified in CWS dba31e find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba31e
This issue is closed automatically and wasn't rechecked in a current version of OOo. The fixed issue should be integrated in OOo since more than half a year. If you think this issue isn't fixed in a current version (OOo 3.1), please reopen it and change the field 'Target Milestone' accordingly. If you want to download a current version of OOo => http://download.openoffice.org/index.html If you want to know more about the handling of fixed/verified issues => http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues
Sorry this issue was wrongly closed. This issue will be reopened automatically. And will be set after that back to fixed/verified.
Set to state 'fixed'.
Set back to state 'verified/fixed'. Again. Sorry for the mass of mails.
This issue is closed automatically. It should be fixed in a version with is available for longer than half a year (OOo 3.1). If you think this issue isn't fixed in the current version (OOo 3.2) please reopen it. But then please pay attention about the field 'target milestone'. The closure was approved by the Release Status Meeting at 22nd of February 2010 and it is based on the issue handling guideline for fixed/verified issues : http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues