https://bugs.documentfoundation.org/show_bug.cgi?id=168012
Bug ID: 168012
Summary: FIREBIRD: Fieldposition totally destroyed when copying
table with many fields
Product: LibreOffice
Version: 25.8.0.0 alpha0+
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 202381
--> https://bugs.documentfoundation.org/attachment.cgi?id=202381&action=edit
Copy table "tbl_Rechnung" to Calc. Then open "tbl_Rechnung". Have a look at the
fields in both tables.
Open the attached database.
Right mouse click of one of the tables, example "tbl_Rechnung".
Copy table.
Open an empty Calc document.
Insert content.
Fields will be shown with following order:
"MailVersendet", "ID", "Kunde_ID", "Mitarbeiter_ID", "Datum" …
but the content, which will be shown in the columns differ:
"Datum" is shown in column "Mitarbeiter_ID", "ID" is shown in "MailVersendet" …
Open the same table with left mouse click in Base. It will show the right order
of fields and the right entries.
You could see the wrong fieldposition also when opening the table for editing,
not for input data. "MailVersendet" will be shown as first field.
Now execute the query "qry_Fieldposition_tbl_Rechnung". Will show the saved
position in the database. This position is used when opening the table for
input data.
Same behavior in "tbl_Firma", where the field for the first position ("ID",
position 0) will be shown in position near '50'!
This only happens for tables with many fields like 32 fields for
"tbl_Rechnung".
Don't know if this bug also appears with internal HSQLDB. Have first seen this
in internal Firebird.
This bug will be a nightmare for people, who want to copy tables from one
database to another.
Appears under
Version: 25.8.0.4 (X86_64)
Build ID: 48f00303701489684e67c38c28aff00cd5929e67
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded
but also older version.
Have seen this also when helping other people through videocall copying data
from one database to another
--
You are receiving this mail because:
You are the assignee for the bug.
