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.
I find myself having to STRAIGHT_JOIN more often than I would like because it simply won’t generate sensible execution plans sometimes.
* 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...