Kould

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...

## 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...

## 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...

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

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...

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

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

## 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...

RBO rules supplement

1

## Feature Request - max-min-eliminate - ref: https://docs.pingcap.com/zh/tidb/stable/max-min-eliminate - correlated-subquery-optimization - ref: https://docs.pingcap.com/zh/tidb/stable/subquery-optimization - predicate-pushdown - outer -> inner, ref: [link](https://cn.pingcap.com/blog/tidb-source-code-reading-7/#:~:text=%E9%A6%96%E5%85%88%E4%BC%9A%E5%81%9A%E4%B8%80%E4%B8%AA%E7%AE%80%E5%8C%96%EF%BC%8C%E5%B0%86%E5%B7%A6%E5%A4%96%E8%BF%9E%E6%8E%A5%E5%92%8C%E5%8F%B3%E5%A4%96%E8%BF%9E%E6%8E%A5%E8%BD%AC%E5%8C%96%E4%B8%BA%E5%86%85%E8%BF%9E%E6%8E%A5%E3%80%82) - outer_join_eliminate - ref: https://cn.pingcap.com/blog/tidb-source-code-reading-21/ - aggregation_push_down - ref:...

## Feature Request If you want to contribute code to KiteSQL and find requirements, you can refer to the following list The corresponding test files are attached under the requirements...