Hi, Keith, Thanks, it's a bug. Reported as https://jira.mariadb.org/browse/MDEV-29345
Until it's fixed, you can as a workaround update your column to something else and then to "Test". Or you can reduce the column length. On Aug 21, Keith Edmunds wrote: > I can't change the case of a column with a unique index, example below. > > MariaDB [test]> show columns in kae; > +-------+---------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +-------+---------------+------+-----+---------+----------------+ > | id | int(11) | NO | PRI | NULL | auto_increment | > | name | varchar(2048) | NO | UNI | NULL | | > +-------+---------------+------+-----+---------+----------------+ > 2 rows in set (0.001 sec) > > MariaDB [test]> select * from kae; > +----+------+ > | id | name | > +----+------+ > | 1 | test | > +----+------+ > 1 row in set (0.001 sec) > > MariaDB [test]> update kae set name="Test" where id=1; > ERROR 1062 (23000): Duplicate entry 'Test' for key 'unique_name' > MariaDB [test]> > Regards, Sergei VP of MariaDB Server Engineering and secur...@mariadb.org _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
