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

[Otto Kekäläinen]

Package: mariadb-server
Version: 1:10.5.5.-1
Control: tags -1 confirmed

I tested and this still applies to the latest MariaDB version now in Debian.
Suggestions on what to do about it are welcome.



MariaDB [test]> select @@Version;
+------------------+
| @@Version        |
+------------------+
| 10.5.5-MariaDB-1 |
+------------------+
1 row in set (0.000 sec)

MariaDB [test]> select @@version;
+------------------+
| @@version        |
+------------------+
| 10.5.5-MariaDB-1 |
+------------------+
1 row in set (0.000 sec)

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

MariaDB [test]> 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)