[morgo]

MySQL Product Manager here.

For a more general overview of 8.0, see: http://mysqlserverteam.com/the-mysql-8-0-0-milestone-release...

This feature is part of the optimizer labs release, which also includes CTEs: http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-t...

[rubiquity]

Wow! That's a lot of cool stuff! MySQL seems to really be alive lately. Did Oracle decide to give it more attention?

We're very happy with 5.7 right now and 8.0 looks great. Our app is quite old so invisible indexes will be awesome for finding what we can get rid of.

When will the JSON and CTEs make it into "proper" MySQL?

[morgo]

The engineering team is 2x the size that it was at the time of the Oracle acquisition. 8.0 is the release where some of the investments are starting to pay off :)

Invisible indexes was one of my FRs, so very happy to hear you like it. For others: http://mysqlserverteam.com/mysql-8-0-invisible-indexes/

Labs are merged into regular trunk when they pass QA qualification. A list of what is involved is here: http://anithagopi.blogspot.ca/2013/05/new-feature-qualificat...

[dcgudeman]

when did the versioning for mysql change? After 5.7?

[morgo]

Yes. We wanted to be able to drop the leading 5. For context:

6.0 was a canceled release. 7.x. is used by Cluster. 8.0 makes it easy to follow as "it just drops the 5".

[dcgudeman]

Thanks for the quick reply, looks like a great release!

[babyrainbow]

Can MySQL queries refer to a temporary tables more than once in the same query, yet?

[morgo]

This limitation had to be lifted for CTEs to be reused, which is in the same labs release as the JSON functions mentioned here.

I haven't checked yet if it is lifted for CTEs only, or all cases. But CTEs are a replacement for most (all?) uses of temporary tables that I can think of.