← Back to team overview

maria-developers team mailing list archive

Re: 322301e2434: MDEV-16849 Extending indexed VARCHAR column should be instantaneous

 

Hi, Thirunarayanan!

On Jan 29, Thirunarayanan Balathandayuthapani wrote:
> > > +ALTER TABLE t1 MODIFY f2 VARCHAR(50), DROP INDEX idx1;
> > > +CALL get_table_id("test/t1", @tbl1_id);
> > > +SELECT @tbl1_id = @tbl_id;
> > > +@tbl1_id = @tbl_id
> > > +0
> > > +SELECT @idx1_id = @idx_id;
> > > +@idx1_id = @idx_id
> > > +0
> >
> > Why `DROP INDEX idx1` ?
> >
> > As far as I remember, the point was "make VARCHAR shorter, but still
> > longer than a prefix". In this case there is no need to rebuild the
> > index, why was it rebuilt?
> >
> If we shorten the column length then whole table must be rebuild. So there
> is no need for index comparison over there.

Oh, I see.
Ok to push, then.

Regards,
Sergei
Chief Architect MariaDB
and security@xxxxxxxxxxx


References