Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
10.3.3-1
Description
Currently there is an asymmetry in how binary comparison operators (such as = or >, etc) are implemented for temporal vs other data types.
Item_bool_rowready_func2 does not cache its constant arguments of temporal types at fix time. Instead, constant arguments are replaced to instances of Item_cache_temporal at evaluation time, when get_datetime_value() is executed for the first time.
Non-temporal types do it in a different way: constant arguments are cached at fix time, while the evaluation time code does not do any argument substitution or caching. Substitution is done in Arg_comparator::set_cmp_func_(string|int|real|decimals)(), with these two lines:
a= cache_converted_constant(thd, a, &a_cache, compare_type_handler());
|
b= cache_converted_constant(thd, b, &b_cache, compare_type_handler());
|
Under terms of this task we will change the code for the temporal data types to cache constant arguments in fix time, using cache_converted_constant(), like it is done for the other data types. Caching during evaluation time will be removed.
Rationale:
- We're adding pluggable data types soon. It's better to have symmetric code, to add new data types easier.
- TIMESTAMP should be fixed to do comparison in my_time_t format internally, without conversion to MYSQL_TIME (such conversion can be lossy, see
MDEV-13995). It would be nice to make the code symmetric before fixing bugs likeMDEV-13995, for simplicity.
Attachments
Issue Links
- blocks
-
MDEV-4912 Data type plugin API version 1
- Closed
-
MDEV-13995 MAX(timestamp) returns a wrong result near DST change
- Closed