← Back to team overview

maria-discuss team mailing list archive

Re: Strange timestamp index behaviour / bug



Am 03.04.19 um 17:36 schrieb Reinis Rozitis:
I was playing more with the issue of Mariadb not using a timestamp index for a particular time range - can someone explain why the following happens (or how the timestamps actually work?):

you better say server version and show create table result, but first try compare a timestamp with a timestamp (if it was really timestamp field) try to compare it with number of seconds from epoch (instead of date which do not map to timestamps 1:1). Maybe here is the problem.