calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas D'Silva" <tdsi...@twilio.com.INVALID>
Subject row value constructors for pagination
Date Thu, 29 Aug 2019 01:13:04 GMT
I am looking into the possibility of using row value constructors for
paging through data. The query would be of the form

SELECT * FROM t WHERE (pk1, pk2) > (2,'bar');

which should logically be equivalent to

SELECT * FROM t WHERE pk1 > 2 OR (pk1=2 AND pk2>'bar')

I found a previous thread where this was discussed [1]. Does anyone know
the scope of work it would take to support this feature in Calcite?

[1]
https://lists.apache.org/thread.html/8d3154f6a636972777493d176b9bbaa69ab957145470135a0a13a1b3@1419906719@%3Cdev.calcite.apache.org%3E

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message