If a node has an autocomplete freetagging field with number of values > 1, each time a node of it's type is created duplicate rows are added to the table responsible of the field.

The number of duplicate entries is the same as the number of values and their value is NULL. This results in unfixable duplicate entries in views.

To reproduce (very simple, no abnormal names, configuration or values required; "foo" and "bar" will do):

1. Install Drupal 6 last version + CCK last (development or not) version

2. Create a taxonomy vocabulary with a buch of terms (doesn't matter the names or values, "foo" and "bar" will do).

3. Create a custom content type and add an Autocomplete (Freetagging) CCK field to it. Set "Number of values" to a number > 1 example: 3, and check "Allow and insert new terms by the user into the vocabulary" Select the vocabulary you created in "Global Settings".

4. After we are done with or cck field, create a new content of that type, but just add 1 value to the freetagging field.

4. Check the mysql table responsible for that field. Undesired duplicate rows are added.

5. Create a view with a filter where the type is only the one created. Duplicate rows will appear. Expected results: no duplicate rows!