[
https://issues.apache.org/jira/browse/CALCITE-3443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Julian Hyde updated CALCITE-3443:
---------------------------------
Description:
Calcite isn't able to parse the sql that there is a placeholder in select area,
like this:
{noformat}
{
"sql":"SELECT TIMESTAMPDIFF(day, CAST('2019-01-01' AS DATE), CAST(? AS
DATE))>0 as sent",
"params":[
{
"className":"java.lang.String",
"value":"2019-09-02"
}
]
}
{noformat}
We have a scenario that need to set palceholder in select area, please help to
fix that;
was:
Calcite isn't able to parse the sql that there is a placeholder in select area,
like this:
{
"sql":"SELECT TIMESTAMPDIFF(day, CAST('2019-01-01' AS DATE), CAST(? AS
DATE))>0 as sent",
"params":[
{
"className":"java.lang.String",
"value":"2019-09-02"
}
]
}
We have a scenario that need to set palceholder in select area, please help to
fix that;
> Doesn't parse PreparedStatement successfully for there are placeholders in
> select area
> --------------------------------------------------------------------------------------
>
> Key: CALCITE-3443
> URL: https://issues.apache.org/jira/browse/CALCITE-3443
> Project: Calcite
> Issue Type: Bug
> Components: core
> Affects Versions: 1.21.0
> Environment: linux, mac
> Reporter: huaicui
> Priority: Major
>
> Calcite isn't able to parse the sql that there is a placeholder in select
> area, like this:
> {noformat}
> {
> "sql":"SELECT TIMESTAMPDIFF(day, CAST('2019-01-01' AS DATE), CAST(? AS
> DATE))>0 as sent",
> "params":[
> {
> "className":"java.lang.String",
> "value":"2019-09-02"
> }
> ]
> }
> {noformat}
> We have a scenario that need to set palceholder in select area, please help
> to fix that;
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
