[development] Reconciling mysql & pgsql schemas

[Jeremy Andrews]

Hi Barry,

  Cool stuff.  Just a minor random comment:

On 14 May 2007 14:23:43 -0400
Barry Jaspan <barry at jaspan.org> wrote:

> * aggregator_feed
>   o column description:
>     declared: array('type' => 'text', 'not null' => 1)
>     actual: array('type' => 'text', 'not null' => 1,
> 'default' => '')

As for MySQL, this is a bug that was fixed in 5.0.25.  By
definition, TEXT fields can't have default values:
  "TEXT and BLOB columns do not support DEFAULT values.
   However, when a default of '' was specified, the
   specification was silently ignored. This now results in a
   warning, or an error in strict mode."

Full details here:
  http://bugs.mysql.com/bug.php?id=19498

The actual source patch:
  http://lists.mysql.com/commits/9310

And a request to restore the pre-5.0.25 "feature" of allowing
DEFAULT '' on text fields that has not been accepted:
  http://bugs.mysql.com/bug.php?id=21532

Cheers,
 -Jeremy