4paradigm / 4paradigm/OpenMLDB
feat: support and validate query table with multiple-levels path
- 主要语言
- C++
- 星标
- 1.7k
- 派生
- 331
- 平均合并
- 12 天 12 小时
- 30 天内合并 PR
- 1
描述
**Is your feature request related to a problem? Please describe.**
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
There are some problems when users try to query a table named by multiple levels.
For example, given a statement like: `SELECT col1, col2 from db1.t1;`. We are expecting:
- there is a table `t1` under database `db1`
- the current execute-engine is running on database `db1`
Similar rules should be applied on `CREATE INDEX ... `, `CREATE PROCEDURE ... ` and other statements as well
**Describe the solution you'd like**
A clear and concise description of what you want to happen.
**Describe alternatives you've considered**
A clear and concise description of any alternative solutions or features you've considered.
**Additional context**
Add any other context or screenshots about the feature request here.
贡献指南
调研方向
该 issue 提到在 SELECT、CREATE INDEX 和 CREATE PROCEDURE 语句中查询带有多级路径(如 `db1.t1`)的表。请在 codebase 中查找 SQL parser 和 validation 逻辑,可能在 src/parser 或 src/sql 这样的目录中。需要理解 execution engine 当前如何处理 database context 和 table resolution。解决方案涉及扩展 validation,以在各类 statement types 中支持并强制执行多级路径语法。
由索引模型根据 Issue 内容生成。
评估
- 技术栈
- sql
- 领域
- backend, databases
- Issue 类型
- 功能
- 难度
- 4/5
- 预计耗时
- 3-5 天
- 活跃度
- 停滞
- 描述清晰度
- 需要澄清
- 新手友好度
- 25/100