drizzle-orm icon indicating copy to clipboard operation
drizzle-orm copied to clipboard
verified publisher icon drizzle-team

BUG FIX #3623 Change the mode of the TiDB driver query builder to 'Planetscale'

Open inaridiy opened this issue 1 year ago • 1 comments

Related Issue https://github.com/drizzle-team/drizzle-orm/issues/3623

Relational queries fail in TiDB because it does not support the LEFT JOIN LATERAL syntax. To address this, I have enabled the "planetscale" mode, originally designed for Planetscale (which also does not support LEFT JOIN LATERAL), to generate compatible queries that avoid using this syntax.

The change is only one line, but it is working in my app now!

inaridiy avatar Nov 27 '24 03:11 inaridiy

@AndriiSherman @dankochetov Oh, I forgot to sign the commit, so I added it. Could you check this PR again?

inaridiy avatar Dec 07 '24 15:12 inaridiy