https://bugs.freedesktop.org/show_bug.cgi?id=45249
Bug #: 45249
Summary: EDITING postgreSQL-SDBC No functions available in
Query Designers
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.0 RC2
Platform: x86-64 (AMD64)
OS/Version: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Database
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 56164
--> https://bugs.freedesktop.org/attachment.cgi?id=56164
screen shot of query designer
Test system: Ubuntu 11.04 AMD64, Gnome, PostGres 8.4 (localhost), 9.1 (remote)
Open an ODB connecting to the psql server.
Create new query in designer view
Select a field
Select Functions - empty list.
The query parser is recognizing the functions; create a query in text view, but
NOT using SQLdirect [tested simple stuff, sum, count, avg] and it runs
correctly, if switched back to design view the funtions are displayed correctly
in the desinger view and are not removed when saved - so it appears to be the
drop down control w/empty list as the culprit here.
In the screen shot the test query was entered as:
SELECT COUNT( * ) FROM "public"."Master" AS "Master" WHERE "birthState" IN (
'CA', 'NC' )
Then switched back to design view, you can see it picks up the count function.
Added another column just to show what the function drop list displays.
--
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
