Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
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
-
-
- Stalled
-
- is blocked by
-
MDEV-15408 Confusing error message upon ER_VERS_FIELD_WRONG_TYPE while omitting UNSIGNED in BIGINT
-
- Closed
-
- relates to
-
-
- Closed
-
-
-
- Closed
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Currently when there is no unit specifier in AS OF query like:
```sql 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. There is no need in such heuristics as overwhelming majority will mean timestamp. Such needless semantic complexity should be removed in favour of default TIMESTAMP. |
Currently when there is no unit specifier in AS OF query like:
{code:sql} select * from t1 for system_time as of @p1; {code} it will do some heuristics to detect whether it should treat {{@p1}} is trx_id or timestamp. There is no need in such heuristics as overwhelming majority will mean timestamp. Such needless semantic complexity should be removed in favour of default TIMESTAMP. |
| Link |
This issue relates to |
| Link |
This issue relates to |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | Stalled [ 10000 ] |
| Comment |
[ [~bar] I don't think changes from |
| Fix Version/s | 10.3.7 [ 23005 ] | |
| Resolution | Won't Fix [ 2 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Description |
Currently when there is no unit specifier in AS OF query like:
{code:sql} select * from t1 for system_time as of @p1; {code} it will do some heuristics to detect whether it should treat {{@p1}} is trx_id or timestamp. There is no need in such heuristics as overwhelming majority will mean timestamp. Such needless semantic complexity should be removed in favour of default TIMESTAMP. |
Currently when there is no unit specifier in AS OF query like:
{code:sql} select * from t1 for system_time as of @p1; {code} 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. |
| Resolution | Won't Fix [ 2 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Link | This issue blocks MDEV-16226 [ MDEV-16226 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.3.7 [ 23005 ] |
| Assignee | Aleksey Midenok [ midenok ] | Alexander Barkov [ bar ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Link |
This issue is blocked by |
| Assignee | Alexander Barkov [ bar ] | Aleksey Midenok [ midenok ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Aleksey Midenok [ midenok ] | Alexander Barkov [ bar ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Alexander Barkov [ bar ] | Aleksey Midenok [ midenok ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Aleksey Midenok [ midenok ] | Sergei Golubchik [ serg ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.3 [ 22126 ] |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.4 [ 22408 ] |
| Assignee | Sergei Golubchik [ serg ] | Aleksey Midenkov [ midenok ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Assignee | Aleksey Midenkov [ midenok ] | Alexander Barkov [ bar ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Alexander Barkov [ bar ] | Aleksey Midenkov [ midenok ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2019-09-30 12:39:26.0 | 2019-09-30 12:39:26.093 |
| Fix Version/s | 10.5.0 [ 23709 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 87086 ] | MariaDB v4 [ 133542 ] |