SQL comments - commenting out code for earlier versions
In MySQL, it's possible to comment out portions of code that you only want to work in specific MySQL versions:
i.e. CREATE DATABASE /*!32312 IF NOT EXISTS*/ `a` /*!40100 DEFAULT CHARACTER SET latin1 */;
The problem with this, is that the decimal point is omitted - and there's a real assumption that with something like 3.23.12 the "12" portion never exceeds 99.
When I look at 5.0, MySQL is currently at 5.0.60 - and there are still minor changes happening. 5.1 is at 5.1.25, and not even GA. Assuming that 5.1 does the same community/enterprise split and shuffles through releases in even numbers, how long will it take before we have 5.1.100?
If we do get there, the SQL commenting feature will need upgrading.
![[info]](http://l-stat.livejournal.com/img/userinfo.gif){kind=small}
mtocker) wrote,
