15 Mar
2016
15 Mar
'16
8:07 p.m.
Hi, Sachin! On Mar 15, Sachin Setia wrote:
I was doing prototype for this project as Mr Sergei Golubchik suggested
"This task is about creating MI_UNIQUEDEF "uniques" instead of MI_KEYDEF "keys" for long unique constraints."
Here is my output
MariaDB [sachin]> create table tbl(int_key int primary key , blob_key blob unique); Query OK, 0 rows affected (0.03 sec)
MariaDB [sachin]> insert into tbl values(1,1); Query OK, 1 row affected (0.01 sec)
MariaDB [sachin]> insert into tbl values(2,1); ERROR 1062 (23000): Duplicate entry '1' for key 'blob_key'
Very cool!
Should i mail you the source code.Please let me know Regards sachin
Sure! Please, do. Regards, Sergei Chief Architect MariaDB and security@mariadb.org