maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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 security@xxxxxxxxxxx