[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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

[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