Comment 3 for bug 655954

I'll refresh my tree and make sure. Will update / close the bug as needed.

On Wed, Oct 6, 2010 at 4:27 PM, Andrew Hutchings
<email address hidden>wrote:

> is this using latest trunk? It should have been fixed as part of bug
> #653300 merged 18 hours ago
>
> --
> Drizzledump conversion of '0000-00-00' date values to NULL can be
> problematic on NOT NULL columns
> https://bugs.launchpad.net/bugs/655954
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web
> Applications: Confirmed
>
> Bug description:
> Drizzledump converts the value '0000-00-00' into NULL when it encounters
> them in a MySQL database, however, this can cause problems when we do this
> conversion on a NOT NULL column:
>
> When attempting to migrate the attached MySQL table (provided in MySQL dump
> form) to Drizzle via drizzledump, we see errors like:
> Error executing query: Column 'col_datetime_not_null_key' cannot be null
> Error executing query: Column 'col_datetime_not_null' cannot be null
> Error executing query: Column 'col_datetime_not_null_key' cannot be null
> Error executing query: Column 'col_datetime_not_null_key' cannot be null
>
> And unpopulated tables.
>
> To unsubscribe from this bug, go to:
> https://bugs.launchpad.net/drizzle/+bug/655954/+subscribe
>