Kould comments

Results 44 comments of


                                            Kould

Perf: TPCC

> I would like to claim this issue. Please do whatever you want, I will post the relevant PR/issue in this issue

unique constraint error with INSERT (1), (2)

I tried to reproduce the problem using this code, but the problem has been solved ```rust #[test] fn test_unique_insert() -> anyhow::Result { let _ = env_logger::try_init(); let tmp_db = TempDatabase::new("CREATE...

feat: use covering indexes

the current CI error is because `select id, age from users where age > 90 limit 1;` does not use the index, so its results are inconsistent with the results...

feat: use covering indexes

@jussisaurio Thank you for your comment, I think it is very valuable.I made the following changes based on your comment - When index cover is satisfied, just open the index...

optimizer: use covering indexes

I am very interested in this issue and I would like to share my thoughts The current data reading process is to iterate the data in `Program::step` and obtain the...

optimizer: use covering indexes

Thanks, I want to try to implement it

chore: add logging to query queue test

please update the code synchronization https://github.com/databendlabs/databend/pull/18709 This PR solves the CI test_private_tasks error

[Optimizer] Add a new rule to prune no-used columns to speed up query performance for aggregate-union-aggregate pattern

```sql create table t1 (c1 int, c2 int, c3 int); insert into t1 values(0, 0, 0); explain logical select c1, sum(c3) from ( select c1, c2, sum(c3) as c3 from...

Optimize count() with time range

I want to discuss the implementation of this, I think we may need to refer to `ScanHintRule` and re-implement it as `PhysicalOptimizerRule`, because we need to get statistical information about...

fix: where comparing old and new bitmap versions occurred when directly comparing bytes in join and group by operations.

@codex review