Created attachment 128116 [details]
When I copy a table from an HSQLDB file to a table with the same definition in a Firebird DB file, it fails. The same when I try to past selection from Calc into that DB table.
Right-click the table in the one file, select Copy, right-click the table in the Firebird DB file, and select Paste. Chose Append Data.
SQL Status: HY004
Incorrect type for setString
If you manage to paste multiple lines from Calc, it actually stores the first line and messes up the ID (first row, primary index). See the attached files.
Created attachment 128117 [details]
Expected behavior is that it would paste all data to the destination file correctly. All data must be the same on the destination afterwards (ID, date, text).
Could confirm the buggy behavior. It's like https://bugs.documentfoundation.org/show_bug.cgi?id=70425 , but there seems to be also a problem with dates. "SetString" must be wrong for Integer and for Date.
Build ID: e7324c5705eaa38a2c9aa0636f01a73f033ba4d6
CPU Threads: 4; OS Version: Linux 4.1; UI Render: default; VCL: kde4;
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2016-10-20_06:12:58
Locale: de-DE (de_DE.UTF-8); Calc: group