Will Du created CALCITE-6840:
--------------------------------
Summary: Join column seems got truncated during join
Key: CALCITE-6840
URL: https://issues.apache.org/jira/browse/CALCITE-6840
Project: Calcite
Issue Type: Bug
Components: avatica, jdbc-adapter, jdbc-driver
Affects Versions: 1.38.0
Reporter: Will Du
I register Azure SQL and Druid schema using the jdbc client so that I can join
Azure table a with druid table b as follows.
```
with base as (
select
concat(name, entity, pid) as join_key, * from a
)
select
base.*, b.vaue
from base left join b on a.join_key = b.join_key
```
1. When the join_key length > 30, the join is unsuccessful (b.value is empty)
even if the join key is matched.
2. If I use hardcoded string as join_key, it always works
3. if I add cast before join, such as cast(a.join_key as varchar(500)) =
b.join_key, it is working
4. When the join_key is <= 30, it is working.
5. The join_key is displayed without issues no matter what is the length
6. Only impact the join result.
Pls. investigate or try to reproduce the issue, Lex=Java, Fun=standard,mssql
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
