Hi
repeated_contains seems to have a strange default behavior as it behaves
like a startsWith, rather than a equalTo.
With this data:
{"alist":["cat","dog"]}
{"alist":["catastrophic"]}
and this query:;
select alist from table where repeated_contains(`alist`,'cat');
both records are returned.
I do realize that repeated_contains accepts regular expressions but i
wonder if this behavior is by design or a bug. (I also know that I can end
the query string with a $ but that just does not seem right)
Regards,
-Stefan