https://bugs.freedesktop.org/show_bug.cgi?id=62294
Priority: medium
Bug ID: 62294
Assignee: [email protected]
Summary: UI: Queries showing fields as "empty" when holding
data
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.1.2 release
Component: Database
Product: LibreOffice
Problem description:
I am using the query designer LibreOffice Base as a frontend to create and run
queries against a PostgreSQL database.
Results are shown as expected, except when adding criterias to TIME or DATE
fields, in this case these fields are shown as "empty", which they are not.
If the query is saved in LibreOffice Base and then exported to other programs
(e.g. Writer og Calc) all values are intact, so the error is only present when
viewing the query result in the result pane inside Base.
Steps to reproduce:
1. Connect Base to a PostgreSQL database
2. Create a query against a table having DATE or TIME fields
3. Run the query: Everything is fine
4. Add a criteria to a field of TIME type (e.g. equal to '08:00')
5. Re-run the query. Now the field holding the TIME values seems empty
6. Save the query and close the query designer
7. Right-click the saved query and select "Copy"
8. Open a new spreadsheet in Calc and paste the query
9. Now all values are displayed as they should be - the TIME values are not
empty anymore.
I do not know if the problem is specific to a PostgreSQL connection since I
only have PostgreSQL databases available.
Operating System: Windows 7
Version: 4.0.1.2 release
--
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
