[MySQL] Functional/Expression indexes fail to migrate

[shubham-yb]

When we have a schema which contains Functional/Expression indexes in MYSQL, during the migration the index creation fails with a syntax error and the index doesn't get migrated.

Example:

Source schema:

create table func_check (
	id int primary key auto_increment,
	first_name VARCHAR(50),
	last_name VARCHAR(50)
);

CREATE INDEX idx_last_name ON func_check((lower(last_name)));

Exported Index:

CREATE INDEX idx_last_name ON func_check (lower(`last_name`));

Suggested changes:

Remove the backticks "" ` "" from the exported files.

CREATE INDEX idx_last_name ON func_check (lower(last_name));