Jk Xu

**Summary** SQL: ```sql drop table if exists t; drop table if exists t1; create table t(a int); create table t1(a int); insert into t values(1),(2),(3); insert into t1 values(1),(2),(3); select...

**Summary** Refactor window to improve performance, reduce memory usage and support spill for window. - [x] #16448 - [x] #16441 - [x] Optimising block serialisation memory usage #16580 - [...

**Summary** Unify execution of DML statements: `INSERT`, `UPDATE`, `DELETE`, `MERGE INTO`.

**Summary** For the following case: ```sql CREATE TABLE date_sub_query_test ( ID BIGINT NULL, test_time timestamp NULL ) explain select * from date_sub_query_test where test_time >= (select now()); ``` We can...

refactor(query): refactor hash join spill

2

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/ ## Summary ### Code readability and maintainability 1. New step transition mechanism: this PR divides hash join probe/build...

bug: copy into table cannot work

4

**Summary** Reproduce: ```sql drop table t; create table t(a int, b int); COPY INTO t FROM 'fs:////Users/xujinkai/Desktop/UNdata/' PATTERN = 'table_0_01.csv' FILE_FORMAT =(type = 'CSV' field_delimiter = ',' record_delimiter = '\n'...

I hereby agree to the terms of the CLA available at: https://docs.databend.com/dev/policies/cla/ ## Summary ## Tests - [ ] Unit Test - [x] Logic Test - [ ] Benchmark Test...

**Summary** ## How to reproduce ```sql set join_spilling_memory_ratio = 1; set join_spilling_bytes_threshold_per_proc = 1; set join_spilling_buffer_threshold_per_proc_mb = 1; set sort_spilling_memory_ratio = 1; set sort_spilling_bytes_threshold_per_proc = 1; set aggregate_spilling_memory_ratio = 1;...

Bug: the experience of drag-and-select is not good

1

### What happened? https://github.com/user-attachments/assets/ffec1830-6f75-49d7-baf1-ea69213c03e4 ### Distribution version macOS ARM 64 (Apple Silicon) ### What browsers are you seeing the problem on if you're using web version? _No response_ ### Are...

**Summary** Please contact me to get the data to reproduce the bug.