https://bugs.documentfoundation.org/show_bug.cgi?id=173082

            Bug ID: 173082
           Summary: IMPORT: Creating a primary with import Wizard prevents
                    copying data from imported Table
           Product: LibreOffice
           Version: 26.8.0.0 alpha0+ master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 208036
  --> https://bugs.documentfoundation.org/attachment.cgi?id=208036&action=edit
Copy "tbl_Import". Insert "tbl_Import" and set "Create new field als primary
key".

Open the attached database.
Open the attached PDF description.

Copy table "tbl_Import" and insert this table.

Table name shouldn't be "tbl_Import". So a new table will be created.
Choose "Create new field as primary key".
All other steps could be ignored.
Now "Create".
An Error appears: "Invalid column type index"

The table will be created, but no content will be inserted.
Seems the new field will be set as first field, but import wizard tries to
insert the content from the imported table in this field. The first field
should be ignored for importing values from the imported table if "Create new
field as primary key" has been choosen.

Bug appears with internal Firebird, internal HSQLDB.
Bug appears when only copying a table without primary key (see attachment) or
when copying a table from Calc.

Bug appears in
Version: 26.8.0.2 (X86_64)
Build ID: 9bc445578031fecf56086729d8e4940c77e14d65
CPU threads: 6; OS: Linux 6.4; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded

but could be it never works well.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to