← Back to team overview

maria-developers team mailing list archive

Re: Gsoc 2016 Mdev 371 Unique index for blob

 

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


Follow ups

References