fritzb opened a new issue #7657:
URL: https://github.com/apache/pinot/issues/7657
LIKE is currently implemented as wildcard match. It should be exact match
unless there is '%'.
For instance, I have the following rows:
name
------
test.mapmaking.length
mapmaking.length
mapmaking
LIKE 'mapmaking' will match all 3 rows. In SQL compliant, it should match
row 3 ('mapmaking').
LIKE 'mapmaking%' should match 2 rows, 'mapmaking.length' and 'mapmaking'
LIKE '%mapmaking%' should match all 3 rows
LIKE 'test.%' should match 1 row (test.mapmaking.length)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
