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@mariadb.org