>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
