Apache-Phoenix | 5.1 | HBase 2.3 | Build #211 SUCCESS
5.1 branch HBase 2.3 build #211 status SUCCESS Build #211 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/211/
Apache-Phoenix | 5.1 | HBase 2.4 | Build #211 SUCCESS
5.1 branch HBase 2.4 build #211 status SUCCESS Build #211 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/211/
Apache-Phoenix | 5.1 | HBase 2.5 | Build #211 FAILURE
5.1 branch HBase 2.5 build #211 status FAILURE Build #211 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/211/
[phoenix] branch 5.1 updated: PHOENIX-5066 The TimeZone is incorrectly used during writing or reading data
This is an automated email from the ASF dual-hosted git repository.
stoty pushed a commit to branch 5.1
in repository https://gitbox.apache.org/repos/asf/phoenix.git
The following commit(s) were added to refs/heads/5.1 by this push:
new 621e9abd4d PHOENIX-5066 The TimeZone is incorrectly used during
writing or reading data
621e9abd4d is described below
commit 621e9abd4d27b338e1b94804d3542d56c955b455
Author: Istvan Toth
AuthorDate: Tue Mar 7 08:45:23 2023 +0100
PHOENIX-5066 The TimeZone is incorrectly used during writing or reading data
Add the phoenix.query.applyTimeZoneDisplacement option, that causes the
java.sql time types to be treated as local times.
This option is disabled by default, it needs to be enabled to get the new
behaviour.
---
.../phoenix/end2end/TimeZoneDisplacementIT.java| 299 +
.../apache/phoenix/compile/StatementContext.java | 55 ++--
.../expression/function/CurrentDateFunction.java | 4 +-
.../expression/function/CurrentTimeFunction.java | 2 +-
.../expression/function/ToDateFunction.java| 2 +-
.../org/apache/phoenix/jdbc/PhoenixConnection.java | 29 +-
.../phoenix/jdbc/PhoenixPreparedStatement.java | 75 --
.../org/apache/phoenix/jdbc/PhoenixResultSet.java | 100 ---
.../org/apache/phoenix/jdbc/PhoenixStatement.java | 10 +-
.../apache/phoenix/parse/CurrentDateParseNode.java | 2 +-
.../apache/phoenix/parse/CurrentTimeParseNode.java | 2 +-
.../org/apache/phoenix/parse/ToDateParseNode.java | 2 +-
.../org/apache/phoenix/parse/ToTimeParseNode.java | 2 +-
.../apache/phoenix/parse/ToTimestampParseNode.java | 2 +-
.../org/apache/phoenix/query/QueryServices.java| 1 +
.../apache/phoenix/query/QueryServicesOptions.java | 1 +
.../java/org/apache/phoenix/util/DateUtil.java | 117
.../java/org/apache/phoenix/util/DateUtilTest.java | 171
pom.xml| 8 +-
19 files changed, 773 insertions(+), 111 deletions(-)
diff --git
a/phoenix-core/src/it/java/org/apache/phoenix/end2end/TimeZoneDisplacementIT.java
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/TimeZoneDisplacementIT.java
new file mode 100644
index 00..6b50efd43b
--- /dev/null
+++
b/phoenix-core/src/it/java/org/apache/phoenix/end2end/TimeZoneDisplacementIT.java
@@ -0,0 +1,299 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+package org.apache.phoenix.end2end;
+
+import static org.apache.phoenix.util.TestUtil.TEST_PROPERTIES;
+import static org.junit.Assert.assertEquals;
+import static org.junit.Assert.assertTrue;
+
+import java.sql.DriverManager;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+import java.sql.Statement;
+import java.time.LocalDateTime;
+import java.util.Properties;
+import java.util.TimeZone;
+
+import org.apache.phoenix.jdbc.PhoenixConnection;
+import org.apache.phoenix.query.QueryServices;
+import org.apache.phoenix.util.DateUtil;
+import org.apache.phoenix.util.PropertiesUtil;
+import org.junit.Test;
+import org.junit.experimental.categories.Category;
+
+@Category(ParallelStatsEnabledTest.class)
+public class TimeZoneDisplacementIT extends ParallelStatsEnabledIT {
+
+@Test
+public void testCompliantCorrection() throws Exception {
+String tableName = generateUniqueName();
+Properties props = PropertiesUtil.deepCopy(TEST_PROPERTIES);
+props.put(QueryServices.APPLY_TIME_ZONE_DISPLACMENT_ATTRIB,
Boolean.TRUE.toString());
+try (PhoenixConnection conn =
+(PhoenixConnection) DriverManager.getConnection(getUrl(),
props);
+Statement stmt = conn.createStatement();
+PreparedStatement insertPstmt =
+conn.prepareStatement("upsert into " + tableName
++ " (ID, D1, D2, T1, T2, S1, S2, UD1, UD2,
UT1, UT2, US1, US2) VALUES"
++ " (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
")) {
+conn.setAutoCommit(true);
+stmt.executeUpdate("create table " + tableName + " (id integer
primary key,"
++ "D1 DATE, D2 DATE," + "T1 TIME, T2 TIME," + "S1
Apache-Phoenix | 5.1 | HBase 2.2 | Build #210 FAILURE
5.1 branch HBase 2.2 build #210 status FAILURE Build #210 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/210/
Apache-Phoenix | 5.1 | HBase 2.3 | Build #210 FAILURE
5.1 branch HBase 2.3 build #210 status FAILURE Build #210 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/210/
Apache-Phoenix | 5.1 | HBase 2.5 | Build #210 FAILURE
5.1 branch HBase 2.5 build #210 status FAILURE Build #210 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/210/
Apache-Phoenix | 5.1 | HBase 2.4 | Build #210 FAILURE
5.1 branch HBase 2.4 build #210 status FAILURE Build #210 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/210/
Apache-Phoenix | 5.1 | HBase 2.1 | Build #210 FAILURE
5.1 branch HBase 2.1 build #210 status FAILURE Build #210 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/210/
[phoenix] branch 5.1 updated: PHOENIX-6893 Remove explicit dependency declaration on hbase-thirdparty artifacts (addendum: fix maven-dependency-plugin config)
This is an automated email from the ASF dual-hosted git repository. stoty pushed a commit to branch 5.1 in repository https://gitbox.apache.org/repos/asf/phoenix.git The following commit(s) were added to refs/heads/5.1 by this push: new dd8e5fdc56 PHOENIX-6893 Remove explicit dependency declaration on hbase-thirdparty artifacts (addendum: fix maven-dependency-plugin config) dd8e5fdc56 is described below commit dd8e5fdc56a244c39fa9b619f3437bca54f8da85 Author: Istvan Toth AuthorDate: Tue Mar 7 16:03:21 2023 +0100 PHOENIX-6893 Remove explicit dependency declaration on hbase-thirdparty artifacts (addendum: fix maven-dependency-plugin config) --- pom.xml | 5 + 1 file changed, 5 insertions(+) diff --git a/pom.xml b/pom.xml index 9515d08fb2..f7217b0820 100644 --- a/pom.xml +++ b/pom.xml @@ -397,8 +397,13 @@ + dnsjava:dnsjava + + + org.apache.hbase.thirdparty:* +
Apache-Phoenix | 5.1 | HBase 2.2 | Build #209 FAILURE
5.1 branch HBase 2.2 build #209 status FAILURE Build #209 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/209/
[phoenix-omid] branch dependabot/maven/org.bouncycastle-bcprov-jdk15on-1.67 created (now 49926b73)
This is an automated email from the ASF dual-hosted git repository. github-bot pushed a change to branch dependabot/maven/org.bouncycastle-bcprov-jdk15on-1.67 in repository https://gitbox.apache.org/repos/asf/phoenix-omid.git at 49926b73 Bump bcprov-jdk15on from 1.60 to 1.67 No new revisions were added by this update.
[phoenix-omid] branch dependabot/maven/org.yaml-snakeyaml-2.0 created (now 56a9f00d)
This is an automated email from the ASF dual-hosted git repository. github-bot pushed a change to branch dependabot/maven/org.yaml-snakeyaml-2.0 in repository https://gitbox.apache.org/repos/asf/phoenix-omid.git at 56a9f00d Bump snakeyaml from 1.33 to 2.0 No new revisions were added by this update.
[phoenix-omid] branch master updated (e927aa26 -> 26906021)
This is an automated email from the ASF dual-hosted git repository.
richardantal pushed a change to branch master
in repository https://gitbox.apache.org/repos/asf/phoenix-omid.git
from e927aa26 OMID-234 Bump SnakeYaml version to 1.33 (#127)
add 26906021 OMID-239 OMID TLS support (#129)
No new revisions were added by this update.
Summary of changes:
common/pom.xml | 47 ++
.../java/org/apache/omid/tls/KeyStoreFileType.java | 116 +
.../java/org/apache/omid/tls/X509Exception.java| 76 +++
.../main/java/org/apache/omid/tls/X509Util.java| 286
.../omid/tls/BaseX509ParameterizedTestCase.java| 107 +
.../org/apache/omid/tls/TestKeyStoreFileType.java | 110 +
.../java/org/apache/omid/tls/TestX509Util.java | 378 +++
.../test/java/org/apache/omid/tls/X509KeyType.java | 18 +-
.../java/org/apache/omid/tls/X509TestContext.java | 514 +
.../java/org/apache/omid/tls/X509TestHelpers.java | 436 +
pom.xml| 17 +-
transaction-client/pom.xml | 25 +
.../omid/tso/client/OmidClientConfiguration.java | 169 +++
.../java/org/apache/omid/tso/client/TSOClient.java | 50 ++
.../src/main/resources/omid-client-config.yml | 6 +
.../apache/omid/tso/client/TestGetSslContext.java | 83
.../tso/client/TestOmidClientConfiguration.java| 27 ++
.../resources/tlstest-omid-client-config.yml} | 17 +
tso-server/pom.xml | 19 +
.../org/apache/omid/tso/TSOChannelHandler.java | 42 ++
.../java/org/apache/omid/tso/TSOServerConfig.java | 131 ++
.../default-omid-server-configuration.yml | 5 +
.../org/apache/omid/tso/TSOServerConfigTest.java | 33 +-
.../tso/client/TestTSOClientConnectionToTSO.java | 428 +
.../resources/tlstest-omid-server-config.yml} | 17 +
25 files changed, 3148 insertions(+), 9 deletions(-)
create mode 100644
common/src/main/java/org/apache/omid/tls/KeyStoreFileType.java
create mode 100644 common/src/main/java/org/apache/omid/tls/X509Exception.java
create mode 100644 common/src/main/java/org/apache/omid/tls/X509Util.java
create mode 100644
common/src/test/java/org/apache/omid/tls/BaseX509ParameterizedTestCase.java
create mode 100644
common/src/test/java/org/apache/omid/tls/TestKeyStoreFileType.java
create mode 100644 common/src/test/java/org/apache/omid/tls/TestX509Util.java
copy metrics/src/main/java/org/apache/omid/metrics/Gauge.java =>
common/src/test/java/org/apache/omid/tls/X509KeyType.java (63%)
create mode 100644
common/src/test/java/org/apache/omid/tls/X509TestContext.java
create mode 100644
common/src/test/java/org/apache/omid/tls/X509TestHelpers.java
create mode 100644
transaction-client/src/test/java/org/apache/omid/tso/client/TestGetSslContext.java
copy transaction-client/src/{main/resources/omid-client-config.yml =>
test/resources/tlstest-omid-client-config.yml} (81%)
copy tso-server/src/{main/resources/default-omid-server-configuration.yml =>
test/resources/tlstest-omid-server-config.yml} (95%)
Apache-Phoenix | 5.1 | HBase 2.1 | Build #209 FAILURE
5.1 branch HBase 2.1 build #209 status FAILURE Build #209 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/209/
Apache-Phoenix | master | HBase 2.4 | Build #510 SUCCESS
master branch HBase 2.4 build #510 status SUCCESS Build #510 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/master/510/
Apache-Phoenix | master | HBase 2.5 | Build #510 FAILURE
master branch HBase 2.5 build #510 status FAILURE Build #510 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/master/510/
Apache-Phoenix | 5.1 | HBase 2.3 | Build #209 FAILURE
5.1 branch HBase 2.3 build #209 status FAILURE Build #209 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/209/
Apache-Phoenix | 5.1 | HBase 2.4 | Build #209 FAILURE
5.1 branch HBase 2.4 build #209 status FAILURE Build #209 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/209/
Apache-Phoenix | master | HBase 2.5 | Build #509 FAILURE
master branch HBase 2.5 build #509 status FAILURE Build #509 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/master/509/
Apache-Phoenix | master | HBase 2.4 | Build #509 FAILURE
master branch HBase 2.4 build #509 status FAILURE Build #509 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/master/509/
Apache-Phoenix | 5.1 | HBase 2.5 | Build #209 FAILURE
5.1 branch HBase 2.5 build #209 status FAILURE Build #209 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/209/
