Error message of duplicate primary key is not shown properly

[tangenta]

Enhancement

Actual:

mysql> CREATE TABLE t1 (a BINARY(16) PRIMARY KEY);
Query OK, 0 rows affected (0.02 sec)

mysql> INSERT INTO t1 VALUES (AES_ENCRYPT('a','a'));
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO t1 VALUES (AES_ENCRYPT('a','a'));
ERROR 1062 (23000): Duplicate entry '{ W]�u����.�٧t' for key 'PRIMARY'

Expected:

mysql> CREATE TABLE t1 (a BINARY(16) PRIMARY KEY);
Query OK, 0 rows affected (0.05 sec)

mysql> INSERT INTO t1 VALUES (AES_ENCRYPT('a','a'));
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO t1 VALUES (AES_ENCRYPT('a','a'));
ERROR 1062 (23000): Duplicate entry '{ W]\xA1\x06u\x9D\xBD\xB1\xA3.\xE2\xD9\xA7t' for key 't1.PRIMARY'

[3mard]

/assign

[rahulk789]

hello! I would like this issue to be assigned to me. This would be my first ever contribution on github.
Please give me 2 days of time. Thank you.

[rahulk789]

/assign

[rahulk789]

Quick Update
i have come up with a simple solution which you might like or not, I will describe it in detail in the pr. I'll have to read a ton of stuff just to understand the norms of making a pr into a production grade repository. Glad to be a part of this.

[tangenta]

@rahulk789 In case you didn't know, the TiDB development Guide may be helpful to new contributors.

[rahulk789]

okay, looks like i have to think harder. Thanks for the response in the PR.

[75asu]

Hi @tangenta, I have made a contribution at PR #38254.

please have a look.

thanks.