diff options
author | Mattias Jonsson <mattias.jonsson@sun.com> | 2009-08-26 12:51:23 +0200 |
---|---|---|
committer | Mattias Jonsson <mattias.jonsson@sun.com> | 2009-08-26 12:51:23 +0200 |
commit | 3b756a01a04cf8d7a2a11207d3512f5839b4fd89 (patch) | |
tree | 7f812893ef1db316782ee8e0b013f4e57a754483 /config | |
parent | 10e90a1fe5154e78402fe4b3868e79d1f2076239 (diff) | |
download | mariadb-git-3b756a01a04cf8d7a2a11207d3512f5839b4fd89.tar.gz |
Bug#46362: Endpoint should be set to false for TO_DAYS(DATE)
There were a problem since pruning uses the field
for comparison (while evaluate_join_record uses longlong),
resulting in pruning failures when comparing DATE to DATETIME.
Fix was to always comparing DATE vs DATETIME as DATETIME,
by adding ' 00:00:00' to the DATE string.
And adding optimization for comparing with 23:59:59, so that
DATETIME_col > '2001-02-03 23:59:59' ->
TO_DAYS(DATETIME_col) > TO_DAYS('2001-02-03 23:59:59') instead
of '>='.
Diffstat (limited to 'config')
0 files changed, 0 insertions, 0 deletions