10 messages in com.mysql.lists.mysqlRe: Trouble with HEAP table and index...
FromSent OnAttachments
Brien Voorhees13 Dec 1999 11:36 
Scott Hess13 Dec 1999 11:55 
Brien Voorhees14 Dec 1999 11:13 
Sasha Pachev14 Dec 1999 12:45 
Brien Voorhees14 Dec 1999 13:07 
Brien Voorhees14 Dec 1999 13:20 
Steve Ruby14 Dec 1999 13:29 
Brien Voorhees14 Dec 1999 13:39 
Sasha Pachev14 Dec 1999 13:44 
Michael Widenius11 Jan 2000 02:11 
Subject:Re: Trouble with HEAP table and index usage
From:Steve Ruby (ste@seawingsub.com)
Date:12/14/1999 01:29:13 PM
List:com.mysql.lists.mysql

Brien Voorhees wrote:

I forgot to mention, the version of MySQL I'm using is 3.22.28 on Win32.

Huh, did I miss something, you said you are having problems with heap tables. I ran your create table and query against 3.23.5a for windows and got only one result also.

but heap tables aren't supported in 3.22.x. But I ran your query anyway and it creates the table (ignores the type part) and the query actually returns the proper results.

I must admit I was curious, but now I'm confused :(