[
https://issues.apache.org/jira/browse/PHOENIX-172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16650758#comment-16650758
]
Thomas D'Silva commented on PHOENIX-172:
----------------------------------------
The sql standard for RVC does involve comparing each column:
{code}
Let Rx and Ry be the two <row value constructor>s of the <com-
parison predicate> and let RXi and RYi be the i-th <row value
constructor element>s of Rx and Ry, respectively. "Rx <comp op>
Ry" is true, false, or unknown as follows:
a) "x = Ry" is true if and only if RXi = RYi for all i.
b) "x <> Ry" is true if and only if RXi <> RYi for some i.
c) "x < Ry" is true if and only if RXi = RYi for all i < n and
RXn < RYn for some n.
d) "x > Ry" is true if and only if RXi = RYi for all i < n and
RXn > RYn for some n.
{code}
After PHOENIX-3383 the sort order of RVCs don't depend on the PK's natural
order. If RVCs depend on the natural sort order of the PK columns, then you
would get different results if you queried a data table vs a index for the same
query (if the sort order of the pks are different, right?)
> Support the ability for a client to do query more
> -------------------------------------------------
>
> Key: PHOENIX-172
> URL: https://issues.apache.org/jira/browse/PHOENIX-172
> Project: Phoenix
> Issue Type: Task
> Affects Versions: 2.1.0
> Reporter: James Taylor
> Assignee: Samarth Jain
> Labels: enhancement
>
> Clients often need the ability to "page" through query results that have more
> row results than are displayable on a single screen. SQL provides LIMIT and
> OFFSET which is often used for this purpose, however supporting OFFSET in a
> performant manner is not possible with HBase. Instead, an alternate way of
> supporting query-more functionality (suggested by @larsh) is through [row
> values
> constructors](http://publib.boulder.ibm.com/infocenter/soliddb/v6r3/index.jsp?topic=/com.ibm.swg.im.soliddb.sql.doc/doc/row.value.constructors.html)
> which has been in the SQL spec since SQL-92. It has PostGres support as
> well with the benefits explained well
> [here](https://wiki.postgresql.org/images/3/35/Pagination_Done_the_PostgreSQL_Way.pdf)
> .
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
