4paradigm / 4paradigm/OpenMLDB

use default database in subquery not support in offline

Open
#3,683 0 comments 0 reactions 1 assignee Claimed by @tobegit3hub View on GitHub
bug
Dominant language
C++
Stars
1.7k
Forks
331
Avg merge
12d 12h
Merged PRs (30d)
1

Description

## create table in db1, then select subquery in db

db: db1
table: t1
columns : ["c1 string","c2 int","c3 bigint","c4 timestamp"]
indexs: ["index1:c1:c4"]
rows:
- ["aa",2,3,1590738989000]
- ["bb",21,31,1590738990000]
- ["cc",41,51,1590738991000]
` sql: select db.t2.c1 from (select c1, c2+1,c3+1 from db1.t1) as t2;`

Contributor guide

Open the contributing guide

Research direction

The issue describes a subquery referencing a default database not being supported in offline mode. Start by examining the SQL parser and query planner for handling database qualifiers in subqueries, particularly in offline execution. Look for existing tests related to subqueries and database context to understand the expected behavior. Verify the fix by running the provided SQL example in offline mode.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases, machine-learning
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.