https://bugs.freedesktop.org/show_bug.cgi?id=70506
Priority: medium
Bug ID: 70506
Assignee: [email protected]
Summary: EDITING: Embedded Firebird - Alias in queries are
ignored
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: 4.2.0.0.alpha0+ Master
Component: Database
Product: LibreOffice
Open an internal Firebird database. Edit a new query. Try to chose an alias for
one field. The alias would be ignored - the old name of the field will appear.
It's a special problem when you try to use functions, which only work in the
direct SQL-mode:
SELECT "date", DATEADD(DAY,'5',"date") AS "date_new" FROM "table"
In such a query there isn't shown any name for the field, which shows the added
date. The fieldname will be empty.
Take https://bugs.freedesktop.org/attachment.cgi?id=87557 for testing.
Same works with the internal database in the same version of LO.
Same works with the external Firebird database in LO 4.1.1.
--
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
