[
https://issues.apache.org/jira/browse/PHOENIX-5290?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16883242#comment-16883242
]
Lars Hofhansl commented on PHOENIX-5290:
----------------------------------------
#868
{code:java}
rs = conn.createStatement().executeQuery("SELECT OBJ.ACCOUNT_ID,
OBJ.BUCKET_ID, OBJ.OBJECT_ID, OBJ.OBJECT_VERSION, OBJ.LOC "
+ "FROM ( SELECT ACCOUNT_ID, BUCKET_ID, OBJECT_ID,
MAX(OBJECT_VERSION) AS MAXVER"
+ " FROM test2961 GROUP BY ACCOUNT_ID, BUCKET_ID,
OBJECT_ID) AS X "
+ " INNER JOIN test2961 AS OBJ ON X.ACCOUNT_ID =
OBJ.ACCOUNT_ID AND X.BUCKET_ID = OBJ.BUCKET_ID AND X.OBJECT_ID = OBJ.OBJECT_ID
AND X.MAXVER = OBJ.OBJECT_VERSION");
{code}
#898
{code:java}
String q = "SELECT OBJ.ACCOUNT_ID, OBJ.BUCKET_ID, OBJ.OBJECT_ID,
OBJ.OBJECT_VERSION, OBJ.LOC "
+ "FROM ( SELECT ACCOUNT_ID, BUCKET_ID, OBJECT_ID,
MAX(OBJECT_VERSION) AS MAXVER "
+ " FROM test2961 GROUP BY ACCOUNT_ID, BUCKET_ID,
OBJECT_ID) AS X "
+ " INNER JOIN test2961 AS OBJ ON X.ACCOUNT_ID =
OBJ.ACCOUNT_ID AND X.BUCKET_ID = OBJ.BUCKET_ID AND X.OBJECT_ID = OBJ.OBJECT_ID
AND X.MAXVER = OBJ.OBJECT_VERSION";
rs = conn.createStatement().executeQuery("explain " + q);
{code}
#903 (same <q> as above)
{code:java}
rs = conn.createStatement().executeQuery(q);
{code}
> HashJoinMoreIT is flapping
> --------------------------
>
> Key: PHOENIX-5290
> URL: https://issues.apache.org/jira/browse/PHOENIX-5290
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.15.0, 4.14.1, 5.1.0
> Reporter: Lars Hofhansl
> Priority: Major
>
> {code}
> [INFO] Running org.apache.phoenix.end2end.join.HashJoinMoreIT
> [ERROR] Tests run: 8, Failures: 0, Errors: 1, Skipped: 0, Time elapsed:
> 91.509 s <<< FAILURE! - in org.apache.phoenix.end2end.join.HashJoinMoreIT
> [ERROR] testBug2961(org.apache.phoenix.end2end.join.HashJoinMoreIT) Time
> elapsed: 2.42 s <<< ERROR!
> java.lang.IllegalArgumentException: 6 > 5
> at
> org.apache.phoenix.end2end.join.HashJoinMoreIT.testBug2961(HashJoinMoreIT.java:898)
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
