4paradigm / 4paradigm/OpenMLDB

feat: support and validate query table with multiple-levels path

未关闭
#365 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
enhancement
主要语言
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

把新 issue 发到你的邮箱

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