When running MySQL/MariaDB with charset utf8mb4, a character is 4 bytes. Hence a key created on a VARCHAR(255) takes 255 characters * 4 bytes/characters = 1020 bytes. However Innodb defaults to a maximum of 767 bytes for an index.
The extension fails to install on Debian Stretch which uses utf8mb4 as the default charset:
Query: CREATE TABLE `spoofuser` ( su_name VARCHAR(255), su_normalized VARCHAR(255), su_legal BOOL, su_error TEXT, PRIMARY KEY (su_name), KEY(su_normalized, su_name) ) ENGINE=InnoDB Function: Wikimedia\Rdbms\Database::sourceFile( /workspace/src/extensions/AntiSpoof/includes/../sql/patch-antispoof.mysql.sql ) Error: 1071 Specified key was too long; max key length is 767 bytes (localhost:/tmp/quibble-mysql-u0z8hu64/socket)