[
https://issues.apache.org/jira/browse/CALCITE-6002?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17764427#comment-17764427
]
Mihai Budiu commented on CALCITE-6002:
--------------------------------------
In particular, this query:
{code:sql}
SELECT CONTAINS_SUBSTR('{"foo":"bar"}', 'bar', json_scope=>'JSON_KEYS')
{code}
is unparsed as:
{code;sql}
SELECT CONTAINS_SUBSTR("P2", "P1", "P0")
FROM (VALUES ROW('JSON_KEYS', 'bar', '{"foo":"bar"}')) AS "T" ("P0", "P1", "P2")
{code}
> CONTAINS_SUBSTR does not unparse correctly
> ------------------------------------------
>
> Key: CALCITE-6002
> URL: https://issues.apache.org/jira/browse/CALCITE-6002
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.35.0
> Reporter: Mihai Budiu
> Assignee: Tanner Clary
> Priority: Minor
>
> There are in fact two bugs related to CONTAINS_SUBSTR.
> The first one is that the documentation does not render in the md file, there
> must be something wrong with the html escape sequences.
> The second one is that it does not unparse into a correct form.
> [~tanclary] I think you added this code.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
