[ https://issues.apache.org/jira/browse/OOZIE-3310?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16563463#comment-16563463 ]
Hadoop QA commented on OOZIE-3310: ---------------------------------- Testing JIRA OOZIE-3310 Cleaning local git workspace ---------------------------- {color:green}+1 PATCH_APPLIES{color} {color:green}+1 CLEAN{color} {color:green}+1 RAW_PATCH_ANALYSIS{color} . {color:green}+1{color} the patch does not introduce any @author tags . {color:green}+1{color} the patch does not introduce any tabs . {color:green}+1{color} the patch does not introduce any trailing spaces . {color:green}+1{color} the patch does not introduce any line longer than 132 . {color:green}+1{color} the patch adds/modifies 1 testcase(s) {color:green}+1 RAT{color} . {color:green}+1{color} the patch does not seem to introduce new RAT warnings {color:green}+1 JAVADOC{color} {color:green}+1 JAVADOC{color} . {color:green}+1{color} the patch does not seem to introduce new Javadoc warning(s) . {color:red}WARNING{color}: the current HEAD has 100 Javadoc warning(s) . {color:green}+1{color} the patch does not seem to introduce new Javadoc error(s) {color:green}+1 COMPILE{color} . {color:green}+1{color} HEAD compiles . {color:green}+1{color} patch compiles . {color:green}+1{color} the patch does not seem to introduce new javac warnings {color:red}-1{color} There are [1] new bugs found below threshold in total that must be fixed. . {color:green}+1{color} There are no new bugs found in [examples]. . {color:green}+1{color} There are no new bugs found in [webapp]. . {color:red}-1{color} There are [1] new bugs found below threshold in [core] that must be fixed. . You can find the FindBugs diff here (look for the red and orange ones): core/findbugs-new.html . The most important FindBugs errors are: . At SLASummaryGetForFilterJPAExecutor.java:[line 200]: This use of javax/persistence/EntityManager.createQuery(Ljava/lang/String;)Ljavax/persistence/Query; can be vulnerable to SQL/JPQL injection . At SLASummaryGetForFilterJPAExecutor.java:[line 177]: At SLASummaryGetForFilterJPAExecutor.java:[line 167] . At SLASummaryGetForFilterJPAExecutor.java:[line 197]: At SLASummaryGetForFilterJPAExecutor.java:[line 192] . At SLASummaryGetForFilterJPAExecutor.java:[line 200] . {color:green}+1{color} There are no new bugs found in [tools]. . {color:green}+1{color} There are no new bugs found in [fluent-job/fluent-job-api]. . {color:green}+1{color} There are no new bugs found in [server]. . {color:green}+1{color} There are no new bugs found in [docs]. . {color:green}+1{color} There are no new bugs found in [sharelib/hive2]. . {color:green}+1{color} There are no new bugs found in [sharelib/pig]. . {color:green}+1{color} There are no new bugs found in [sharelib/streaming]. . {color:green}+1{color} There are no new bugs found in [sharelib/hive]. . {color:green}+1{color} There are no new bugs found in [sharelib/hcatalog]. . {color:green}+1{color} There are no new bugs found in [sharelib/sqoop]. . {color:green}+1{color} There are no new bugs found in [sharelib/oozie]. . {color:green}+1{color} There are no new bugs found in [sharelib/distcp]. . {color:green}+1{color} There are no new bugs found in [sharelib/spark]. . {color:green}+1{color} There are no new bugs found in [client]. {color:green}+1 BACKWARDS_COMPATIBILITY{color} . {color:green}+1{color} the patch does not change any JPA Entity/Colum/Basic/Lob/Transient annotations . {color:green}+1{color} the patch does not modify JPA files {color:green}+1 TESTS{color} . Tests run: 2911 {color:green}+1 DISTRO{color} . {color:green}+1{color} distro tarball builds with the patch ---------------------------- {color:red}*-1 Overall result, please check the reported -1(s)*{color} {color:red}. There is at least one warning, please check{color} The full output of the test-patch run is available at . https://builds.apache.org/job/PreCommit-OOZIE-Build/705/ > SQL error during /v2/sla filtering > ---------------------------------- > > Key: OOZIE-3310 > URL: https://issues.apache.org/jira/browse/OOZIE-3310 > Project: Oozie > Issue Type: Bug > Components: client > Affects Versions: 5.1.0 > Reporter: Andras Salamon > Assignee: Andras Salamon > Priority: Minor > Attachments: OOZIE-3310-1.patch, OOZIE-3310-2.patch, > OOZIE-3310-3.patch > > > Filtering for both the id and the bundle field using /v2/sla servlet gives an > SQL error: > {noformat} > // 20180726124649 > // > http://localhost:11000/oozie/v2/sla?timezone=GMT&filter=id=0000001-180726123600112-oozie-andr-C;bundle=0000000-180726123600112-oozie-andr-B > { > "errorMessage": "E0603: SQL error in operation, "Encountered > "." at character 63, but expected: ["*", "+", > "-", "/", "GROUP", "HAVING", > "ORDER", <EOF>]." while parsing JPQL "SELECT > OBJECT(s) FROM SLASummaryBean s WHERE s.jobId = :jobIds.parentId in > (:parentId0) ORDER BY s.nominalTimeTS". See nested stack trace for > original parse error.", > "httpStatusCode": 500 > }{noformat} -- This message was sent by Atlassian JIRA (v7.6.3#76005)