Re: Indexing with NULL in column - Thimble Smith - com.mysql.lists.mysql

3 messages in com.mysql.lists.mysqlRe: Indexing with NULL in column

From	Sent On	Attachments
Ken Cobler	21 Apr 1999 15:36
Thimble Smith	21 Apr 1999 15:43
Michael Widenius	21 Apr 1999 20:03

Subject:	Re: Indexing with NULL in column
From:	Thimble Smith (ti...@desert.net)
Date:	04/21/1999 03:43:25 PM
List:	com.mysql.lists.mysql

On Wed, Apr 21, 1999 at 05:36:59PM -0500, Ken Cobler wrote:

If the solution is to work on the isam code, to allow indexing on columns with NULLs, I'm willing to work on that code.

The new ISAM is being developed; once it's done, indexing on columns containing NULL values will follow. But it will require a change in the ISAM format, so that means it's a 4.x change, no matter if you do it or TcX does it.

Is there any way for you to use a non-NULL value in those tables, without rewriting all of your applications?

Tim