[
https://issues.apache.org/jira/browse/PHOENIX-6243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17251396#comment-17251396
]
ASF GitHub Bot commented on PHOENIX-6243:
-----------------------------------------
gjacoby126 commented on pull request #1020:
URL: https://github.com/apache/phoenix/pull/1020#issuecomment-747771621
@fengchen8086 - lots of the test failures look to be timeouts, but could you
please look at the HashJoinGlobalIndexIT failures that look to be changing
query plans to see if it's related to your change?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> ValueBitSet can be "true" for incorrect columns
> -----------------------------------------------
>
> Key: PHOENIX-6243
> URL: https://issues.apache.org/jira/browse/PHOENIX-6243
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.15.0
> Reporter: Chen Feng
> Assignee: Chen Feng
> Priority: Major
> Attachments: PHOENIX-6243-4.15-HBase-1.5-v1.patch
>
>
> ValueBitSet can be "true" for incorrect columns. Execute the following sqls
> CREATE TABLE A(ID UNSIGNED_LONG NOT NULL PRIMARY KEY, COL_0 UNSIGNED_LONG,
> COL_1 UNSIGNED_LONG, COL_2 UNSIGNED_LONG, COL_3 UNSIGNED_LONG, COL_4
> UNSIGNED_LONG, COL_5 UNSIGNED_LONG, COL_6 UNSIGNED_LONG, COL_7 UNSIGNED_LONG,
> COL_8 UNSIGNED_LONG, COL_9 UNSIGNED_LONG, COL_10 UNSIGNED_LONG, COL_11
> UNSIGNED_LONG, COL_12 UNSIGNED_LONG, COL_13 UNSIGNED_LONG, COL_14
> UNSIGNED_LONG)
> CREATE TABLE B(ID UNSIGNED_LONG NOT NULL PRIMARY KEY, S_ VARCHAR, UL_
> UNSIGNED_LONG)
> UPSERT INTO A VALUES(1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1)
> UPSERT INTO B(ID, UL_) VALUES(1, 1)
> SELECT /*+ USE_SORT_MERGE_JOIN */ J_A.ID, J_A.COL_0, J_A.COL_1, J_A.COL_2,
> J_A.COL_3, J_A.COL_4, J_A.COL_5, J_A.COL_6, J_A.COL_7, J_A.COL_8, J_A.COL_9,
> J_A.COL_10, J_A.COL_11, J_A.COL_12, J_A.COL_13, J_A.COL_14, J_B.S_, J_B.UL_
> FROM ( SELECT ID, COL_0, COL_1, COL_2, COL_3, COL_4, COL_5, COL_6, COL_7,
> COL_8, COL_9, COL_10, COL_11, COL_12, COL_13, COL_14 FROM A) J_A JOIN (
> SELECT ID, S_, UL_ FROM B) J_B ON J_A.ID = J_B.ID
>
> will trigger exception as follows
> Error: ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes,
> but had 7 (state=22000,code=201)
> java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at
> least 8 bytes, but had 7
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
