KiteSQL

KiteSQL copied to clipboard

## Feature Request >TODO: When the case is select * from t1 where (c1 = 7 or c1 = 10) and c2 < 2;, the range is (-inf, (10, 2)),...

KKould

Fix: the fields output by Using are not determined by JoinType

1

## Bug Report ``` statement ok CREATE TABLE onecolumn (id INT PRIMARY KEY, x INT NULL) statement ok CREATE TABLE empty (e_id INT PRIMARY KEY, x INT) statement ok INSERT...

KKould

## Feature Request ``` statement ok CREATE TABLE onecolumn (id INT PRIMARY KEY, x INT NULL) statement ok CREATE TABLE empty (e_id INT PRIMARY KEY, x INT) statement ok INSERT...

KKould

## Feature Request supports a remote KV cluster as an optional storage engine Tips: I imagine that in the future as an distributed database, I may reuse Scala to write...

KKould

## Feature Request cache the results of `RangeDetacher::detach` to avoid repeated detach Tips: only works for a single query, so use `HashMap`

KKould

Feat: Support correlated subqueries

4

## Feature Request there is something wrong when binding correlated subqueries because parent context is ignored. ```sql explain select a,b from t where a in (select a from t1 where...

crwen

Reduce performance issues caused by `Build Plan`

3

## Feature Request I try to perform this case in a table with 200,000 rows: `select * from t1 where c1 > 500 and c1 < 1000`, and use pprof-rs...

KKould

## Feature Request > - TODO: Support VIEW & CREATE VIEW & DROP VIEW > - TODO: EXCEPT with VIEW > - TODO: WHERE, GROUP BY, and HAVING clauses supported...

KKould

Feat: Support `TopK` on `Order By ... Limit ...`

3

## Feature Request When `OrderBy .. Limit ..` exists, the `TopK` operator will be used Tips: `TopK` should also use index

KKould

## Feature Request Index arranges data in ascending order, so when OrderBy...ASC, is it possible to remove the Order Operator and convert SeqScan to IndexScan (it cannot be executed if...

KKould