Closed #1814, mysql and mariadb can use index type before ON (#1918)

Closed #1814, mysql and mariadb can use index type before ON (#1918) #112