Hi,

I am using Search API with a MySQL database.

I have my dates stored as a text in the format of 'yyyy-mm-dd' and it's indexed as a fulltext field.

When I do a search for start date '1950-03-09' it returns some content that contains dates like '1950-10-30' and '1950-09-13'.

http://nsf-biomuseums.eeb.lsa.umich.edu/drupal/?q=search-specimen&field_...

But if I do a search on '1959-11-14', it works fine.

http://nsf-biomuseums.eeb.lsa.umich.edu/drupal/?q=search-specimen&field_...

I'm thinking the hyphen followed by a 0 is causing it to behave weird.

Any ideas on how to debug or work around the issue?

Thanks!!

Comments

dunen created an issue. See original summary.

drunken monkey’s picture

Category: Bug report » Support request

I have my dates stored as a text in the format of 'yyyy-mm-dd' and it's indexed as a fulltext field.

Why? Wouldn't "String" be much more appropriate here?

tremor’s picture

I have product part number "x3c07f1-02" which behaves similarly, the search returns all occurrences of the single digit "2" even though i have 3 character partial matching set.

drunken monkey’s picture

For this, turning off the "Tokenizer" processor (or tweaking its settings) might resolve this. (Unless you're using Solr – play around with the Solr configs in that case.)