[debian-mysql] Bug#917088: mariadb-server-10.3: #1071 - Specified key was too long; max key length is 1000 bytes

[Olaf van der Spek]

Package: mariadb-server-10.3
Version: 1:10.3.11-1
Severity: normal

Dear Maintainer,

varchar(255) is a common type, indexes on it used to be just fine.

MariaDB [st_forum]> create table test (a varchar(255), key(a)) engine = myisam;
Query OK, 0 rows affected, 1 warning (0.006 sec)

MariaDB [st_forum]> show warnings;  
+---------+------+----------------------------------------------------------+
| Level   | Code | Message                                                  |
+---------+------+----------------------------------------------------------+
| Warning | 1071 | Specified key was too long; max key length is 1000 bytes |
+---------+------+----------------------------------------------------------+
1 row in set (0.000 sec)

Gr,

Olaf

-- System Information:
Debian Release: buster/sid
  APT prefers unstable
  APT policy: (500, 'unstable'), (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 4.18.0-3-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8), LANGUAGE=en_US:en (charmap=UTF-8)
Shell: /bin/sh linked to /usr/bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages mariadb-server-10.3 depends on:
ii  adduser                   3.118
ii  debconf [debconf-2.0]     1.5.69
ii  galera-3                  25.3.24-1
ii  gawk                      1:4.2.1+dfsg-1
ii  iproute2                  4.18.0-2
ii  libc6                     2.28-3
ii  libdbi-perl               1.642-1+b1
ii  libpam0g                  1.1.8-3.8
ii  libssl1.1                 1.1.1a-1
ii  libstdc++6                8.2.0-13
ii  lsb-base                  10.2018112800
ii  lsof                      4.89+dfsg-0.1
ii  mariadb-client-10.3       1:10.3.11-1
ii  mariadb-common            1:10.3.11-1
ii  mariadb-server-core-10.3  1:10.3.11-1
ii  passwd                    1:4.5-1.1
ii  perl                      5.28.1-3
ii  psmisc                    23.2-1
ii  rsync                     3.1.2-2.2
ii  socat                     1.7.3.2-2
ii  zlib1g                    1:1.2.11.dfsg-1

Versions of packages mariadb-server-10.3 recommends:
ii  libhtml-template-perl  2.97-1

Versions of packages mariadb-server-10.3 suggests:
pn  mailx           <none>
pn  mariadb-test    <none>
pn  netcat-openbsd  <none>
pn  tinyca          <none>

-- debconf information:
  mariadb-server-10.3/postrm_remove_databases: false
  mariadb-server-10.3/old_data_directory_saved:
  mariadb-server-10.3/nis_warning: