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

Reply via email to