LOAD INDEX INTO CACHE problem

[Geilson Coutinho Figueiredo]

Hi,

   I'm trying to load an index into cache hot_cache, but it is not 
working. Here is my step to step:

CREATE TABLE GEILSON (CPF VARCHAR(14) NOT NULL, NAME VARCHAR(75) NOT 
NULL, PRIMARY KEY (CPF), FULLTEXT (NAME));
INSERT INTO GEILSON (CPF,NAME) VALUES (08238512786, "DAVID ESCODINO");
INSERT INTO GEILSON (CPF,NAME) VALUES (05233113783, "JAMES SCOTT");

SET GLOBAL hot_cache.key_buffer_size = 128*1024*1024;
CACHE INDEX GEILSON IN hot_cache;
LOAD INDEX INTO CACHE GEILSON;
  
   I'm getting this error:
+---------------+--------------+----------+-----------------------------------+
| Table         | Op           | Msg_type | 
Msg_text                          |
+---------------+--------------+----------+-----------------------------------+
| NATT.GEILSON  | preload_keys | error    | Indexes use different block 
sizes |
| NATT.GEILSON  | preload_keys | status   | Operation 
failed                  |
+---------------+--------------+----------+-----------------------------------+

      I use mysql on Redhat 9.0. My version:

# mysqld --version
mysqld  Ver 4.1.1-alpha-standard for pc-linux on i686 (Official MySQL RPM)
      What's the problem?

      Sincerelly,
      Geilson C. F.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]