Description
Based on customer feedback, we should make
some_expr LIKE '%pattern%' |
work faster. It should automatically use a SUFFIXES( some_expr ) index if one exists.
LIKEwise, we need a function or keyword that uses a TOKENS( some_expr ) index.
HAS_TOKEN( some_expr, 'token' ) |
Attachments
Issue Links
- blocks
-
MB-22188 4.6.2 Minor Release
- Closed
For Gerrit Dashboard: MB-22470 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
72485,2 | MB-22470. Fast pattern matching for LIKE and HAS_TOKEN(). | master | query | Status: MERGED | +2 | +1 |
72557,2 | MB-22470. Alias HAS_TOKEN() to CONTAINS_TOKEN(). | master | query | Status: MERGED | +2 | +1 |
73400,2 | MB-22470. Fast pattern matching for LIKE and HAS_TOKEN(). | watson++ | query | Status: MERGED | +2 | +1 |
73401,2 | MB-22470. Alias HAS_TOKEN() to CONTAINS_TOKEN(). | watson++ | query | Status: MERGED | +2 | +1 |