[Libreoffice-bugs] [Bug 116987] FIREBIRD : Migration : error on importing tables or queries with names longer than 30 characters

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #8 from Alex Thurgood <iplaw67 at tuta.io> ---
(In reply to Tamas Bunth from comment #7)
> A workaround would be to truncate table names with more than 30 characters.
> 


Not really a very satisfactory one though from a user perspective. The whole
point of being able to uniquely identify a table in hsqldb with a "long" file
name has clearly been used by DBAs and users alike. 

On the one hand, imposing a new form of table naming as you suggest isn't going
to go down well with those users unless there is a valid reason, which there
doesn't seem to be given that in FB4 that limitation will be lifted (but of
course when that might happen is a different matter).

On the other hand, one could submit that having table names in excess of 30
characters really isn't the way one should be managing a DB in the first place,
but that is a debate for another day.

Would it not be better to simply abort with a more meaningful message than is
currently offered, something along the lines of :

"Firebird 3 doesn't currently support table/query/view names of more than 30
characters, please shorten your table names in the original file and try
again."

-- 
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/20180426/25ba1c97/attachment.html>