GSOC 2016

UNIQUE INDEX FOR BLOBS AND LONG VARCHAR COLUMN

 MariaDB Corporation

This project is about creating unique index for long columns like blob , text or long varchar. In this project I modified MariaDB server source code so that when user creates a index it automatically creates a hash column which stores the hash of blob. I complete the original project this is github repo link

Unique Index for blob and varchar columns  (upto commit 638e3d9 for GSOC)

Apart from this I also completed some extra projects like hidden column in MariaDB

jira link Hidden columns. This work is also included in above repo.

Currently I am working on optimizing index lookups for where . Actually normal  lookups are  optimized but complex query involving joins , subquery are not optimized.