FULLTEXT indexes

i have a table with a FULLTEXT index that correctly matches certain words: mysql> select title from movie where title like 'little%'; ++ | title | ++ | Little Fugitive| | Little Kidnappers, The | | Little Mermaid, The| |

UNIQUE with NULL columns

with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL values still reject rows that are the same? this isn't working (it allows duplicate rows to be included if one of the columns is NULL). this seems wrong. here's an example: mysql> create table n ( i