4paradigm / 4paradigm/OpenMLDB

Add SQL syntax support for passing tuple to 'where in' statement

未关闭
#3,689 1 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
C++
星标
1.7k
派生
331
平均合并
12 天 12 小时
30 天内合并 PR
1

描述

**Describe the feature you'd like**

Now we can execute the sql like this.

```
select * from t1 where (gender) in (("male"));
```

But fail for this sql.

```
select * from t1 where (name, gender) in (("tobe", "male"));
```

Here is the error message.

```
W0104 11:03:18.722047 1311167296 sql_cluster_router.cc:2651] Status: [101] create logic plan tree failed--Unsupport ASTExpression StructConstructorWithParens
Error: [101] create logic plan tree failed--Unsupport ASTExpression StructConstructorWithParens
```

贡献指南

打开贡献指南

调研方向

The error points to sql_cluster_router.cc and an unsupported ASTExpression StructConstructorWithParens. Look for the logic plan tree creation code and the AST handling for WHERE IN clauses. Understand how single-column tuples are parsed versus multi-column tuples. Testing involves writing SQL with tuple syntax against the database.

由索引模型根据 Issue 内容生成。

评估

技术栈
sql
领域
databases
Issue 类型
功能
难度
4/5
预计耗时
3-5 天
活跃度
停滞
描述清晰度
描述清楚
新手友好度
40/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。