[jira] [Comment Edited] (CALCITE-7673) Add support for the LIKE operator to the MongoDB adapter

["Yu Xu (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-7673?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18101179#comment-18101179 ] 

Yu Xu edited comment on CALCITE-7673 at 8/3/26 2:03 AM:
--------------------------------------------------------

Thanks for pointing this out [~julianhyde] ; the wording was indeed a bit vague. I’ve changed the Jira title to "Add support for the LIKE operator to the MongoDB adapter," which should clearly convey the topic of the issue and the Jira description has also been updated.


was (Author: JIRAUSER307770):
Thanks for pointing this out [~julianhyde] ; the wording was indeed a bit vague. I’ve changed the Jira title to "Add support for the LIKE operator to the MongoDB adapter," which should clearly convey the topic of the issue.

> Add support for the LIKE operator to the MongoDB adapter
> --------------------------------------------------------
>
>                 Key: CALCITE-7673
>                 URL: https://issues.apache.org/jira/browse/CALCITE-7673
>             Project: Calcite
>          Issue Type: Improvement
>          Components: mongodb-adapter
>    Affects Versions: 1.42.0
>            Reporter: Yu Xu
>            Assignee: Yu Xu
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 1.43.0
>
>
> Currently MongoDB Adapter not support LIKE operator.
> sql:
> {code:java}
> select state, city from zips where state like 'A%' order by state;{code}
> would error out:
> {code:java}
> java.lang.AssertionError: cannot translate LIKE(CAST(ITEM($0, 'city')):VARCHAR(20), 'A%')  {code}
> However, MongoDB can achieve SQL-like `LIKE` semantics using `$regex`. we can refer：[https://www.mongodb.com/docs/manual/reference/operator/query/regex/#mongodb-query-op.-regex]
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)