MySQL 8.0 Labs: JSON aggregation functions

Re:MySQL 8.0 Labs: JSON aggregation functions by morgo on Thursday October 06, 2016 @04:59PM (#12656058)

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...

[ Parent | on HN ]

Re:MySQL 8.0 Labs: JSON aggregation functions by rubiquity on Thursday October 06, 2016 @05:12PM (#12656155)

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?

[ Parent | on HN ]

Re:MySQL 8.0 Labs: JSON aggregation functions by morgo on Thursday October 06, 2016 @05:46PM (#12656395)

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...

[ Parent | on HN ]

Re:MySQL 8.0 Labs: JSON aggregation functions by dcgudeman on Thursday October 06, 2016 @07:06PM (#12656875)

when did the versioning for mysql change? After 5.7?

[ Parent | on HN ]

Re:MySQL 8.0 Labs: JSON aggregation functions by morgo on Thursday October 06, 2016 @07:10PM (#12656895)

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".

[ Parent | on HN ]

Re:MySQL 8.0 Labs: JSON aggregation functions by dcgudeman on Thursday October 06, 2016 @07:21PM (#12656946)

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

[ Parent | on HN ]

Re:MySQL 8.0 Labs: JSON aggregation functions by babyrainbow on Friday October 07, 2016 @05:19AM (#12659226)

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

[ Parent | on HN ]

Re:MySQL 8.0 Labs: JSON aggregation functions by morgo on Friday October 07, 2016 @11:18AM (#12661314)

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.

[ Parent | on HN ]