Bug 150033 - EDITING - Table rename function missing from context menu entry in embedded Firebird
Summary: EDITING - Table rename function missing from context menu entry in embedded F...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.3.4.2 release
Hardware: ARM macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-07-18 05:40 UTC by Alex Thurgood
Modified: 2022-09-21 17:13 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.