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:
