I've just updated our dev civicrm installation from 4.5.4 to 4.6.6. Now, searches on custom fields of type 'Yes or No' are producing weird results.
Eg, In a custom dataset for some specific membership types we have a variety of Yes or No fields. The database appears to have the correct data in it as compared between our updated dev and our live sites.
However, in the dev site, a search of memberships for 'display on website' produces 93 results for Yes, 93 for No and 93 for 'Yes or No'!! There are 861 results in the db according to phpMyAdmin!!! Yikes!
On the live site, the same search yields 892 for Yes, 91 for No and 983 for 'Yes or No'. There are 901 results in the db table according to phpMYAdmin. (The diff here could be some contacts are deleted, also we don't expect the dev site and live to be exactly the same.)
I've done the same membership search on a variety of custom boolean fields and they all show the same very weird results on the dev site; the same number for yes, for no and for 'yes or no'. In the db the field has many, many more results than the membership search.
Any help on this would be much appreciated!
