Created attachment 149696 [details]
Assign Columns dialog
I usually populate my HSQLDB table by copying data from a Calc table. I do so by selecting Paste > Append data. I haven't had any problems with this until updating the LibreOffice to the latest version (184.108.40.206).
In Assign Columns dialog, the field values from source table show up truncated. The assignment works fine, though.
Created attachment 149697 [details]
Calc table sample
In previous versions of LibreOffice, it would have showed this:
FOOBAR FOOBAR FOOBAR FOOBAR
Created attachment 149699 [details]
Example-database and Calc file to try the import of data
Can't confirm the buggy behaviour with LO 220.127.116.11 on OpenSUSE 15 64bit rpm Linux. The values of the first row are shown in the import-wizard here.
With database of Robert, If I accept to migrate to Firebird embedded I encounter the problem described in bug 123591 : "Seems Base/Firebird doesn't recognize the decimalseparator from the Calc-import-file".
If I don't accept to migrate, I obtain this error message when I try to open database :
Impossible d'établir la connexion à la source de données "import".
file input/output error: C:\Users\bernard\Desktop\import.odb.log
(In reply to ribotb from comment #4)
> With database of Robert, If I accept to migrate to Firebird embedded I
> encounter the problem described in bug 123591 : "Seems Base/Firebird doesn't
> recognize the decimalseparator from the Calc-import-file".
Please don't mix this with Firebird bugs. It is reported as HSQLDB bug. The migration dialogue would only appear with experimental functions switched to 'on'.
Set this off and try it with the original database again. You have to mark the content of Calc table, copy this and then directly insert this content to Base table.
Tried the example (HSQLDB embedded database) provided by Robert and it works OK.
However, I am using 'split' database mode (sorry for not mentioning that above). I will create a new example database and see if the problem persists.
I'll report back ASAP.
Created attachment 149722 [details]
Yep.. the problem appears to be related to the split database mode.
When using it, the values of the first row truncate and/or show wrongly.
Using an embedded HSQLDB database, the issue won't occur.
(In reply to Robert Großkopf from comment #5)
> (In reply to ribotb from comment #4)
> > With database of Robert, If I accept to migrate to Firebird embedded I
> > encounter the problem described in bug 123591 : "Seems Base/Firebird doesn't
> > recognize the decimalseparator from the Calc-import-file".
> Please don't mix this with Firebird bugs. It is reported as HSQLDB bug. The
> migration dialogue would only appear with experimental functions switched to
@lnwalker : the problem is that there aren't many people in Base-QA using split-mode hsqldb - I dont' have any on macOS because pointing to a separate hsqldb.jar has had various nefarious consequences in the past including not being able to open normal previously created embedded hsqldb files, to the point where I no longer test such a db configuration.