[
https://issues.apache.org/jira/browse/PHOENIX-1298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14150431#comment-14150431
]
James Taylor commented on PHOENIX-1298:
---------------------------------------
The tests passed locally for me, but seem to be flapping now. Any ideas,
[~samarthjain]?
Here's an exception I've seen (strange too that the same exception is reported
so many times - maybe for each parameterized run?):
< FAILURE! - in org.apache.phoenix.end2end.QueryIT
testFullyQualifiedRVCInList[CREATE INDEX ATABLE_IDX ON aTable (a_integer DESC)
INCLUDE ( A_STRING, B_STRING,
A_DATE)](org.apache.phoenix.end2end.QueryIT) Time elapsed: 0.14 sec <<<
FAILURE!
java.lang.AssertionError: expected:<0> but was:<2>
at org.junit.Assert.fail(Assert.java:88)
at org.junit.Assert.failNotEquals(Assert.java:743)
at org.junit.Assert.assertEquals(Assert.java:118)
at org.junit.Assert.assertEquals(Assert.java:555)
at org.junit.Assert.assertEquals(Assert.java:542)
at
org.apache.phoenix.query.BaseTest.assertValuesEqualsResultSet(BaseTest.java:1328)
at
org.apache.phoenix.end2end.BaseQueryIT.assertValueEqualsResultSet(BaseQueryIT.java:126)
at
org.apache.phoenix.end2end.QueryIT.testFullyQualifiedRVCInList(QueryIT.java:492)
testFullyQualifiedRVCInList[CREATE INDEX ATABLE_IDX ON aTable (a_integer,
a_string) INCLUDE ( B_STRING,
A_DATE)](org.apache.phoenix.end2end.QueryIT) Time elapsed: 0.144 sec <<<
FAILURE!
java.lang.AssertionError: expected:<0> but was:<2>
at org.junit.Assert.fail(Assert.java:88)
at org.junit.Assert.failNotEquals(Assert.java:743)
at org.junit.Assert.assertEquals(Assert.java:118)
at org.junit.Assert.assertEquals(Assert.java:555)
at org.junit.Assert.assertEquals(Assert.java:542)
at
org.apache.phoenix.query.BaseTest.assertValuesEqualsResultSet(BaseTest.java:1328)
at
org.apache.phoenix.end2end.BaseQueryIT.assertValueEqualsResultSet(BaseQueryIT.java:126)
at
org.apache.phoenix.end2end.QueryIT.testFullyQualifiedRVCInList(QueryIT.java:492)
testFullyQualifiedRVCInList[CREATE INDEX ATABLE_IDX ON aTable (a_integer)
INCLUDE ( A_STRING, B_STRING,
A_DATE)](org.apache.phoenix.end2end.QueryIT) Time elapsed: 0.24 sec <<<
FAILURE!
java.lang.AssertionError: expected:<0> but was:<2>
at org.junit.Assert.fail(Assert.java:88)
at org.junit.Assert.failNotEquals(Assert.java:743)
at org.junit.Assert.assertEquals(Assert.java:118)
at org.junit.Assert.assertEquals(Assert.java:555)
at org.junit.Assert.assertEquals(Assert.java:542)
at
org.apache.phoenix.query.BaseTest.assertValuesEqualsResultSet(BaseTest.java:1328)
at
org.apache.phoenix.end2end.BaseQueryIT.assertValueEqualsResultSet(BaseQueryIT.java:126)
at
org.apache.phoenix.end2end.QueryIT.testFullyQualifiedRVCInList(QueryIT.java:492)
testFullyQualifiedRVCInList[CREATE LOCAL INDEX ATABLE_IDX ON aTable (a_integer
DESC) INCLUDE ( A_STRING, B_STRING,
A_DATE)](org.apache.phoenix.end2end.QueryIT) Time elapsed: 0.203 sec <<<
FAILURE!
java.lang.AssertionError: expected:<0> but was:<2>
at org.junit.Assert.fail(Assert.java:88)
at org.junit.Assert.failNotEquals(Assert.java:743)
at org.junit.Assert.assertEquals(Assert.java:118)
at org.junit.Assert.assertEquals(Assert.java:555)
at org.junit.Assert.assertEquals(Assert.java:542)
at
org.apache.phoenix.query.BaseTest.assertValuesEqualsResultSet(BaseTest.java:1328)
at
org.apache.phoenix.end2end.BaseQueryIT.assertValueEqualsResultSet(BaseQueryIT.java:126)
at
org.apache.phoenix.end2end.QueryIT.testFullyQualifiedRVCInList(QueryIT.java:492)
testFullyQualifiedRVCInList[CREATE LOCAL INDEX ATABLE_IDX ON aTable (a_integer,
a_string) INCLUDE ( B_STRING,
A_DATE)](org.apache.phoenix.end2end.QueryIT) Time elapsed: 0.199 sec <<<
FAILURE!
java.lang.AssertionError: expected:<0> but was:<2>
at org.junit.Assert.fail(Assert.java:88)
at org.junit.Assert.failNotEquals(Assert.java:743)
at org.junit.Assert.assertEquals(Assert.java:118)
at org.junit.Assert.assertEquals(Assert.java:555)
at org.junit.Assert.assertEquals(Assert.java:542)
at
org.apache.phoenix.query.BaseTest.assertValuesEqualsResultSet(BaseTest.java:1328)
at
org.apache.phoenix.end2end.BaseQueryIT.assertValueEqualsResultSet(BaseQueryIT.java:126)
at
org.apache.phoenix.end2end.QueryIT.testFullyQualifiedRVCInList(QueryIT.java:492)
testFullyQualifiedRVCInList[CREATE LOCAL INDEX ATABLE_IDX ON aTable (a_integer)
INCLUDE ( A_STRING, B_STRING,
A_DATE)](org.apache.phoenix.end2end.QueryIT) Time elapsed: 0.205 sec <<<
FAILURE!
java.lang.AssertionError: expected:<0> but was:<2>
at org.junit.Assert.fail(Assert.java:88)
at org.junit.Assert.failNotEquals(Assert.java:743)
at org.junit.Assert.assertEquals(Assert.java:118)
at org.junit.Assert.assertEquals(Assert.java:555)
at org.junit.Assert.assertEquals(Assert.java:542)
at
org.apache.phoenix.query.BaseTest.assertValuesEqualsResultSet(BaseTest.java:1328)
at
org.apache.phoenix.end2end.BaseQueryIT.assertValueEqualsResultSet(BaseQueryIT.java:126)
at
org.apache.phoenix.end2end.QueryIT.testFullyQualifiedRVCInList(QueryIT.java:492)
testFullyQualifiedRVCInList[](org.apache.phoenix.end2end.QueryIT) Time
elapsed: 0.163 sec <<< FAILURE!
java.lang.AssertionError: expected:<0> but was:<2>
at org.junit.Assert.fail(Assert.java:88)
at org.junit.Assert.failNotEquals(Assert.java:743)
at org.junit.Assert.assertEquals(Assert.java:118)
at org.junit.Assert.assertEquals(Assert.java:555)
at org.junit.Assert.assertEquals(Assert.java:542)
at
org.apache.phoenix.query.BaseTest.assertValuesEqualsResultSet(BaseTest.java:1328)
at
org.apache.phoenix.end2end.BaseQueryIT.assertValueEqualsResultSet(BaseQueryIT.java:126)
at
org.apache.phoenix.end2end.QueryIT.testFullyQualifiedRVCInList(QueryIT.java:492)
> Queries on fixed width type columns that have an index declared on them don't
> use that index
> --------------------------------------------------------------------------------------------
>
> Key: PHOENIX-1298
> URL: https://issues.apache.org/jira/browse/PHOENIX-1298
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 5.0.0, 4.2, 3.2
> Reporter: Samarth Jain
> Assignee: Samarth Jain
> Fix For: 5.0.0, 4.2, 3.2
>
> Attachments: PHOENIX-1298.patch
>
>
> Happens when the index is on a column whose data type is fixed width. If V1
> is made of type VARCHAR, then the test passes.
> {code}
> @Test
> public void testRVCUsingPkColsReturnedByPlanShouldUseIndex() throws
> Exception {
> Connection conn = DriverManager.getConnection(getUrl());
> conn.createStatement().execute("CREATE TABLE T (k VARCHAR NOT NULL
> PRIMARY KEY, v1 CHAR(15), v2 VARCHAR)");
> conn.createStatement().execute("CREATE INDEX IDX ON T(v1)");
> PhoenixStatement stmt =
> conn.createStatement().unwrap(PhoenixStatement.class);
> String query = "select * from t where v1 = '1'";
> QueryPlan plan = stmt.optimizeQuery(query);
> assertEquals("IDX",
> plan.getTableRef().getTable().getTableName().getString());
> }
>
> {code}
> Instead of going through the index table, the query ends up using the data
> table.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
