| Subject | RE: [firebird-support] conversion error from string " " |
|---|---|
| Author | Helen Borrie |
| Post date | 2004-12-19T01:27:58Z |
At 08:18 AM 19/12/2004 +1100, Alan McDonald wrote:
nulls. Null means "unknown" so it can't participate in a test for
uniqueness. That's why, in previous versions, you couldn't put a unique
index or constraint on a nullable column. Consult the 1.5 release notes to
see how the engine works it out.
The problem encountered here is a parsing error that appears to have been
fixed in v.1.5.2.
./hb
>that's 1213 duplicates as far as a unique index is concernedNo, it's 1213 nulls. Unique indexes in 1.5 are allowed to include
nulls. Null means "unknown" so it can't participate in a test for
uniqueness. That's why, in previous versions, you couldn't put a unique
index or constraint on a nullable column. Consult the 1.5 release notes to
see how the engine works it out.
The problem encountered here is a parsing error that appears to have been
fixed in v.1.5.2.
./hb