[Bug 1217688] mariadb: a table is missing inserted entries from concurrent processes

https://bugzilla.suse.com/show_bug.cgi?id=1217688 https://bugzilla.suse.com/show_bug.cgi?id=1217688#c9 --- Comment #9 from Jiri Slaby <jslaby@suse.com> --- In mysql:

mysql> ALTER TABLE sources CHANGE COLUMN src src VARCHAR(769) NOT NULL UNIQUE; ERROR 1071 (42000): Specified key was too long; max key length is 3072 bytes

The maximum length of UNIQUE column in mysql is 3072 bytes, i.e. 768 utf8mb4 chars. So if I do this in mariadb:

MariaDB [structs_66]> ALTER TABLE sources CHANGE COLUMN src src VARCHAR(768) NOT NULL UNIQUE; everything works. If I enlarge to 769, it breaks: MariaDB [structs_66]> ALTER TABLE sources CHANGE COLUMN src src VARCHAR(769) NOT NULL UNIQUE; -- You are receiving this mail because: You are on the CC list for the bug.