"Behrang Saeedzadeh" <behrangsa@gmail.com> writes:
> Actually I read in a blog that this works in PostgreSQL (the author
> expected this) and not in MySQL. But to me, the way MySQL is handling
> this looks more reasonable.
MySQL's way of doing things is seldom reasonable. In the example
given, they are clearly inventing a default value out of thin air.
There is *no* support for that in the SQL spec.
regards, tom lane