Created attachment 178035 [details] Description of the table import wizard (with screenshots) Hope this bug is right placed in UI. Open a database. Copy a table. Right mouse click → Paste Dialog appears Change → "Table name:" to a name for a new table. You could switch between • Definition and data • Definition • As table view • Append data (Old Bug: This isn't possible, because the table doesn't exist) You couldn't choose "Create new field as primary key" (New Bug: This must be possible for new tables, because you couldn't add data to a table without primary key. Behavior is the same when importing tables from Calc, and the data in Calc won't be identified by a unique field.) Choose any option. Only together with "As table view" "Create new field as primary key" will be available. New Bug: Table views aren't writable at all. A primary key couldn't be added to a view, because a view is a query, which is saved in database directly. So this won't be executed and no new field would be added to the created view. This buggy behavior first appears in Version: 7.2.0.4 / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded It will work right in LO 7.1.5.2 (Except the old bug for appending data to a non exiting table)
Created attachment 179299 [details] And some other bugs of the table import wizard … Detected more bugs on first page of table import wizards. Added a little description with screenshots … This buggy behavior also first appears in LO 7.2. Tested here with OpenSUSE 15.3 64bit rpm Linux. Version: 7.2.5.1 / LibreOffice Community Build ID: 6d497ff5e83a906a307eb25cce314d40c0b8624f CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: de-DE (de_DE.UTF-8); UI: en-US Calc: threaded … and also newer version like LO 7.3.2.2
Same behaviour in Windows If you want to import a table from HSQLDB you can't. If you want to translate an HSQLDB into a Firebird database no table is generated. Windows 10, Libreoffice 7 seres.
Following comment2 I set this one to NEW.
If you use code to create the wizard for a specific import (in my case from a calc sheet to a existing table in the database, but I think it occurs also from database tables) using Firebird it seems not to take into consideration the table source (he calc sheet). It seems to me that the Driver doesn't work, so the datasource is not shown to the wizard to make its job. If you open the calc document, select all rows you want and copy them and go to the tables panel and paste, the wizard seems to work properly, but not if yo use code to work with the wizard. This behaviour doesn't occur with HSQLDB Windows 10, LibreOffice 7.3.3.2(x89) d1d0ea68f081ee2800a922cac8f79445e4603348
(In reply to Longi from comment #4) > If you use code to create the wizard for a specific import (in my case from > a calc sheet to a existing table in the database, but I think it occurs also > from database tables) using Firebird it seems not to take into consideration > the table source (he calc sheet). > It seems to me that the Driver doesn't work, so the datasource is not shown > to the wizard to make its job. Please don't add comments, which contain other content than the reported bug. The bug is about options, which are disabled in a wrong way for the import wizard of tables. If you see other bugs report it as a separate bug. The options had been disabled in a right way in LO 7.1.5.2, wrong since LO 7.2.0.4.
duplicate of resolved(fixed) bug 152900 bibisected in version: Version: 7.2.0.0.alpha1+ / LibreOffice Community Build ID: 556243467a0ac3f647de75bf3fb6c9f3b72466a4 CPU threads: 3; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: en-IN (en_IN); UI: en-US Calc: threaded repo: https://bibisect.libreoffice.org/linux-64-7.2.git-bundle commit 0a1d408881eab35b1a1b1599a9b40389ad3ffc97 Author: Jenkins Build User <tdf@pollux.tdf> Date: Thu May 20 17:36:04 2021 +0200 source 3f8e50f9b2fb35db190ce0204981f3f02d1d5ae6 source 3f8e50f9b2fb35db190ce0204981f3f02d1d5ae6 instdir/program/libdbulo.so | Bin 5748752 -> 5748592 bytes instdir/program/setuprc | 2 +- instdir/program/versionrc | 2 +- 3 files changed, 2 insertions(+), 2 deletions(-) attached: bibisecting done in command line *** This bug has been marked as a duplicate of bug 152900 ***
Created attachment 186665 [details] bibisecting done in command line bibisecting notes: to locate in which 7.2 commit the "Create new field as primary key" checkbox was disabled -> repro -> bibisect mark as bad. for copy / pasting tables Ctrl+C / Ctrl+V shortcut keys were used only after getting the source sha string it was found as a duplicate of resolved(fixed) bug 152900 bibisecting observations: a) general - oldest - not repro - app crash while pasting the table b) general - master - repro c) between steps 10 and 9 - the app did not open - hence it was marked as skip d) confirmation - checkout 0a1d408881eab35b1a1b1599a9b40389ad3ffc97 - repro e) confirmation - HEAD^ - not repro