Lately i’ve been developing with MySQL3, and it’s almost like hitting your head against a brick wall with its limitations and specific documentation is difficult to find.
Some of the limitations:
Subqueries. ’select id from t where grp in (select grp from g where u > 100)’
Add DISTINCT to Aggregates
JOINs with ambiguous columns causes a [...]