Bug Hunting Session
Bug 120597 - Firebird: Edit: Update Create View UI to support Firebird 'WITH CHECK OPTION' for Simple (updatable) Views
Summary: Firebird: Edit: Update Create View UI to support Firebird 'WITH CHECK OPTION'...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.2.0.0.alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Firebird-Default
  Show dependency treegraph
 
Reported: 2018-10-14 22:28 UTC by Drew Jensen
Modified: 2018-12-03 10:51 UTC (History)
0 users

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 Drew Jensen 2018-10-14 22:28:33 UTC
This is RFE is for both the coding and UI update needed to fully support of another RFE https://bugs.documentfoundation.org/show_bug.cgi?id=120596 "Firebird: Editing: Add support for UI data control update of Simple (updatable) views"

The Firebird rdbms supports and optional clause in a View definition,'WITH CHECK OPTION'. The option is easily added if the view is edited in the SQL view mode in the create View window, this RFE would be to add the option clause to the end of the SQL view definition generated when the Create View Designer mode is active through the use of a new UI Option. 

This could be a check box or context menu item, IDK.
*****
The firebird documentation has the following information on the option:
The optional WITH CHECK OPTION clause requires an updatable view to check whether new or updated data meet the condition specified in the WHERE clause of the SELECT statement. Every attempt to insert a new record or to update an existing one is checked as to whether the new or updated record would meet the WHERE criteria. (in the View definition)

If they fail the check, the operation is not performed and an appropriate error message is returned.

WITH CHECK OPTION can be specified only in a CREATE VIEW statement in which a WHERE clause is present to restrict the output of the main SELECT statement. An error message is returned otherwise.
*****

From what I see here I would expect that using the option in a view definition, added by hand, will not effect Base code at all if and after any support for updatable views is added, so the RFE should be limited to updates to LibreOffice code only for the Create View component.