4paradigm / 4paradigm/OpenMLDB
Add SQL syntax support for passing tuple to 'where in' statement
- 主要语言
- 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