A Consistent Query to let Counter Operations to be in Consistent Nature

[kashirin-alex]

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

[kashirin-alex]

The

select where [Columns-Intervals [ Cells-Interval( .. UPDATE=(TS,DATA,ENCODER) and ..) ] and .. ];

• always fetch the cell-value before it is changed unless applied with 'ONLY_KEYS' flags for no-value

[kashirin-alex]

related commits:
9fdc195
691250e
b236833
f195896
004af96
513360b
80954a7
e23fab2