← Back to team overview

maria-developers team mailing list archive

Re: Gsoc 2016 Mdev 371 Unique index for blob


Hi, Sachin!

On Mar 22, Sachin Setia wrote:
> Hello Sergei
> Actually I was prototyping for blob and varchar   for aria and myisam
> storage engine.
> My prototype worked for complex definations like
> craete table(abc int primary key, blob_col blob unique, varchar_col
> varchar(1000) unique) engine=myisam;
> Solved the issue of frm file incosistance.
> As you suggested for doing it for innodb i am current working on it.Innodb

*I* did not suggest that. But you're welcome to try, of course.
If you think that just MyISAM is too simple for a three month project.
(Aria doesn't count it's a couple of days after you done MyISAM).

> does not natively support hash based index.
> when we run select distinct column from tbl;
> it use create_internal_tmp_table() which uses maria storage engine for
> creating tmp table.
> But query like this works
> MariaDB [sachin]> create table iu2(abc blob unique);
> Query OK, 0 rows affected (0.04 sec)
> MariaDB [sachin]> insert into iu2 values(1);
> Query OK, 1 row affected (0.03 sec)
> MariaDB [sachin]> insert into iu2 values(1);
> ERROR 1062 (23000): Duplicate entry '1' for key 'abc'
> this query does not use hash but it simply compares values


> Will write a proposal shortly.


Chief Architect MariaDB
and security@xxxxxxxxxxx

Follow ups