DT
Drizzle Teamdanielsharvey

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.
Yordi
Yordi•354d ago
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 🙏
danielsharvey
danielsharvey•342d ago
@yordiv Just a note that I've patched drizzle to replace JSON_ARRAYAGG with concat and group_concat to get it wotking with my version of 5.7. This may be helpful for you.
Yordi
Yordi•341d ago
Great to hear that! Thanks 🥳
Want results from more Discord servers?
Add your server
More Posts
`$with` example in docs error "unsupported: with expression in select statement"I have a user with id of 42, just like the docs https://orm.drizzle.team/docs/crud#with-clause but Infer type for relational queryIs there anyway to infer the type of a relational queries result? For example if I have a user who in drizzle.config.ts: "Cannot use import statement outside a module"happens when I try to `push` ```ts import type { Config } from "drizzle-kit"; import { env } from "Error when using Drizzle (Non-abstract class 'PgSelect<TTableName, TSelection, TSelectMode, [...])I'm getting the following error when I try to use Drizzle: ```> graphql-server@1.0.0 start > npm runGenerate classes/interfaces from existing schemas?Messing around with drizzle, and I was wondering if there was any way to generate a class or interfaRelation Query - Get likes in postPlaying around with relational queries and I'm not quite getting how I'd retrieve the count of likesRelation query `extras` needs access to `with`I have a mysql table with two relations to another table. (one is for source values, one is for optiOptional filter param, coalesce to true?Is there a way to achieve this coalescing technique, but in valid drizzle sql? ```ts const filterBy