https://bugs.documentfoundation.org/show_bug.cgi?id=117090
Bug ID: 117090
Summary: EDITING: firebird: migration: View definitions are
lost from embedded hsql files with unknown functions
Product: LibreOffice
Version: 6.1.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: rob...@familiegrosskopf.de
Download https://bugs.documentfoundation.org/attachment.cgi?id=141456
Open the attached database with 6.1.0.0.alpha0
Try to migrate the database to Firebird.
Migration fails, because Firebird doesn't know anything about the function
CONCAT.
If you save the data after migrating the code for the view is lost.
There are different possibilities to change this behavior:
→ Views, which fail in Firebird, should be saved as queries. So the code isn't
lost.
This is the simplest version.
→ Views with functions, that aren't defined with that specific name in
Firebird, but will work with functions of Firebird the same way, should be
"translated" to the new functions:
CONCAT doesn't work. || will work.
LCASE doesn't work. LOWER will work.
...
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs