[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 rob...@familiegrosskopf.de changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=11 ||7090 -- 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
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 --- Comment #5 from rob...@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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 --- Comment #4 from Drew Jensen --- Created attachment 141456 --> https://bugs.documentfoundation.org/attachment.cgi?id=141456&action=edit test file with two views the attached file has the two views. With vEventCustomers the file will fail migration. Remove vEventCustomers and the file will migrate with vEventReservations included. -- 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
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 Drew Jensen changed: What|Removed |Added Status|RESOLVED|VERIFIED --- Comment #3 from Drew Jensen --- Verified with simple views. 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. This bug should be closed verified though. I've attached another test file. This one has two views: vEventReservations (simple view, migrates no problem) vEventCustomers (this view uses the CONCAT function and fails to migrate) -- 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
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 Tamas Bunth changed: What|Removed |Added Status|NEW |RESOLVED Resolution|--- |FIXED -- 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
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 Commit Notification changed: What|Removed |Added Whiteboard||target:6.1.0 -- 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
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 --- Comment #2 from Commit Notification --- Tamas Bunth committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=098b84ff26212d5bee30f16848fac90d061e8b14 tdf#116954 dbahsql: migrate views too It will be available in 6.1.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. -- 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
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 Lionel Elie Mamane changed: What|Removed |Added Blocks|51780 | Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=51780 [Bug 51780] [META] Default to Firebird not HSQLDB in Base -- 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
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 Lionel Elie Mamane changed: What|Removed |Added Blocks||116968 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=116968 [Bug 116968] (Database-Firebird-Migration) - [META] Migrating existing embedded HSQLDB databases to Firebird -- 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
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 V Stuart Foote changed: What|Removed |Added CC||vstuart.fo...@utsa.edu Blocks||51780 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=51780 [Bug 51780] [META] Default to Firebird not HSQLDB in Base -- 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
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 Alex Thurgood changed: What|Removed |Added Priority|medium |high Severity|normal |major -- 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
[Libreoffice-bugs] [Bug 116954] EDITING: firebird: migration: View definitions are lost on conversion from embedded hsql files
https://bugs.documentfoundation.org/show_bug.cgi?id=116954 rob...@familiegrosskopf.de changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||rob...@familiegrosskopf.de Ever confirmed|0 |1 --- Comment #1 from rob...@familiegrosskopf.de --- Could confirm the buggy behavior. View hasn't been created by the automatic migration from HSQLDB to Firebird with Version: 6.1.0.0.alpha0+ Build-ID: dc823f5fa4a5d2eca56297b9045e5962536c00f9 CPU-Threads: 4; BS: Linux 4.4; UI-Render: Standard; VCL: kde4; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-04-10_23:32:35 Tested with OpenSUSE 42.3 64bit rpm Linux -- 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