Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-15 Thread Sachin Setia
Hello everyone @Shubham As I said i am just prototyping This is not the final code It is just poc to see whether if I send some unique key will mi_create work fine or not as it is working fine in create_internal_tmp_table on following query "select distinct(a2) from tbl" where schema of tbl will

Re: [Maria-developers] GSoC 2016:Unique indexes for blobs

2016-03-15 Thread Shubham Barai
Hello, Sergie! I tried to explore the source code from mi_create.c,ha_myisam.cc,sql/sql_table.cc,include/myisam.h,.and some other files. The main task is to create MI_UNIQUEDEF "uniques" for long unique constraints. We have to consider all the cases where we need to create MI_UNIQUEDEF instead o

Re: [Maria-developers] Gsoc 2016 Mdev 371 Unique index for blob

2016-03-15 Thread Sachin Setia
Thanks sir for your reply I have done two thing 1. First commenting some code to remove the error we get when we try to create unique blob file=sql/sql_table.cc line no=3877 /* * Gsoc 2016 * I am implementing this so comment this stuff out */ // if (!column->length) // { //my_error(ER_BLOB_K

Re: [Maria-developers] Gsoc 2016 Mdev 371 Unique index for blob

2016-03-15 Thread Sergei Golubchik
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 tb

Re: [Maria-developers] Gsoc 2016 Mdev 371 Unique index for blob

2016-03-15 Thread Sachin Setia
Sorry one correction @-- I am assuming that unique blob will have 0 zero key @++ I am assuming that unique blob will have 0 zero key length Regards sachin On Tue, Mar 15, 2016 at 11:02 PM, Sachin Setia wrote: > Dear Developers, > > I was doing prototype for this project as Mr Sergei Golubchik su

[Maria-developers] Gsoc 2016 Mdev 371 Unique index for blob

2016-03-15 Thread Sachin Setia
Dear Developers, 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 uni

[Maria-developers] NO PAD Collation for MariaDB

2016-03-15 Thread Melissa Rose
Hello everyone, I am Melisa Rose from University of Leeds UK and I wish to contribute to MariaDB under GSoC 2016. I am interested in the project involving adding NO PAD collations to default character sets(MDEV-9711 ). Apparently, this project does not re

Re: [Maria-developers] Gsoc 2016 Mdev 371 Unique index for blob

2016-03-15 Thread Sergei Golubchik
Hi, Sachin! First: please send questions like this to maria-developers@lists.launchpad.net it's a public mailing list dedicated to MySQL and MariaDB internals, source code, and related things. I am subscribed, so I'll see you mail there, and you may be sure I will, because it won't be accidentally