3 ms·
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 p
by wbercx 2y ago
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 2y agoso 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-mysql-hikp0wbu6 https://www.codementor.io/@goetas/why-i-prefer-postgresql-to...