Re: [Maria-discuss] Change case with unique constraint

2022-08-22 Thread ngtech1ltd
: Monday, 22 August 2022 9:49 To: Keith Edmunds 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

Re: [Maria-discuss] Change case with unique constraint

2022-08-22 Thread Sergei Golubchik
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

Re: [Maria-discuss] Change case with unique constraint

2022-08-21 Thread Antony Stone
On Sunday 21 August 2022 at 21:28:13, Keith Edmunds wrote: > MariaDB [test]> update kae set name="Test" where id=1; > ERROR 1062 (23000): Duplicate entry 'Test' for key 'unique_name' Check the collation type for the table: