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

2019-04-03 Thread Oleksandr Byelkin
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

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

2019-04-03 Thread 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?): db:~ # date Wed Apr 3 18:17:36 EEST 2019 MariaDB [db]> SELECT @@GLOBAL.time_zone, @@SESSION.time_zon

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

2019-04-01 Thread Sergei Golubchik
Hi, Reinis! On Apr 01, Reinis Rozitis wrote: > Hello, > before reporting it as bug I wanted to understand what's really going > on or how to investigate it further: > > Because of the DST changes we experienced a strange issue where > afterwards a query suddenly wouldn't use an index on a timesta

[Maria-discuss] Strange timestamp index behaviour / bug

2019-04-01 Thread Reinis Rozitis
Hello, before reporting it as bug I wanted to understand what's really going on or how to investigate it further: Because of the DST changes we experienced a strange issue where afterwards a query suddenly wouldn't use an index on a timestamp column anymore and would do a full tablescan and bec