[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-10-31 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #40 from Julien Nabet --- (In reply to Buovjaga from comment #39) > I had a chat with Alex about slide 28 of this: > https://firebirdsql.org/file/community/conference-2019/ > 1_firebird_on_the_road_from4_to_5.pdf > > "Longer

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-10-31 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 Buovjaga changed: What|Removed |Added CC||todven...@suomi24.fi --- Comment #39

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #38 from Lionel Elie Mamane --- And before anybody says SQLite, it does not have SQL-style static typing (it does dynamic typing), has no true date datatype (and column type; the ODBC driver kindof does its own implementation

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #37 from Julien Nabet --- (In reply to paul from comment #36) > Doing a solutions eval is non-trivial, especially for something like > databases. Have you evaluated all the non-commercial license compatible ones > here? (just

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #36 from p...@sonicviz.com --- Doing a solutions eval is non-trivial, especially for something like databases. Have you evaluated all the non-commercial license compatible ones here? (just a quick search, there could easily be

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #35 from Lionel Elie Mamane --- (In reply to paul from comment #17) > In that case maybe they shouldn't be using Firebird in the first place... Do you have a better alternative to propose? An embeddable non-Java license-compa

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #34 from p...@sonicviz.com --- No problem, I was just curious how you coordinate with Firebird dev that doesn't depend on you, but is critical to the operation of the platform once you go with it. >>IMHO, migration part shoul

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #33 from Julien Nabet --- Because Firebird dev doesn't depend on us so no need to keep a bugtracker opened for nothing. Moreover, as previously indicated, migration has been put back to experimental. IMHO, migration part shoul

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-13 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #32 from p...@sonicviz.com --- How can you mark it resolved when it's a critical system failure, even if it's not your bug? -- You are receiving this mail because: You are the assignee for the bug.

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 Alex Thurgood changed: What|Removed |Added Resolution|--- |NOTOURBUG Status|NEW

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #30 from Julien Nabet --- (In reply to Alex Thurgood from comment #29) > (In reply to Julien Nabet from comment #28) > > Nice testing work thanks ! :) > > Looks like we're stuck then. > > Any tables that have SUM(VARCHAR(N

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #29 from Alex Thurgood --- (In reply to Julien Nabet from comment #28) Nice testing work thanks ! :) Looks like we're stuck then. Any tables that have SUM(VARCHAR(N)) > 64K will fail with default UTF-8 encoding, and even i

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-12 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #28 from Julien Nabet --- Alex: I created a Firebird embedded database from scratch then just copied pasted the 'CREATE TABLE "Table1" ( "ID" IN... ' from initial comment in Tools/SQL part in order to be sure we don't call an

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #27 from Julien Nabet --- Alex: even if you create the table in several times, if row size is limited to 64k, you won't be able to put all the columns. About varchar, I think you're right, I suppose it's utf-8 which can be cod

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #26 from Alex Thurgood --- @Julien : the title reflects the symptoms of the bug, so I wouldn't want to change it unless there is a better way to describe that. The use of "chunk" in comment 23 is my layman's way of wondering

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 Julien Nabet changed: What|Removed |Added Status|RESOLVED|NEW Resolution|NOTOURBUG

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 Alex Thurgood changed: What|Removed |Added CC||lio...@mamane.lu --- Comment #24

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 --- Comment #23 from Alex Thurgood --- I love that we only find this out 3 years after deciding to go for FB as the default option... This page discussing UNIDAC would seem to indicate that the problem is more linked to our migration cod

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 Julien Nabet changed: What|Removed |Added Status|NEW |RESOLVED Resolution|---

[Libreoffice-bugs] [Bug 127040] HSQLDB to Firebird automated migration failure when record size exceeds 64k

2019-09-10 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=127040 Julien Nabet changed: What|Removed |Added Summary|HSQLDB to Firebird |HSQLDB to Firebird