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(at)nemo(dot)it Visitate il sito WWW.ParcoDelTicino.Pmn.It
------------------------------------------------------------------------