jerrypeng closed pull request #2978: reverting jackson version bump for sql
URL: https://github.com/apache/pulsar/pull/2978
This is a PR merged from a forked repository.
As GitHub hides the original diff on merge, it is displayed below for
the sake of provenance:
As this is a foreign pull request (from a fork), the diff is supplied
below (as it won't show otherwise due to GitHub magic):
diff --git a/pulsar-sql/pom.xml b/pulsar-sql/pom.xml
index 6b121183b8..bbb872d0ed 100644
--- a/pulsar-sql/pom.xml
+++ b/pulsar-sql/pom.xml
@@ -32,7 +32,10 @@
<name>Pulsar SQL :: Parent</name>
<properties>
- <jackson.version>2.9.7</jackson.version>
+ <jackson.version>2.8.11</jackson.version>
+ <!--fix Security Vulnerabilities-->
+
<!--https://www.cvedetails.com/vulnerability-list/vendor_id-15866/product_id-42991/Fasterxml-Jackson-databind.html-->
+ <jackson.databind.version>2.8.11.1</jackson.databind.version>
</properties>
<modules>
@@ -58,7 +61,7 @@
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
- <version>${jackson.version}</version>
+ <version>${jackson.databind.version}</version>
</dependency>
<dependency>
diff --git a/pulsar-sql/presto-distribution/LICENSE
b/pulsar-sql/presto-distribution/LICENSE
index 76d2034174..866ba23840 100644
--- a/pulsar-sql/presto-distribution/LICENSE
+++ b/pulsar-sql/presto-distribution/LICENSE
@@ -208,20 +208,19 @@ This projects includes binary packages with the following
licenses:
The Apache Software License, Version 2.0
* Jackson
- - jackson-annotations-2.9.7.jar
- - jackson-databind-2.9.7.jar
- - jackson-dataformat-smile-2.9.7.jar
- - jackson-datatype-guava-2.9.7.jar
- - jackson-datatype-guava-2.9.7.jar
- - jackson-datatype-jdk8-2.9.7.jar
- - jackson-datatype-jdk8-2.9.7.jar
- - jackson-datatype-joda-2.9.7.jar
- - jackson-datatype-jsr310-2.9.7.jar
- - jackson-core-2.9.7.jar
+ - jackson-annotations-2.8.11.jar
+ - jackson-databind-2.8.11.1.jar
+ - jackson-dataformat-smile-2.8.11.jar
+ - jackson-datatype-guava-2.8.11.jar
+ - jackson-datatype-guava-2.8.11.jar
+ - jackson-datatype-jdk8-2.8.11.jar
+ - jackson-datatype-jdk8-2.8.11.jar
+ - jackson-datatype-joda-2.8.11.jar
+ - jackson-datatype-jsr310-2.8.11.jar
+ - jackson-core-2.8.11.jar
- jackson-core-asl-1.9.13.jar
- - jackson-databind-2.9.7.jar
- jackson-mapper-asl-1.9.13.jar
- - jackson-dataformat-yaml-2.9.7.jar
+ - jackson-dataformat-yaml-2.8.11.jar
* Guava
- guava-21.0.jar
- guava-24.1-jre.jar
@@ -372,7 +371,8 @@ The Apache Software License, Version 2.0
* RocksDB JNI
- rocksdbjni-5.13.3.jar
* SnakeYAML
- - snakeyaml-1.23.jar
+ - snakeyaml-1.17.jar
+ - snakeyaml-1.23.jar
* Snappy Java
- snappy-java-1.1.1.3.jar
* Bean Validation API
diff --git a/pulsar-sql/presto-distribution/pom.xml
b/pulsar-sql/presto-distribution/pom.xml
index e05567ad98..e66d87c0ed 100644
--- a/pulsar-sql/presto-distribution/pom.xml
+++ b/pulsar-sql/presto-distribution/pom.xml
@@ -42,7 +42,10 @@
<!-- Launcher properties -->
<main-class>com.facebook.presto.server.PrestoServer</main-class>
<process-name>${project.artifactId}</process-name>
- <jackson.version>2.9.7</jackson.version>
+ <jackson.version>2.8.11</jackson.version>
+ <!--fix Security Vulnerabilities-->
+
<!--https://www.cvedetails.com/vulnerability-list/vendor_id-15866/product_id-42991/Fasterxml-Jackson-databind.html-->
+ <jackson.databind.version>2.8.11.1</jackson.databind.version>
</properties>
<dependencies>
@@ -120,7 +123,7 @@
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
- <version>${jackson.version}</version>
+ <version>${jackson.databind.version}</version>
</dependency>
<dependency>
diff --git
a/tests/integration/src/test/java/org/apache/pulsar/tests/integration/presto/TestBasicPresto.java
b/tests/integration/src/test/java/org/apache/pulsar/tests/integration/presto/TestBasicPresto.java
index c51b25f45a..505ada4b28 100644
---
a/tests/integration/src/test/java/org/apache/pulsar/tests/integration/presto/TestBasicPresto.java
+++
b/tests/integration/src/test/java/org/apache/pulsar/tests/integration/presto/TestBasicPresto.java
@@ -87,6 +87,14 @@ public void testSimpleSQLQuery() throws Exception {
producer.send(stock);
}
+ ContainerExecResult result = execQuery("show schemas in pulsar;");
+ assertThat(result.getExitCode()).isEqualTo(0);
+ assertThat(result.getStdout()).contains("public/default");
+
+ result = execQuery("show tables in pulsar.\"public/default\";");
+ assertThat(result.getExitCode()).isEqualTo(0);
+ assertThat(result.getStdout()).contains("stocks");
+
ContainerExecResult containerExecResult = execQuery("select * from
pulsar.\"public/default\".stocks order by entryid;");
assertThat(containerExecResult.getExitCode()).isEqualTo(0);
log.info("select sql query output \n{}",
containerExecResult.getStdout());
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
