Bug 150033

Summary: EDITING - Table rename function missing from context menu entry in embedded Firebird
Product: LibreOffice Reporter: Alex Thurgood <iplaw67>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal CC: robert
Priority: medium    
Version: 7.3.4.2 release   
Hardware: ARM   
OS: macOS (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description Alex Thurgood 2022-07-18 05:40:40 UTC 
Description:
1) Create an embedded Firebird ODB (you need to activate the experimental options first) and save it. Close LO.

2) Open the embedded Firebird ODB file and create a new table via the UI.

3) Define the fields for the table, and save it as "Table1".

4) In the list of tables in the bottom pane, right mouse button click on the table name "Table1" to get the context menu.

5) The context menu has no "Rename" entry.

This context menu entry is present in an embedded HSLQDB ODB.

Steps to Reproduce:
See description above

Actual Results:
No context menu entry for "Rename" of the table is displayed

Expected Results:
The context menu should contain an entry for renaming the table


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Version: 7.3.4.2 / LibreOffice Community
Build ID: 728fec16bd5f605073805c3c9e7c4212a0120dc5
CPU threads: 8; OS: Mac OS X 12.4; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded
Comment 1 Robert Großkopf 2022-08-02 18:27:51 UTC 
This is possible with HSQLDB:
ALTER TABLE "old_name" RENAME TO "new_name";
But it is impossible in Firebird 3.0. 
Only renaming of columns is allowed there.
So you have to copy the table, paste it and set a new name for it.
Comment 2 Alex Thurgood 2022-09-21 17:13:46 UTC 
(In reply to Robert Großkopf from comment #1)
> This is possible with HSQLDB:
> ALTER TABLE "old_name" RENAME TO "new_name";
> But it is impossible in Firebird 3.0. 
> Only renaming of columns is allowed there.
> So you have to copy the table, paste it and set a new name for it.

Oh, very useful (not).

So, NOTABUG then, as the feature isn't even available in Firebird.