Open a Firebird database. Create a query like SELECT * FROM "table". Right click on the query and "Create as View". Set "Table Name" → "viwTest" You could see the view in tables pane. Now delete "viwTest". View will be deleted. Again: Right click on the query and "Create as View". Set "Table Name" → "viwTest" You couldn't see the view in tables pane. You have to close the Base window and reopen it. Then the new view will be created with the same name as the old view. All tested with Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 703fb7739a5e604d90e147db6f67917b8d141150 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 Couldn't be tested with LO 4.3.0.3, because creating a view from a query will give and error and won't appear in tables pane without refreshing tables. See bug 126580
On pc Debian x86-64 with master sources updated today, I could reproduce this. Remark: I don't reproduce this with HSQLDB file.
I gave a try with https://gerrit.libreoffice.org/c/core/+/131442
Julien Nabet committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/eff9dc65b88ca48171e9e6ab51f1e2ec8d0f436d tdf#147309: Recreating a view with same name and in the same session fails (FB) It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Cherry-pick for 7.3 waiting for review here: https://gerrit.libreoffice.org/c/core/+/131447
Julien Nabet committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/7dade11c99b412081eff0d5db49ede619e866737 tdf#147309: Recreating a view with same name and in the same session fails (FB) It will be available in 7.3.3. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.