MySQL 4.1.8 vs. 4.0.26 Compatibility
Posted: Sun Oct 30, 2005 10:15 pm
Or, to be more general, 4.0.x - 4.1.x. My server is running an older version of MySQL, 4.0, so I have to accomodate for it. I didn't think there'd be that much of a problem, until my create table queries started failing. After some rooting around, I found out that extensive Unicode support was not added until 4.1... so I have to remove all character set specific code from my table creation SQL...
http://dev.mysql.com/doc/refman/4.1/en/news-4-1-x.html offers a bit of information about the changes, but I'm not exactly sure what all these features do (especially Subqueries and derived views). Can anyone offer any tips for writing 4.0 to 4.1 compatible SQL (5.0 compatibility would be nice but not necessary).
Also... when was FOR UPDATE added to InnoDB?
http://dev.mysql.com/doc/refman/4.1/en/news-4-1-x.html offers a bit of information about the changes, but I'm not exactly sure what all these features do (especially Subqueries and derived views). Can anyone offer any tips for writing 4.0 to 4.1 compatible SQL (5.0 compatibility would be nice but not necessary).
Also... when was FOR UPDATE added to InnoDB?