Hello Sergei Actually i have one doubt there is two options 1 add is_hash flag to field 2 add ha_unique_hash flag to field ,but i think all 16 bits of key flag is used so to do this i need to add another ex_flag variable in key struct and store it and retrieve it from frm currently i have done both ,but as you pointed out in review that it is better to have it in key only but my question is that , whether is this approach is right ? Regards sachin
On Tue, Jul 12, 2016 at 2:43 PM, Sachin Setia <sachinsetia1...@gmail.com> wrote: > Hello everyone, > > Weekly Report for 7th week of gsoc > > 1Now we can alter blob columns query like > create table t1(abc blob unique); > alter table t1 change column abc a blob; > Even we can some multiple changes in one alter > create table t1(abc blob unique, xyz blob unique); > alter table t1 change column abc a blob , change xyz x blob; > Works. > > 2.Now we can delete blob columns if only one blob unique in > key then db_row_hash_ will be removed other wise hash_str > will be modified.If the query fails then there will be no > side effect > > 3.chaning of delete operations > create table t1(abc blob , xyz blob , pqr blob, unique(abc,xyz,pqr)); > alter table t1 drop column abc, drop column xyz; > 4. we will get right error message instead of duplicate hash > 5. these was an glich in code when we try to add db_row_hash_ column to > table with first key work mysql_prepare_alter_table select this > instead of real hash > now solved. > 6. Added some test case.Will add more soon. > @Sergei will reply to you soon. > Regards > sachin _______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
