>The "warning: Found   22079089 parts                Should be: 0 parts" is a
>known error of myisamchk in MySQL 4.0.1, and is already fixed in MySQL 4.0.2

Thanks, Jocelyn, good to know, but the cardinality of the resulting indexes 
is STILL NULL:  hence perhaps not fixed.

So the bug report may yet remain...

-steve


mysql> use elenco2g
Database changed
mysql> show indexes from White;
+-------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+---------
+
| Table | Non_unique | Key_name    | Seq_in_index | Column_name | Collation | 
Cardinality | Sub_part | Packed | Comment
|
+-------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+---------
+
| White |          0 | PRIMARY     |            1 | rec_no      | A         | 
       NULL |     NULL | NULL   |
|
| White |          1 | phone_no    |            1 | phone_no    | A         | 
       NULL |        8 | NULL   |
|
| White |          1 | loc         |            1 | city        | A         | 
       NULL |        4 | NULL   |
|
| White |          1 | loc         |            2 | street_name | A         | 
       NULL |        2 | NULL   |
|
| White |          1 | postal_code |            1 | postal_code | A         | 
       NULL |     NULL | NULL   |
|
| White |          1 | clf         |            1 | city        | A         | 
       NULL |        6 | NULL   |
|
| White |          1 | clf         |            2 | last_name   | A         | 
       NULL |        6 | NULL   |
|
| White |          1 | clf         |            3 | first_name  | A         | 
       NULL |        1 | NULL   |
|
| White |          1 | plf         |            1 | province    | A         | 
       NULL |     NULL | NULL   |
|
| White |          1 | plf         |            2 | last_name   | A         | 
       NULL |        7 | NULL   |
|
| White |          1 | plf         |            3 | first_name  | A         | 
       NULL |        2 | NULL   |
|
| White |          1 | pref        |            1 | prefix      | A         | 
       NULL |     NULL | NULL   |
|
| White |          1 | pref        |            2 | city        | A         | 
       NULL |        1 | NULL   |
|
+-------+------------+-------------+--------------+-------------+-----------+-------------+----------+--------+---------
+
13 rows in set (0.07 sec)
 

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to