[
https://issues.apache.org/jira/browse/PHOENIX-1753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14370644#comment-14370644
]
Samarth Jain commented on PHOENIX-1753:
---------------------------------------
+1. Looks good [~jamestaylor]
> Query with RVC that doesn't lead with the row key can return incorrect results
> ------------------------------------------------------------------------------
>
> Key: PHOENIX-1753
> URL: https://issues.apache.org/jira/browse/PHOENIX-1753
> Project: Phoenix
> Issue Type: Bug
> Reporter: Samarth Jain
> Assignee: James Taylor
> Attachments: PHOENIX-1753.patch
>
>
> Test case to reproduce the bug:
> {code}
> @Test
> public void testRVCWithRowKeyNotLeading() throws Exception {
> String ddl = "CREATE TABLE sorttest4 (rownum BIGINT primary key, name
> varchar(16), age integer)";
> Connection conn = nextConnection(getUrl());
> conn.createStatement().execute(ddl);
> conn.close();
> conn = nextConnection(getUrl());
> String dml = "UPSERT INTO sorttest4 (rownum, name, age) values (?, ?,
> ?)";
> PreparedStatement stmt = conn.prepareStatement(dml);
> stmt.setInt(1, 1);
> stmt.setString(2, "A");
> stmt.setInt(3, 1);
> stmt.executeUpdate();
> stmt.setInt(1, 2);
> stmt.setString(2, "B");
> stmt.setInt(3, 2);
> stmt.executeUpdate();
> conn.commit();
> conn.close();
> // the below query should only return one record -> (1, "A", 1)
> String query = "SELECT rownum, name, age FROM sorttest4 where (age,
> rownum) < (2, 2)";
> conn = nextConnection(getUrl());
> ResultSet rs = conn.createStatement().executeQuery(query);
> int numRecords = 0;
> while (rs.next()) {
> assertEquals(1, rs.getInt(1));
> assertEquals("A", rs.getString(2));
> assertEquals(1, rs.getInt(3));
> numRecords++;
> }
> assertEquals(1, numRecords);
> }
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
