Drizzle Team•13mo ago

mysql 5.7.4 lateral issues

Mysql 5.7.4 doesn't include the lateral joins which is the default for drizzle query builder. Is there anyway to tell drizzle not to use lateral joins so I can use the query builder?

3 Replies

SacredAIOP•13mo ago

It also appears that row_number() isn't available

Angelelz•13mo ago

Yes, you can pass { mode: "planetscale" } to the drizzle function and it will use subqueries

SacredAIOP•13mo ago

thats where this issue came from

Gaming

Programming

mysql 5.7.4 lateral issues