[MDEV-15980] FOR SYSTEM_TIME BETWEEN and FROM .. TO work with negative intervals Created: 2018-04-22 Updated: 2018-05-12 Resolved: 2018-05-12 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Versioned Tables |
| Affects Version/s: | 10.3 |
| Fix Version/s: | 10.3.7 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Elena Stepanova | Assignee: | Eugene Kosov (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Note: I'm not sure it's a bug, and even less sure it's important, it just looks odd and most likely will trigger reports from some meticulous users.
Same for BETWEEN. Current documentation just says
and about the same for FROM .. TO. So, technically it doesn't say that start should be earlier than end, although common sense suggests so, and also it's reasonable to expect semantics close to the old operator BETWEEN, which doesn't return anything for backward intervals. |
| Comments |
| Comment by Sergei Golubchik [ 2018-04-25 ] | |
|
The standard grammar is
If SYMMETRIC then points can be specified in any order, if ASYMMETRIC, then point1 must be less or equal than point2. If neither is specified, ASYMMETRIC is implied. So, you're right, the first point in time should be less or equal than the second one. | |
| Comment by Eugene Kosov (Inactive) [ 2018-04-26 ] | |
|
Relevant part of standard is 7.6 <table reference> General Rules | |
| Comment by Eugene Kosov (Inactive) [ 2018-04-27 ] | |