[wbercx]

What sort of quirks have you run into?

I find myself having to STRAIGHT_JOIN more often than I would like because it simply won’t generate sensible execution plans sometimes.

[cies]

so many. just some of the top of my mind:

* sub-query needs to be wrapped in a sub-query

* we had an issue recently (dont have the link at hand) where mysql team closed the bug as fixed but only documented it as a "know issue". we had to split up one query in 5 queries to fix this

* ask Lucas Eder what is a better db, he has intimate experience with all of 'm

Here are some we also run into:

https://www.codementor.io/@goetas/why-i-prefer-postgresql-to...