Re: [Maria-discuss] Strange timestamp index behaviour / bug

Hi! Am 03.04.19 um 17:36 schrieb Reinis Rozitis:

Hi, 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.