Jackie-Jiang commented on issue #10609: URL: https://github.com/apache/pinot/issues/10609#issuecomment-1515535457
Seems `ILIKE` is not in the SQL standard, but a PostgreSQL extension, and I cannot find it under the Calcite `SqlKind`. Different database have different behavior on `LIKE` (I tried the [engine](https://www.w3schools.com/sql/sql_like.asp) in W3 School and it is case insensitive). Since it is not standard SQL, we should discuss if we want to follow the PostgreSQL behavior. cc @siddharthteotia @jadami10 -- 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]
