Re: [GENERAL] More details on Database corruption

On Thu, 13 Aug 1998, George Kousi wrote:

> CREATE TABLE tasks (
> task  INT4 NOT NULL,
> job  INT4 NOT NULL,
> Version1 CHAR(6) DEFAULT '',
> Version2 CHAR(6) DEFAULT '',
> Version3 CHAR(6) DEFAULT '',
> Version4 CHAR(6) DEFAULT '',
> Version5 CHAR(6) DEFAULT ''
> );

A zero-length string ('') is not a valid default value for a CHAR(6).
I replaced it with '      ' (six blanks) and all runs fine.

I run 6.3.1 on Linux 2.0.27 and your script fails on the first insert
without corruption problems.  I don't know why it only fails on update on
your system.

Regards - guido

------------------------------------------------------------------------
// Guido Carlo Piazzi                       Accompagnatore naturalistico
// gpiazzi@nemo.it            Visitate il sito WWW.ParcoDelTicino.Pmn.It
------------------------------------------------------------------------