[Libreoffice-bugs] [Bug 117090] New: EDITING: firebird: migration: View definitions are lost from embedded hsql files with unknown functions

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: robert at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180418/106bb98e/attachment-0001.html>