MySQL Data Flows clarification: MySQL version & window functions (row_number)
I've neglected MySQL Data Flows because I'd passingly assumed that they were for MySQL-derived DataSets. It seems not, it looks like a MySQL DataFlow is a DataFlow that uses an embedded version of MySQL. Is this correct?
I've seen mention of Window Functions in passing, and assumed the MySQL must be 8.0+, as that's when MySQL added support for
lag(), etc. However, here's the version string I get out of MySQL inside of Domo:
So, no Window Function support.
Does anyone know if the internal MySQL is scheduled for an upgrade to 8.0+?
(Better: How about embedding Postgres as well....it's got a range of wonderful features not found in the MySQL family of SQL engines.
:: alone for casting is worth the price of admission.)
Thanks for confirmation/clarification.