https://bugs.freedesktop.org/show_bug.cgi?id=46179
Bug #: 46179
Summary: EDITING: Regression since LO 3.3 - COUNT(*) doesn't
work in Base connected to dBASE documents if there's
WHERE statements in SQL query
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 Release
Platform: x86-64 (AMD64)
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 57165
--> https://bugs.freedesktop.org/attachment.cgi?id=57165
The example of odb and dbf files. In odb-file "Query_works" exectues OK but
"Query_bug" fails.
If the SQL query in odb-file which is connected to dBASE database contains
"SELECT COUNT(*)" and "WHERE" statement, it fails to execute. The query this the
same "WHERE" part but with "SELECT *" works OK.
I add an attachment with odb and dbf files. The odb file is a LO Base connetion
to dbf file. The odb file contains 2 queries: "Query_works" and "Query_bug".
The "Query_works" contains "SELECT *" and the "Query_bug" contains "SELECT
COUNT(*)". The rest part of queries is the same. "Query_works" executes OK but
"Query_bug" fails.
It's a regression since LO 3.3. I've checked on LO 3.4.5 and had the same bug
as in LO 3.5.0
OS: OpenSUSE 12.1 64 bit.
LibreOffice is installed from rpm downloaded from official LO site.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
