Get MySQL on latest version

MarkSnodgrass

Currently, Domo's MySQL is on version 5.6, which is approaching end of support. There are also a number of commonly used features that people want to use in MySQL, but can't because it is still on version 5.6. Please upgrade to the latest version.

avataraang

I use window functions all the time in redshift, but can't use them in MySQL because they weren't introduced until version 8.0

ST_-Superman-_

This needs to get implemented. MySQL 5.6 is over 8 years old. Even the latest version MySQL 8 is 3 years old.

Lewis

This really needs to move forward.. we need to be able to use CTE to optimize queries.

ST_-Superman-_

Any updates for this?

Sean_Flores

Another significant addition to later versions is the JSON parser! Probably one of the most underrated functions added that would be especially helpful for most of our source datasets coming from connectors that cant flatten nested objects or more importantly, we bring in the data still nested to keep the row count low on each call.

pydomoguy

Aside from missing windows and JSON functions in MySQL 5.6 there are security flaws to consider. This is pretty sad that we are still stuck on MySQL version 5.6.37-82.2-82.2. While I realize that Magic ETL is all that there are still a lot of people who find the MySQL dataflows to be their preference.

So I drop my token in the basket to please upgrade MySQL when possible. Hopefully in 2023.

🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

AnwarBham

Any update on this. I also noticed the ppt plugin is on .net 4.5 is this a trend