[development] Reconciling mysql & pgsql schemas

Jeremy Andrews lists at kerneltrap.org
Mon May 14 18:41:27 UTC 2007

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:

The actual source patch:

And a request to restore the pre-5.0.25 "feature" of allowing
DEFAULT '' on text fields that has not been accepted:


More information about the development mailing list