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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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=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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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

[bugzilla-daemon]

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