[
https://issues.apache.org/jira/browse/CALCITE-5133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
itxiangkui updated CALCITE-5133:
--------------------------------
Description:
||channel||gettime||
|c1|2022-04-27 00:00:00|
|c2|2022-04-27 00:00:00|
|c3|2022-04-27 00:00:00|
|c4|2022-04-27 00:00:00|
|c5|2022-04-27 00:00:00|
|c6|2022-04-27 00:00:00|
{code:java}
select channel
from xxx
where gettime>='2022-04-27 00:00:00'
and gettime<='2022-04-27 14:00:00'
and channel in ('c1','c2'....'c20')
| JdbcToEnumerableConverter
JdbcProject(channel=[$0])
JdbcJoin(condition=[=($0, $2)], joinType=[inner])
JdbcProject(channel=[$11], gettime=[$38])
JdbcFilter(condition=[SEARCH($38, Sarg[[2022-04-27 00:00 |{code}
{code:java}
select channel
from`tidb_noah_mars`.`noah_global`.`mpays`
where gettime>='2022-04-27 00:00:00'
and gettime<='2022-04-27 14:00:00'
and channel in ('c1','c2'...'c19')
| JdbcToEnumerableConverter
JdbcProject(channel=[$11])
JdbcFilter(condition=[AND(SEARCH($38, Sarg[[2022-04-27 00:00:00..2022-04-27
14:00:00]]), SEARCH($11, Sarg[_UTF-8'360_assistant':VARCHAR(14) CHARACTER SET
"UTF-8" |{code}
> JdbcValues lost some values when the value of in was more than 20
> -----------------------------------------------------------------
>
> Key: CALCITE-5133
> URL: https://issues.apache.org/jira/browse/CALCITE-5133
> Project: Calcite
> Issue Type: Bug
> Reporter: itxiangkui
> Priority: Major
>
>
>
> ||channel||gettime||
> |c1|2022-04-27 00:00:00|
> |c2|2022-04-27 00:00:00|
> |c3|2022-04-27 00:00:00|
> |c4|2022-04-27 00:00:00|
> |c5|2022-04-27 00:00:00|
> |c6|2022-04-27 00:00:00|
>
> {code:java}
> select channel
> from xxx
> where gettime>='2022-04-27 00:00:00'
> and gettime<='2022-04-27 14:00:00'
> and channel in ('c1','c2'....'c20')
> | JdbcToEnumerableConverter
> JdbcProject(channel=[$0])
> JdbcJoin(condition=[=($0, $2)], joinType=[inner])
> JdbcProject(channel=[$11], gettime=[$38])
> JdbcFilter(condition=[SEARCH($38, Sarg[[2022-04-27 00:00 |{code}
>
> {code:java}
> select channel
> from`tidb_noah_mars`.`noah_global`.`mpays`
> where gettime>='2022-04-27 00:00:00'
> and gettime<='2022-04-27 14:00:00'
> and channel in ('c1','c2'...'c19')
> | JdbcToEnumerableConverter
> JdbcProject(channel=[$11])
> JdbcFilter(condition=[AND(SEARCH($38, Sarg[[2022-04-27
> 00:00:00..2022-04-27 14:00:00]]), SEARCH($11,
> Sarg[_UTF-8'360_assistant':VARCHAR(14) CHARACTER SET "UTF-8" |{code}
>
>
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
