Closed
Description
A Consistent Query, (or an Extended/Consistent Select Query)
Query Request:
Considering the SQL-syntax to remain the same as the select query syntax plus a key=value UPDATE=NEW_VALUE in the cells-interval.
select where [Columns-Intervals [Cells-Interval with an UPDATE=NEW_VALUE]]and
Specifications Interval Scan the Specs::Interval class storage added with a pointer+size type struct Specs::ValueUpdate update
Query Response:
The query to return the cells with the updated value.
The Result:
The Consistent Query will let queries such as Counter Operations to be in Consistent Nature.
In a case of COUNTER type Column, instead of INSERT follow a SELECT, which is breaking a use case such as an Unique ID assignment, the query can be a single process returning the cells with latest values of the resulting UPDATE=-/+NEW_VALUE