Andrew Khor created PHOENIX-4982:
------------------------------------
Summary: Query Fails For Join with Order By that is fully qualified
Key: PHOENIX-4982
URL: https://issues.apache.org/jira/browse/PHOENIX-4982
Project: Phoenix
Issue Type: Bug
Reporter: Andrew Khor
{code:java}
@Test
public void testJoinWithOrderBy() throws Exception {
String tableA = "A";
String tableB = "B";
String createA = "CREATE TABLE \"" + tableA + "\" (\n" +
" \"a1\" VARCHAR PRIMARY KEY ,\n" +
" \"a2\" VARCHAR \n" +
")";
String createB = "CREATE TABLE \"" + tableB + "\" (\n" +
" \"b1\" VARCHAR PRIMARY KEY ,\n" +
" \"b2\" VARCHAR \n" +
")\n";
try (Connection conn = DriverManager.getConnection(CONN_STRING);
Statement stmt = conn.createStatement()) {
conn.setAutoCommit(false);
assertFalse(stmt.execute("DROP TABLE IF EXISTS " + tableA));
assertFalse(stmt.execute("DROP TABLE IF EXISTS " + tableB));
assertFalse(stmt.execute(createA));
assertFalse(stmt.execute(createB));
Statement statement = null;
ResultSet rs = null;
PreparedStatement ps = null;
String sql = "SELECT \"" + tableA + "\".\"a2\" " +
"FROM \"" + tableA + "\" JOIN \"" + tableB + "\" ON (\"" +
tableA + "\".\"a1\" = \"" + tableB + "\".\"b1\") " +
"WHERE (\"" + tableB + "\".\"b2\" = ?) " +
"ORDER BY \""+ tableA + "\".\"a2\" ASC";
ps = conn.prepareStatement(sql);
rs = ps.executeQuery();
assertFalse(rs.next());
}
}
{code}
See above for a test case.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
