When using “like” in a filter I am getting odd results when the pattern starts with “%” and the match starts with the first character in the string. For example, if:
- My filter looks like “filter=region like %BayArea%”
- The database contains one record whose “region” field contains “BayArea Denver”
the record is not returned in a “get” request. However, if my filter looks like “filter=region like BayArea%” the record is returned as expected.
This seems like it goes against the SQL definition for % where % is supposed to match zero, one, or more characters. Here it seems that % matches one or more, but not zero.