[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116954

--- Comment #5 from robert at familiegrosskopf.de ---
(In reply to Drew Jensen from comment #3)
> 
> Views that use hsqldb specific features fail, which fails the entire
> migration.
> 
> Not sure what could be done about that, other than having the users change
> the views before the migration. 
> 
> vEventCustomers (this view uses the CONCAT function and fails to migrate)

So the view definitions aren't completely migrated. We have to open another bug
for views, which will fail.

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/b9a8f599/attachment.html>