jfield,
Thursday, October 10, 2002, 1:33:10 AM, you wrote:
jazdc> >Description:
jazdc> After adding a key to a nullable column, null values will
jazdc> successfully join through to null values in other tables.
jazdc> This only seems to happen when the index is added after
jazdc> the row contains
jfield,
Thursday, October 10, 2002, 1:33:10 AM, you wrote:
jazdc> After adding a key to a nullable column, null values will
jazdc> successfully join through to null values in other tables.
jazdc> This only seems to happen when the index is added after
jazdc> the row contains null values. This af
It looks like a bug. I was able to repeat it and I had different results for the same
join depending on when index was added and values of actual data in tables.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 6:33 PM
To: [EMAIL PRO
: Thursday, October 10, 2002 9:45 AM
To: [EMAIL PROTECTED]
Subject: Re: NULL sometimes joins to NULL
>From: [EMAIL PROTECTED]
>
>After adding a key to a nullable column, null values will
>successfully join through to null values in other tables.
And this is a problem because? :-)
Seriously,
>From: [EMAIL PROTECTED]
>
>After adding a key to a nullable column, null values will
>successfully join through to null values in other tables.
And this is a problem because? :-)
Seriously, it may be a bug, but IMHO it is a design flaw to index a NULL field.
Indexed fields should always be NOT