Hey, Was it tested with a non ci collate?
Eliezer ---- Eliezer Croitoru NgTech, Tech Support Mobile: +972-5-28704261 Email: ngtech1...@gmail.com Web: https://ngtech.co.il/ My-Tube: https://tube.ngtech.co.il/ -----Original Message----- From: Maria-discuss <maria-discuss-bounces+ngtech1ltd=gmail....@lists.launchpad.net> On Behalf Of Sergei Golubchik Sent: Monday, 22 August 2022 9:49 To: Keith Edmunds <k...@midnighthax.com> Cc: maria-discuss@lists.launchpad.net Subject: Re: [Maria-discuss] Change case with unique constraint 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 _______________________________________________ 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