SQL syntax error when using relations in MariaDB
Does anyone else have issue similar to this one? https://github.com/drizzle-team/drizzle-orm/issues/1100
I have this issue on MariaDB 10.4 and also on 11.2. This is my schema:
I am getting error:
when doing trade query with
with: {items: true}
GitHub
[BUG] MySQL relational query syntax error · Issue #1100 · drizzle-t...
What version of drizzle-orm are you using? 0.28.3 What version of drizzle-kit are you using? 0.19.5 Describe the Bug Using MySQL and the following schema: export const tickets = mysqlTable( "t...
5 Replies
@Baterka maybe try restarting your DB
like the instance
and if that doesn't help, print the query.toSQL().sql
MariaDB doesn't support lateral queries or correlated subqueries.
The RQB uses lateral queries on mode default and correlated subqueries in planetscale mode
Also, mariaDB is not officially supported in drizzle yet
oh... so I should switch to mysql then?
Surely the support for your dialect in your favorite ORM is one of the things that go into deciding which one to use.
I mean, I am using MariaDB as MySQL compatibile alternative for years now... I do not rly want to give that up, but I really like the drizzle-orm