I have a field that won't return any results unless I use a wildcard at the end. Other fields match without issue on the same file and I don't see any trialing characters in the data. The behavior seems inconsistent as well since it will match on this field for other data that gets processed. I checked mysql and there seems to be no hidden characters either. Any ideas?
Example of for search with no wildcard search -c production.sphinx.conf 1234123412341234 Sphinx 0.9.9-release (r2117) Copyright (c) 2001-2009, Andrew Aksyonoff using config file 'production.sphinx.conf'... index 'document_core': query '1234123412341234 ': returned 0 matches of 0 total in 0.000 sec words: 1. '1234123412341234': 0 documents, 0 hits index 'document_delta': query '1234123412341234 ': returned 0 matches of 0 total in 0.000 sec words: 1. '1234123412341234': 0 documents, 0 hits Example with wildcard: search -c production.sphinx.conf 1234123412341234* 'Sphinx 0.9.9-release (r2117) Copyright (c) 2001-2009, Andrew Aksyonoff using config file 'production.sphinx.conf'... index 'document_core': query '1234123412341234* ': returned 4 matches of 4 total in 0.024 sec displaying matches: 4. document=123456, weight=1, sphinx_internal_id=123456, sphinx_deleted=0, class_crc=3238013752, docdata_1_sort=1297217, docdata_2_sort=8869341, docdata_3_sort=11806294, docdata_4_sort=14034299, docdata_5_sort=19046464, docdata_6_sort=19804472, docdata_7_sort=22986696, docdata_8_sort=22986698 docdata_1=JOHN DOE docdata_2=1234123412341234 docdata_3=123 SESAME ST docdata_4= docdata_5=CHICAGO, IL 60714 docdata_6=10/11/2011 docdata_7=true docdata_8=(NULL) delta=0 words: 1. '1234123412341234': 1 documents, 1 hits index 'document_delta': query '1234123412341234* ': returned 0 matches of 0 total in 0.000 sec words: 1. '1234123412341234': 0 documents, 0 hits -- You received this message because you are subscribed to the Google Groups "sphinx-dev" group. To post to this group, send email to sphinx-dev@googlegroups.com. To unsubscribe from this group, send email to sphinx-dev+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sphinx-dev?hl=en.