futurewei-cloud / chogori-opengauss

Other
2 stars 7 forks source link

index_only_scan and support for more pggate select constraint types #62

Closed jfunston closed 2 years ago

jfunston commented 2 years ago

index_only_scan is implemented simply as a normal query over the secondary index/schema. That is the constraints and targets are interpreted as applying directly to the secondary index. This seems to match the way chogori-sql implemented it.

Added LT, LTE, GT, GTE, IN, and BETWEEN support to pggate select. IN is implemented as a set of OR'ed EQ clauses. BETWEEN is expanded as LTE and GTE pair. Everything is has a direct mapping to SKV expression.