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

Hi,

Despite this bug being marked as closed, I still get the following error message when opening an oldish LibreOffice Base file in LibreOffice 6.3.0.4 (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?

Thanks!

R.

Hello,

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.

It will changed for Firebird 4. Increase maximum length of object names to 63 characters

Hi,

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?

Cheers!

R.

but then the error message might deserve some attention

Addressed in https://gerrit.libreoffice.org/80017; if you would file it as a bug, I’d be glad do mention that bug in the commit summary