Details
-
Type:
Task
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Fix Version/s: 10.5.0
-
Component/s: Versioned Tables
-
Labels:None
Description
Currently when there is no unit specifier in AS OF query like:
select * from t1 for system_time as of @p1; |
it will do some heuristics to detect whether it should treat @p1 is trx_id or timestamp.
Such semantic complexity should be removed in favour of default TIMESTAMP because:
1. rare practical use and doubtful advantage;
2. it conflicts with MDEV-16226.
Attachments
Issue Links
- blocks
-
MDEV-16226 TRX_ID-based System Versioning refactoring
-
- Stalled
-
- is blocked by
-
MDEV-15408 Confusing error message upon ER_VERS_FIELD_WRONG_TYPE while omitting UNSIGNED in BIGINT
-
- Closed
-
- relates to
-
MDEV-16094 Crash when using AS OF with a stored function
-
- Closed
-
-
MDEV-16100 FOR SYSTEM_TIME erroneously resolves string user variables as transaction IDs
-
- Closed
-