https://bugs.documentfoundation.org/show_bug.cgi?id=153003
Bug ID: 153003
Summary: Copying a query and pasting as table in same database
impossible
Product: LibreOffice
Version: 7.4.4.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 184626
--> https://bugs.documentfoundation.org/attachment.cgi?id=184626&action=edit
Database for testing: Copy the query and try to insert as new table - error and
no content copied
Open the attached database file.
Switch to Queries, right mouse click on qry_Name → Copy
Switch to Tables, right mouse click under tbl_Name (hint: If tbl_Name has been
marked you would run in a already posted bug of the wizard)
There will appear a dialog "Copy table".
Table name is "qry_Name". Change it to "qry_Name1"
Options → Definitions and data is chosen.
Type 'Next' and take all existing columns from left to right.
Type 'Next and right mouse click on "ID". Chose "Primary key".
Type 'Create'.
An Error will appear. Type 'More' and the error details will give:
SQL Status: 07009
Internal error: invalid column type index. at
/home/buildslave/source/libo-core/connectivity/source/commontools/dbexception.cxx:462
Type 'OK' and try to continue ('Yes').
You have to type it two times (for every row of the query).
Table has been created without any content.
There is something going wrong with content of the columns of the query while
trying to insert. You could see this when trying to insert the content in
"tbl_Auto".
Copy query → Tables → mark tbl_Auto → right mouse click Insert
Option "append data" will be chosen → 'Next' → deselect "ID" in source Table
'continue' and the content will be pasted. But if you open the table tbl_Auto
the content form field "ID" will have been pasted to the field "Name".
This bug appears in LO 7.4.4.2, doesn't appear in LO 7.1.5.2 on OpenSUSE 15.3
64bit rpm Linux. So it's a regression.
--
You are receiving this mail because:
You are the assignee for the bug.
