Allow to query only those records INSERTed or UPDATEd since last time/sequence
------------------------------------------------------------------------------
Key: CORE-6199
URL: http://tracker.firebirdsql.org/browse/CORE-6199
Project: Firebird Core
Issue Type: New Feature
Components: Documentation, Engine, ISQL
Affects Versions: 4.0 Beta 1, 4.0 Beta 2
Reporter: PizzaProgram Ltd.
Priority: Minor
A typical request is to pull only THOSE records from Firebird servers, WHICH
CHANGED since last query.
With current engine model this is a very complex thing to do.
See:
https://stackoverflow.com/questions/59071948/how-to-read-all-last-changed-records-from-firebird-db
It would make programmers life much easier if there would be an "auto-sequencer
field", like: RDB$LAST_MODIFIED attached to every table by default.
That would be auto-updated on every insert and update by a global system
generator AFTER_COMMIT. (NOT during transaction, like triggers do!)
SELECT o.* FROM orders o WHERE o.RDB$LAST_MODIFIED > 5489852;
Or could be the new replication system's values used for this?
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
