Are check constraints being introduced in 5.0 of MySQL? I saw some webpages that seem to say that's the case, but when doing a search on the MySQL website, no hits seem to come up for check constraints.
Have check constraints already been introduced, or are they planning to be introduced anytime soon?
It seems like a pretty basic and commonly used feature, so I'm surprised that it's not present in MySQL...what do you do to get around it? Triggers?
When you say application code, you mean assume that the DB has 'unchecked' data (i.e. not passed through CHECK constraint, such as assuming a number is less than 1000), and instead check for the values in the application code itself?