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] required mysql_upgrade; MDEV-14637

2019-04-03 Thread mj
On 4/3/19 12:44 PM, Reindl Harald wrote: beasue any application which can't read it's data after upgrade to a new version is f**g crap and pretty unusable when using as example distro-packages - when you forgot the dump with the old version your are fucked That explains. Thank you. MJ

Re: [Maria-discuss] required mysql_upgrade; MDEV-14637

2019-04-03 Thread Reindl Harald
Am 03.04.19 um 09:54 schrieb mj: > On 3/28/19 11:59 AM, Reindl Harald wrote: >> our production datadirs date back to 2002, originally on windows then >> moved to MacOS and in 2008 to Fedora and i did not dump/restore a single >> time in my whole life, this is not postgresql > > Just curiosity:

Re: [Maria-discuss] required mysql_upgrade; MDEV-14637

2019-04-03 Thread mj
On 4/3/19 10:23 AM, Vincent Hoffman-Kazlauskas wrote: PostgreSQL until relatively recently (8.something) required you to dump and restore all your data for a major version upgrade. For some people this was an argument against using PostgreSQL. Ah,thanks! Didn't know that. MJ __

Re: [Maria-discuss] required mysql_upgrade; MDEV-14637

2019-04-03 Thread Vincent Hoffman-Kazlauskas
On 03/04/2019 08:54, mj wrote: > Hi, > > On 3/28/19 11:59 AM, Reindl Harald wrote: >> our production datadirs date back to 2002, originally on windows then >> moved to MacOS and in 2008 to Fedora and i did not dump/restore a single >> time in my whole life, this is not postgresql > > Just curio

Re: [Maria-discuss] required mysql_upgrade; MDEV-14637

2019-04-03 Thread mj
Hi, On 3/28/19 11:59 AM, Reindl Harald wrote: our production datadirs date back to 2002, originally on windows then moved to MacOS and in 2008 to Fedora and i did not dump/restore a single time in my whole life, this is not postgresql Just curiosity: does the above statement mean that you cons