You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@phoenix.apache.org by "Hadoop QA (Jira)" <ji...@apache.org> on 2021/01/06 09:14:00 UTC
[jira] [Commented] (PHOENIX-3633) null pointer exception when
subsquery for not exists returns empty result set
[ https://issues.apache.org/jira/browse/PHOENIX-3633?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17259524#comment-17259524 ]
Hadoop QA commented on PHOENIX-3633:
------------------------------------
| (x) *{color:red}-1 overall{color}* |
\\
\\
|| Vote || Subsystem || Runtime || Comment ||
| {color:blue}0{color} | {color:blue} reexec {color} | {color:blue} 2m 11s{color} | {color:blue} Docker mode activated. {color} |
|| || || || {color:brown} Prechecks {color} ||
| {color:green}+1{color} | {color:green} dupname {color} | {color:green} 0m 0s{color} | {color:green} No case conflicting files found. {color} |
| {color:green}+1{color} | {color:green} hbaseanti {color} | {color:green} 0m 0s{color} | {color:green} Patch does not have any anti-patterns. {color} |
| {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} |
| {color:red}-1{color} | {color:red} test4tests {color} | {color:red} 0m 0s{color} | {color:red} The patch doesn't appear to include any new or modified tests. Please justify why no new tests are needed for this patch. Also please list what manual steps were performed to verify this patch. {color} |
|| || || || {color:brown} master Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 20m 15s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 29s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 56s{color} | {color:green} master passed {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 59s{color} | {color:green} master passed {color} |
| {color:blue}0{color} | {color:blue} spotbugs {color} | {color:blue} 3m 31s{color} | {color:blue} phoenix-core in master has 973 extant spotbugs warnings. {color} |
|| || || || {color:brown} Patch Compile Tests {color} ||
| {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 9m 22s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} compile {color} | {color:green} 0m 56s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} javac {color} | {color:green} 0m 56s{color} | {color:green} the patch passed {color} |
| {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 36s{color} | {color:red} phoenix-core: The patch generated 3 new + 526 unchanged - 1 fixed = 529 total (was 527) {color} |
| {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} |
| {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 0m 46s{color} | {color:green} the patch passed {color} |
| {color:green}+1{color} | {color:green} spotbugs {color} | {color:green} 3m 52s{color} | {color:green} the patch passed {color} |
|| || || || {color:brown} Other Tests {color} ||
| {color:red}-1{color} | {color:red} unit {color} | {color:red} 1m 59s{color} | {color:red} phoenix-core in the patch failed. {color} |
| {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 9s{color} | {color:green} The patch does not generate ASF License warnings. {color} |
| {color:black}{color} | {color:black} {color} | {color:black} 47m 49s{color} | {color:black} {color} |
\\
\\
|| Reason || Tests ||
| Failed junit tests | phoenix.query.PhoenixStatsCacheLoaderTest |
\\
\\
|| Subsystem || Report/Notes ||
| Docker | ClientAPI=1.41 ServerAPI=1.41 base: https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/346/artifact/patchprocess/Dockerfile |
| JIRA Issue | PHOENIX-3633 |
| JIRA Patch URL | https://issues.apache.org/jira/secure/attachment/12862599/PHOENIX-3633.patch |
| Optional Tests | dupname asflicense javac javadoc unit spotbugs hbaseanti checkstyle compile |
| uname | Linux f28637160025 4.15.0-126-generic #129-Ubuntu SMP Mon Nov 23 18:53:38 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux |
| Build tool | maven |
| Personality | dev/phoenix-personality.sh |
| git revision | master / 8333ae5 |
| Default Java | Private Build-1.8.0_242-8u242-b08-0ubuntu3~16.04-b08 |
| checkstyle | https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/346/artifact/patchprocess/diff-checkstyle-phoenix-core.txt |
| unit | https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/346/artifact/patchprocess/patch-unit-phoenix-core.txt |
| Test Results | https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/346/testReport/ |
| Max. process+thread count | 481 (vs. ulimit of 30000) |
| modules | C: phoenix-core U: phoenix-core |
| Console output | https://ci-hadoop.apache.org/job/PreCommit-PHOENIX-Build/346/console |
| versions | git=2.7.4 maven=3.3.9 spotbugs=4.1.3 |
| Powered by | Apache Yetus 0.12.0 https://yetus.apache.org |
This message was automatically generated.
> null pointer exception when subsquery for not exists returns empty result set
> -----------------------------------------------------------------------------
>
> Key: PHOENIX-3633
> URL: https://issues.apache.org/jira/browse/PHOENIX-3633
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.7.0, 5.1.0
> Reporter: N Campbell
> Assignee: Istvan Toth
> Priority: Major
> Attachments: PHOENIX-3633.patch
>
>
> phoenix-4.7.0.2.5.3.0-37-client
> select RNUM, C1, C2 from TJOIN2 where not exists ( select C1 from TJOIN1 where C2=500)
> Error while executing SQL "select RNUM, C1, C2 from TJOIN2 where not exists ( select C1 from TJOIN1 where C2=500)": Remote driver error: NullPointerException: (null exception message)
> create table if not exists TJOIN1 (RNUM integer not null primary key , C1 integer, C2 integer);
> upsert into TJOIN1 (RNUM, C1, C2) values ( 0, 10, 15);
> upsert into TJOIN1 (RNUM, C1, C2) values ( 1, 20, 25);
> upsert into TJOIN1 (RNUM, C1, C2) values ( 2, NULL, 50);
> create table if not exists TJOIN2 (RNUM integer not null primary key , C1 integer, C2 char(2));
> upsert into TJOIN2 (RNUM, C1, C2) values ( 0, 10, 'BB');
> upsert into TJOIN2 (RNUM, C1, C2) values ( 1, 15, 'DD');
> upsert into TJOIN2 (RNUM, C1, C2) values ( 2, NULL, 'EE');
> upsert into TJOIN2 (RNUM, C1, C2) values ( 3, 10, 'FF');
--
This message was sent by Atlassian Jira
(v8.3.4#803005)