[
https://issues.apache.org/jira/browse/PHOENIX-6243?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17250120#comment-17250120
]
ASF GitHub Bot commented on PHOENIX-6243:
-----------------------------------------
fengchen8086 commented on pull request #1019:
URL: https://github.com/apache/phoenix/pull/1019#issuecomment-745788795
@yanxinyi sure.
#1020 is already raised.
I'll close this PR.
----------------------------------------------------------------
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)
