apache / apache/cloudberry

Support SELECT FETCH WITH TIES in ORCA

Open
#127 0 comments 0 reactions 1 assignee Claimed by @wfnuser View on GitHub
Dominant language
C
Stars
1.4k
Forks
247
Avg merge
4d 3h
Merged PRs (30d)
39

Description

```
create table t11(a int, b int);
insert into t11 select i%3, i from generate_series(1,15)i;

gpadmin=# set optimizer=off;
SET
gpadmin=# select * from t11 order by a fetch first 2 rows with ties;
a | b
---+----
0 | 15
0 | 3
0 | 6
0 | 9
0 | 12
(5 rows)

gpadmin=# set optimizer=on;
SET
gpadmin=# select * from t11 order by a fetch first 2 rows with ties;
a | b
---+----
0 | 15
0 | 3
(2 rows)
```

https://www.jooq.org/doc/latest/manual/sql-building/sql-statements/select-statement/with-ties-clause/

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.