Bug #4990 Functional Indexes

Description:
I hope you will implement functional indexes, like PostgreSql. For example:

CREATE INDEX myindex ON mytable (MONTH(date))

or

CREATE INDEX myindex ON mytable (LEFT(REVERSE(textfield), 5))

or even:

CREATE INDEX myindex ON mytable ( CONCAT(IF(name IS NOT NULL, name, ''), ' ', surname) )

I think it would speed up seriously some searches...

How to repeat:
n/a

Suggested fix:
n/a

Thank you for a reasonable feature request.

Bug#24772 Function Based Indexes was marked a duplicate of this bug.

Bug#17496 Function-based keys - was marked a duplicate for this report.

Should be marked as duplicate of http://bugs.mysql.com/bug.php?id=14818

Bug #14818 was marked as a duplicate of this one.

Closed bug#36794 as a duplicate of this.

Also there is a community preview of Virtual Columns and functional indexes:
http://forge.mysql.com/wiki/MySQL_virtual_columns_preview

Any progress on this?

WL #411 was implemented in MySQL 5.7 (Generated columns).  The syntax is a little different from a purely functional index, but it should be feature equivalent.

Posted by developer:
 
I am closing this bug now, as generated columns (WL#411) provides a suitable alternative to functional indexes.

If you believe this to be in error, please feel free to re-open this feature request.  We would value any input that demonstrates a clear use case where generated columns are not suitable, but functional indexes are. Thanks!