PARTITION 功能缺失

[rocascent]

缺少FIRST_VALUE LAG等函数以及ROWS BETWEEN语法

[xuejmnet]

partation函数有的first_value和lag也有的

 List<Part1<DocBlog, Long>> list = easyEntityQuery.queryable(DocBlog.class)
                        .where(d -> {
                            d.publishTime().gt(LocalDateTime.of(2024, 1, 1, 0, 0));
                        }).select(d -> Select.PART.of(
                                d,
                                d.expression().rowNumberOver().partitionBy(d.topic()).orderByDescending(d.score())
                        )).toList();

偏移量函数也有

easyEntityQuery.queryable(SysBankCard.class)
                .select(bank_card -> Select.DRAFT.of(
                        bank_card.type(),
                        bank_card.type().offset(o -> {
                            o.orderBy(bank_card.type()).orderByDescending(bank_card.code());
                        }).prev(1),
                        bank_card.openTime().offset(o -> {
                            o.orderBy(bank_card.type()).orderByDescending(bank_card.code());
                        }).firstValue(),
                        bank_card.openTime().offset(o -> {
                            o.partitionBy(bank_card.bankId());
                            o.orderBy(bank_card.type()).orderByDescending(bank_card.code());
                        }).lastValue(),
                        bank_card.openTime().offset(o -> {
                            o.partitionBy(bank_card.bankId());
                            o.orderBy(bank_card.type()).orderByDescending(bank_card.code());
                        }).nthValue(2)
                )).toList();

ROWS BETWEEN后续我关注一下

[rocascent]

哦我以为都叫xxxOver😁

[rocascent]

还有range between

[xuejmnet]

还有range between

ok👌