[
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)
