You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Lookup on player where player.name contains toLower(“L”) yield player.name,player.age
The contains clause cause the full-table scan full-text index, because the contained string may be in the middle position of the whole string.
In the future, we need consider whether contains supports regular expressions?
In addition, other string comparison functions have similar problems, such as ends with.
The text was updated successfully, but these errors were encountered:
Lookup on player where player.name contains toLower(“L”) yield player.name,player.age
The contains clause cause the full-table scan full-text index, because the contained string may be in the middle position of the whole string.
In the future, we need consider whether contains supports regular expressions?
In addition, other string comparison functions have similar problems, such as ends with.
The text was updated successfully, but these errors were encountered: