Description: If you rename a view in Base (right click then rename) and if the driver allows it, after renaming the view Base takes it for a table. Refreshing the tables does nothing, you are forced to close Base then reopen to bypass it. Steps to Reproduce: 1.Rename a view in Base (right click then rename). 2.Once the view is renamed, it is considered as a table. 3.If you close Base then open you can see your renamed view. Actual Results: Once the view is renamed, it is considered as a table. Expected Results: Once the view is renamed, it is considered as a view. Reproducible: Always User Profile Reset: No Additional Info: If you close Base then open you can see your renamed view.
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
I cannot attach a file it is a connection to a database and in addition I have not found a driver supplied with LibreOffice which allows tables or views to be renamed. So the only solution if you want to be able to reproduce this bug is to install the jdbcDriverOOo[1] extension and use one of the drivers provided with it (SQLite for example). You will be able to reproduce very easily. [1] https://prrvchr.github.io/jdbcDriverOOo/
No internal database will support to rename a view. You could try this with MySQL/MariaDB and direct connection. When renaming a view it will be shown by a symbol of a table. Only closing and reopening the Base file will show the symbol for a view. Tested with LO 24.2.0.3 on OpenSUSE 15.4 64bit rpm Linux.
> When renaming a view it will be shown by a symbol of a table Thank you for the test, this confirms that this is not a problem coming from the jdbcDriverOOo extension, I did not succeed in this validation. Not only is the view displayed like a symbol of a table, but also if we try to edit it Base edit it like a table.