: 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
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
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:
3 matches
Mail list logo