Re: [Maria-developers] 9bb9bde: MDEV-6236 - [PATCH] mysql_tzinfo_to_sql may produce invalid SQL

2015-06-03 Thread Sergei Golubchik
Hi, Sergey! On Jun 03, Sergey Vojtovich wrote: > Hi Sergei, > > speaking of IANA time zone database, there seem to be no other long > abbreviations: > > But as we can see TZ if permits abbreviations longer than 8 characters (while > MariaDB/MySQL doesn't). In theory if we just filter out such ti

Re: [Maria-developers] [Commits] 9bb9bde: MDEV-6236 - [PATCH] mysql_tzinfo_to_sql may produce invalid SQL

2015-06-03 Thread Sergey Vojtovich
Hi Sergei, speaking of IANA time zone database, there seem to be no other long abbreviations: for i in `find /usr/share/zoneinfo -type f` ; do zdump $i; done|sed "s/.*2015 //"|while read line; do echo ${#line} $line; done|sort -n But as we can see TZif permits abbreviations longer than 8 charact

Re: [Maria-developers] [Commits] 54977be: MDEV-7207 - ALTER VIEW does not change ALGORITM

2015-06-03 Thread Sergei Golubchik
Hi, Sergey! On Jun 03, s...@mariadb.org wrote: > revision-id: 54977bee6705b9f3ebe2e534245defdb18ac31be > parent(s): 6bd76f8b7e086ab7cf0249a05277ff552e564554 > committer: Sergey Vojtovich > branch nick: mariadb > timestamp: 2015-06-03 13:59:58 +0400 > message: > > MDEV-7207 - ALTER VIEW does not c

Re: [Maria-developers] [Commits] 9bb9bde: MDEV-6236 - [PATCH] mysql_tzinfo_to_sql may produce invalid SQL

2015-06-03 Thread Sergei Golubchik
Hi, Sergey! On Jun 03, s...@mariadb.org wrote: > revision-id: 9bb9bde42dbf6f936faadeaa34cde838bf6b63dd > parent(s): 54977bee6705b9f3ebe2e534245defdb18ac31be > committer: Sergey Vojtovich > branch nick: mariadb > timestamp: 2015-06-03 14:30:09 +0400 > message: > > MDEV-6236 - [PATCH] mysql_tzinfo_