[GitHub] [pinot] fritzb opened a new issue #7657: LIKE predicate matching is non SQL compliant

[GitBox <gi...@apache.org>]

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: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org

[GitHub] [pinot] Jackie-Jiang closed issue #7657: LIKE predicate matching is non SQL compliant

[GitBox <gi...@apache.org>]

Jackie-Jiang closed issue #7657:
URL: https://github.com/apache/pinot/issues/7657


   


-- 
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: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org