[debian-mysql] Bug#851195: mariadb-server-10.1: Time Zone system tables are empty

[Daniel Lewart]

Package: mariadb-server-10.1
Severity: wishlist
Tags: patch

Dear Maintainer,

   * What led up to the situation?

$ sudo apt-get install mariadb-server-10.1

   * What exactly did you do (or not do) that was effective (or
     ineffective)?

mysql> SELECT COUNT(*) FROM mysql.time_zone;

   * What was the outcome of this action?

0

   * What outcome did you expect instead?

1820 or so


This was unexpected because of
  #388491 - mysql-server-5.0: setup time_zone* tables upon installation?
https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=388491

Apparently this change was lost somewhere between MySQL 5.0 and 5.1.
I couldn't determine if this was accidental or intentional.

Anyway, I propose the attached patch to the postinst script.

Thank you!
Dan
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mariadb-server-10.1.postinst.diff
Type: text/x-diff
Size: 513 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20170112/0adff64b/attachment.diff>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: mariadb-server-10.1.postinst.diff
Type: text/x-diff
Size: 513 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-mysql-maint/attachments/20170112/0adff64b/attachment-0001.diff>