Copying table definitions

[marus_b]

Hello everyone,

If someone could possibly try to replicate this to determine if it’s an issue on my end only:

Within Base, I’m trying to copy a definition of a table, which works fine unless I try to change a name of one of the columns. If I change the name of one column (in my case from “personID” [foreign key] to “commercialID” - integer type) and then press ‘create’ the entire procedure is completely ignored and the new table does not show up.

Otherwise, if I just do a straight definition only copy, without altering the names of any of the columns, the foreign key constraint gets stripped and the procedure goes through smoothly.

Version: 7.5.2.2 (X86_64) / LibreOffice Community
Build ID: 53bb9681a964705cf672590721dbc85eb4d0c3a2
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: threaded

MySQL 8.0.32 connected via native connector.

[RobertG]

I have tried this with MariaDB direct connected:
Copied a table and pasted it.
Wizard appears → chose “Definition and Data” and changed the table name.
Then pressed “Create”.
Table appears.

So: Please describe at which step an error appears.
I could find an error when trying to change a field name in an existing table:

The column "Name" could not be changed. 
Should the column instead be deleted and the new format appended?

And when I press more I will get:

SQL Status: 42S02
Error code: 1146

Table 'test.test.Table1' doesn't exist

This is wrong: Table name should be ‘test.Table1’. There isn’t a database like a schema ‘test’ inside the database ‘test’.

Tested with LO 7.5.3.2 on OpenSUSE 15.4 64bit rpm Linux with direct connection to MariaDB.
This buggy behavior doesn’t appear with JDBC-connection to MariaDB on the same system.
Have written a bug for this: Bug 155443

[marus_b]

Hello @RobertG ,
Please see this link for further explanation: DemoCreatorRec 2023 05 23 21 02 57 - YouTube

[RobertG]

You want to rename the field while copying the table. Have tried it with the wizard and internal HSQLDB. If I rename a field in the wizard before the table has been created no table will be created. So this bug isn’t a specific behavior of the MySQL-connection.

Have written a bug for this: Bug 155467. Renaming works in older versions - older than LO 6.4.0.3. Would be good if you could confirm the bug.

[marus_b]

@RobertG when you say that you want me to confirm the bug, do you mean for me to install the older version of Libreoffice, which you mentioned above, and attempt this procedure again? If so, not a problem, but I’ll do it a bit later.

[RobertG]

@marus_b : No, you won’t need to install the old version. Only write down something like "I could confirm the buggy behavior with " and then the version you have posted here.

[marus_b]

Done :)… I could not change the status to confirmed, but the note is there.