[
https://issues.apache.org/jira/browse/PHOENIX-6583?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17440643#comment-17440643
]
ASF GitHub Bot commented on PHOENIX-6583:
-----------------------------------------
alejandro-anadon removed a comment on pull request #1342:
URL: https://github.com/apache/phoenix/pull/1342#issuecomment-963418459
Hi,
I do not understand the error that Yetus(jenkins) is reporting because the
file phoenix-core/src/it/java/org/apache/phoenix/end2end/BinaryTypeIT.java was
deleted from the branck and it does not exists. You can check it in the
PHOENIX-6583 branch on alejandro-anadon/phoenix.
Here is when I deletted it:
https://github.com/apache/phoenix/pull/1342/commits/eae4b115e18f932debb6aca9ce1b6d8a7ff5c2df
Just as you suggested, that test was moved to
phoenix-core/src/it/java/org/apache/phoenix/end2end/NullIT.java.
In my enviroment, the only failed test is
PhoenixMetricsIT.testGlobalPhoenixMetricsForQueries; but I passed also all the
test before my changes, and I have the same failed test; so I guess it has
nothing to do with my changes that I have made.
I am going to post ascreen log file in case it may help. It is absolutly
from begining. I mean, from firt 'git clone' of my repositorie.
(I also have an error after all the test has been done. It is another error
when it is supoused to begin to generate the report when it try to execute'
org.jacoco:jacoco-maven-plugin:0.8.7:report' and I do not know why. But It has
nothing of relation with , and I do not care too much because if I try to build
the binaries without test, it works until the end.
(I am trying to build with hbase profile 2.1.9 and using
-Dmaven.compiler.executable=/usr/lib/jvm/jdk1.8.0_202/bin/javac because I have
by default an openjdk version "11.0.12" 2021-07-20).
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
> Inserting explicit Null into a (fixed length) binary field is stored as an
> array of zeroes
> ------------------------------------------------------------------------------------------
>
> Key: PHOENIX-6583
> URL: https://issues.apache.org/jira/browse/PHOENIX-6583
> Project: Phoenix
> Issue Type: Bug
> Components: core
> Affects Versions: 5.1.2
> Reporter: Alejandro Anadon
> Priority: Major
>
> In binary fields, if I use upsert with null value, it "insert" the field with
> 0x00 0x00 bytes vaules.
> Example:
> create table DUMMYTABLE (id integer not null, text varchar(255), testbin
> binary(16), CONSTRAINT pk primary key (id));
> 1)
> upsert into DUMMYTABLE (id,text) values (1,'null in testBinary');
> select id,text,LENGTH(TEXT),TESTBIN,OCTET_LENGTH(TESTBIN) from DUMMYTABLE;
> result--> TESTBIN => null, OCTET_LENGTH(TESTBIN) => null . that's ok.
> 2)
> upsert into DUMMYTABLE (id,text,testbin) values (2,'IT DO NOT null in
> testBinary',null);
> select id,text,LENGTH(TEXT),TESTBIN,OCTET_LENGTH(TESTBIN) from DUMMYTABLE;
> result in seconf row-> TESTBIN => NOT NULL, OCTET_LENGTH(TESTBIN) => 16 .
> that's an error.
>
> I verified it in hbase and actually reserves empty data (it should not):
> hbase(main):001:0> scan 'DUMMYTABLE'
> ROW COLUMN+CELL
> \x80\x00\x00\x01 column=0:\x00\x00\x00\x00, timestamp=1635365632081, value=x
> \x80\x00\x00\x01 column=0:\x80\x0B, timestamp=1635365632081, value=null in
> testBinary
> \x80\x00\x00\x02 column=0:\x00\x00\x00\x00, timestamp=1635365696139, value=x
> \x80\x00\x00\x02 column=0:\x80\x0B, timestamp=1635365696139, value=IT DO NOT
> null in testBinary
> \x80\x00\x00\x02 column=0:\x80\x0C, timestamp=1635365696139,
> value=\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00
> 2 row(s)
> Took 0.5030 seconds
>
> And now, it is imposible to delete that files:
> upsert into DUMMYTABLE (id,testbin) values (2,null);
> it does not removes the data.
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
