https://bugs.documentfoundation.org/show_bug.cgi?id=156355
Bug ID: 156355
Summary: FIREBIRD: Views will show different fields when
executed or opened for editing
Product: LibreOffice
Version: 7.3.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 188442
--> https://bugs.documentfoundation.org/attachment.cgi?id=188442&action=edit
Base file with different results for view if executed or opended for Editing in
SQL and run in editor
Open the attached database file.
Execute "viw_person".
You could see 3 fields.
Close the view.
Right mouse click on "viw_person" → Edit in SQL view
Run query.
You could see 4 fields. One field "Street" is visible.
Table "tbl_person" has been created with 3 fields.
Query and view have been created.
Then I have added "Street" to "tbl_person".
New added fields won't be shown in the view.
Note: Views with internal HSQLDB will change the code while creating a view
from a query with
SELECT * FROM "tbl_person"
to
SELECT "tbl_Person"."ID", "tbl_Person"."Forename", "tbl_Person"."Surname"
FROM "tbl_Person"
So you could see: New added fields to table "tbl_Person" had to be added to the
view also.
But for Firebird the views will be shown by a code, which doesn't need this
separate fields.
Bug appears since views could be opened for editing, might be first version of
LO 7.3. Detected this bug in LO 7.6.0.1 and could reproduce it with LO 7.3.6.2
also on OpenSUSE 15.4 64bit rpm Linux.
--
You are receiving this mail because:
You are the assignee for the bug.
