Hi!
On Jan 23, Dave Rolsky wrote:
> Here's a recipe:
>
> create table foo (foo text, bar text);
>
> create fulltext index foo on foo (foo, bar);
>
> mysql> show index from foo;
>
> +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
> | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation |
> Cardinality | Sub_part | Packed | Null | Index_type | Comment |
>
> +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
> | foo | 1 | foo | 1 | foo | A |
> NULL | 1 | NULL | YES | FULLTEXT | |
> | foo | 1 | foo | 2 | bar | A |
> NULL | 1 | NULL | YES | FULLTEXT | |
>
> +-------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
>
> Sub_part should be NULL for both of these columns.
>
> The same thing happens for a single column fulltext index.
Fixed.
Regards,
Sergei
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
