Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

从1.2.3开始不支持clickhouse的array join #5756

Closed
zoro000 opened this issue Mar 6, 2024 · 1 comment
Closed

从1.2.3开始不支持clickhouse的array join #5756

zoro000 opened this issue Mar 6, 2024 · 1 comment

Comments

@zoro000
Copy link

zoro000 commented Mar 6, 2024

测试如下:
#创建表 mr_tbl
CREATE TABLE mr_tbl
(
id UInt8,
name String,
age Int,
local Array(String)
)
ENGINE = MergeTree()
ORDER BY id
#向表mr_tbl中插入数据
insert into table mr_tbl values (1,'zs',18,['beijing','shanghai']),(2,'ls',19,['guangzhou','hangzhou']),(3,'ww',20,[]);
#查询
SELECT id,name,age,local FROM mr_tbl ARRAY JOIN local
#报错
Cause: java.sql.SQLException: sql injection violation, dbType clickhouse, , druid-version 1.2.8, syntax error: not supported.pos 382, line 15, column 50, token IDENTIFIER ARRAY

@lizongbo
Copy link
Collaborator

lizongbo commented Jun 3, 2024

最新代码已经支持解析,等1.2.24版本验证

@lizongbo lizongbo closed this as completed Jun 3, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants