https://bugs.documentfoundation.org/show_bug.cgi?id=147309
Bug ID: 147309
Summary: Firebird: Deleting an old view and creating a new view
with same name works only after restarting Base
Product: LibreOffice
Version: 7.4.0.0 alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
