What versions of MySQL are supported? I have JSON_ARRAYAGG issues with 5.7 and AWS Aurora Serverless

Can you confirm what versions of MySQL you intend on supporting? Relational queries with joins use JSON_ARRAYAGG which is not supported by earlier versions of 5.7 including AWS Aurora Serverless v1.

Ddaniel Can you confirm what versions of MySQL you intend on supporting? Relational quer...

Yordi•5/30/23, 10:57 PM

Damn, after hours of searching you made me realise I was on MySQL v5.7 (using MAMP)
I spend hours getting strange errors and I had no clue relational queries needed a higher version.

I can't answer your question but thanks for making me realise this

danielOP•6/12/23, 4:45 AM

@yordiv Just a note that I've patched drizzle to replace with and to get it wotking with my version of 5.7. This may be helpful for you.

Ddaniel @yordiv Just a note that I've patched drizzle to replace `JSON_ARRAYAGG` with `c...

Yordi•6/12/23, 7:01 AM

Great to hear that! Thanks