Ask Your Question

Firebird 3 doesn't currently support table names of more than 30 characters

asked 2019-10-01 14:27:39 +0100

mrgou gravatar image


Despite this bug being marked as closed, I still get the following error message when opening an oldish LibreOffice Base file in LibreOffice (x64) on Windows.

SQL Status: HY000

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

The problem is: none of my tables or queries have names exceeding 20 characters...

Is this still a bug or am I missing something?



edit retag flag offensive close merge delete



Is this occurring when converting from HSQLDB? Can't seem to generate the error in Linux v6.3.2.2. Can you provide a scrubbed sample?

Also you do not absolutely need to convert. In latest version, convert message only occurs when Experimental Features is turned on. Default has returned to HSQLDB.

Ratslinger gravatar imageRatslinger ( 2019-10-01 18:38:16 +0100 )edit
m.a.riosv gravatar imagem.a.riosv ( 2019-10-02 13:50:15 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-10-02 11:04:06 +0100

mrgou gravatar image


I think I got it: it's not the only table whose name can't exceed 30 characters, but also the columns.

Maybe that's also part of the same Firebird limitation (which is blocking for me), but then the error message might deserve some attention.

When copying and pasting the table definition to a new Firebird database, the column name gets truncated.

Is this worth reporting as a bug?



edit flag offensive delete link more


but then the error message might deserve some attention

Addressed in; if you would file it as a bug, I'd be glad do mention that bug in the commit summary

Mike Kaganski gravatar imageMike Kaganski ( 2019-10-02 12:20:36 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-10-01 14:27:39 +0100

Seen: 50 times

Last updated: Oct 02 '19