Apache-Phoenix | 4.16 | HBase 1.6 | Build #89 ABORTED
4.16 branch HBase 1.6 build #89 status ABORTED Build #89 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/4.16/89/
Apache-Phoenix | 5.1 | HBase 2.2 | Build #97 ABORTED
5.1 branch HBase 2.2 build #97 status ABORTED Build #97 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/97/
Apache-Phoenix | 4.x | HBase 1.4 | Build #329 SUCCESS
4.x branch HBase 1.4 build #329 status SUCCESS Build #329 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/4.x/329/
Apache-Phoenix | 5.1 | HBase 2.2 | Build #96 ABORTED
5.1 branch HBase 2.2 build #96 status ABORTED Build #96 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/96/
Apache-Phoenix | 4.16 | HBase 1.4 | Build #89 SUCCESS
4.16 branch HBase 1.4 build #89 status SUCCESS Build #89 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/4.16/89/
Apache-Phoenix | 4.x | HBase 1.4 | Build #328 ABORTED
4.x branch HBase 1.4 build #328 status ABORTED Build #328 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/4.x/328/
Apache-Phoenix | 4.16 | HBase 1.4 | Build #88 ABORTED
4.16 branch HBase 1.4 build #88 status ABORTED Build #88 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/4.16/88/
svn commit: r1893731 [1/4] - in /phoenix/site: publish/ publish/language/ source/src/site/markdown/
Author: kadir Date: Wed Sep 29 18:15:00 2021 New Revision: 1893731 URL: http://svn.apache.org/viewvc?rev=1893731&view=rev Log: Updated the upcoming tech talk meeting details Modified: phoenix/site/publish/Phoenix-in-15-minutes-or-less.html phoenix/site/publish/array_type.html phoenix/site/publish/atomic_upsert.html phoenix/site/publish/building.html phoenix/site/publish/building_website.html phoenix/site/publish/bulk_dataload.html phoenix/site/publish/columnencoding.html phoenix/site/publish/contributing.html phoenix/site/publish/cursors.html phoenix/site/publish/develop.html phoenix/site/publish/download.html phoenix/site/publish/dynamic_columns.html phoenix/site/publish/explainplan.html phoenix/site/publish/faq.html phoenix/site/publish/flume.html phoenix/site/publish/hive_storage_handler.html phoenix/site/publish/index.html phoenix/site/publish/installation.html phoenix/site/publish/issues.html phoenix/site/publish/joins.html phoenix/site/publish/kafka.html phoenix/site/publish/language/datatypes.html phoenix/site/publish/language/functions.html phoenix/site/publish/language/index.html phoenix/site/publish/mailing_list.html phoenix/site/publish/metrics.html phoenix/site/publish/multi-tenancy.html phoenix/site/publish/namspace_mapping.html phoenix/site/publish/news.html phoenix/site/publish/omid.html phoenix/site/publish/paged.html phoenix/site/publish/performance.html phoenix/site/publish/pherf.html phoenix/site/publish/phoenix_mr.html phoenix/site/publish/phoenix_on_emr.html phoenix/site/publish/phoenix_orm.html phoenix/site/publish/phoenix_python.html phoenix/site/publish/phoenix_spark.html phoenix/site/publish/phoenixcon.html phoenix/site/publish/pig_integration.html phoenix/site/publish/python.html phoenix/site/publish/recent.html phoenix/site/publish/release.html phoenix/site/publish/release_notes.html phoenix/site/publish/resources.html phoenix/site/publish/roadmap.html phoenix/site/publish/rowtimestamp.html phoenix/site/publish/salted.html phoenix/site/publish/secondary_indexing.html phoenix/site/publish/sequences.html phoenix/site/publish/server.html phoenix/site/publish/skip_scan.html phoenix/site/publish/source.html phoenix/site/publish/subqueries.html phoenix/site/publish/tablesample.html phoenix/site/publish/team.html phoenix/site/publish/tech_talks.html phoenix/site/publish/tephra.html phoenix/site/publish/tracing.html phoenix/site/publish/transactions.html phoenix/site/publish/tuning.html phoenix/site/publish/tuning_guide.html phoenix/site/publish/udf.html phoenix/site/publish/update_statistics.html phoenix/site/publish/upgrading.html phoenix/site/publish/views.html phoenix/site/publish/who_is_using.html phoenix/site/source/src/site/markdown/tech_talks.md Modified: phoenix/site/publish/Phoenix-in-15-minutes-or-less.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/Phoenix-in-15-minutes-or-less.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/Phoenix-in-15-minutes-or-less.html (original) +++ phoenix/site/publish/Phoenix-in-15-minutes-or-less.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/array_type.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/array_type.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/array_type.html (original) +++ phoenix/site/publish/array_type.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/atomic_upsert.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/atomic_upsert.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/atomic_upsert.html (original) +++ phoenix/site/publish/atomic_upsert.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/building.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/building.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/building.html (original) +++ phoenix/site/publish/building.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/building_website.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/building_website.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/building_website.html (original) +++ phoenix/site/publish/building_website.html Wed Sep 29 18:15:00 202
svn commit: r1893731 [2/4] - in /phoenix/site: publish/ publish/language/ source/src/site/markdown/
Modified: phoenix/site/publish/language/functions.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/functions.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/language/functions.html (original) +++ phoenix/site/publish/language/functions.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ @@ -168,1886 +168,7 @@ Functions - - - -Aggregate Functions - - - - - - -AVG - -COUNT - -APPROX_COUNT_DISTINCT - -MAX - -MIN - -SUM - - -PERCENTILE_CONT - -PERCENTILE_DISC - -PERCENT_RANK - -FIRST_VALUE - -LAST_VALUE - -FIRST_VALUES - - -LAST_VALUES - -NTH_VALUE - -STDDEV_POP - -STDDEV_SAMP - - - - - -String Functions - - - - - - -SUBSTR - -INSTR - -TRIM - -LTRIM - -RTRIM - - -LPAD - -LENGTH - -REGEXP_SUBSTR - -REGEXP_REPLACE - -REGEXP_SPLIT - - -UPPER - -LOWER - -REVERSE - -TO_CHAR - -COLLATION_KEY - - - - - -Time and Date Functions - - - - - - -TO_DATE - -TO_TIME - -TO_TIMESTAMP - -CURRENT_TIME - -CONVERT_TZ - -TIMEZONE_OFFSET - - -NOW - -YEAR - -MONTH - -WEEK - -DAYOFYEAR - -DAYOFMONTH - - -DAYOFWEEK - -HOUR - -MINUTE - -SECOND - - - - - -Numeric Functions - - - - - - -ROUND - -CEIL - - -FLOOR - -TRUNC - - -TO_NUMBER - -RAND - - - - - -Array Functions - - - - - - -ARRAY_ELEM - -ARRAY_LENGTH - -ARRAY_APPEND - - -ARRAY_PREPEND - -ARRAY_CAT - -ARRAY_FILL - - -ARRAY_TO_STRING - -ANY - -ALL - - - - - -Math Functions - - - - - - -SIGN - -ABS - -SQRT - - -CBRT - -EXP - -POWER - - -LN - -LOG - - - - - -Other Functions - - - - - - -MD5 - -INVERT - -ENCODE - -DECODE - - -COALESCE - -GET_BIT - -GET_BYTE - -OCTET_LENGTH - - -SET_BIT - -SET_BYTE - - - - - - - -AVG - - -AVG ( { numericTerm } ) - - -AVG ( numericTerm ) - - - -The average (mean) value. If no rows are selected, the result is NULL. Aggregates are only allowed in select statements. The returned value is of the same data type as the parameter. -Example: -AVG(X) - -COUNT - - -COUNT( [ DISTINCT ] { * | { term } } ) - - -COUNT ( DISTINCT*term) - - - -The count of all row, or of the non-null values. This method returns a long. When DISTINCT is used, it counts only distinct values. If no rows are selec
svn commit: r1893731 [3/4] - in /phoenix/site: publish/ publish/language/ source/src/site/markdown/
Modified: phoenix/site/publish/language/index.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/language/index.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/language/index.html (original) +++ phoenix/site/publish/language/index.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ @@ -168,1678 +168,7 @@ Grammar - - - -Commands - - - - - - -SELECT - -UPSERT VALUES - -UPSERT SELECT - -DELETE - -DECLARE CURSOR - -OPEN CURSOR - -FETCH NEXT - -CLOSE - -CREATE TABLE - - -DROP TABLE - -CREATE FUNCTION - -DROP FUNCTION - -CREATE VIEW - -DROP VIEW - -CREATE SEQUENCE - -DROP SEQUENCE - -ALTER - -CREATE INDEX - - -DROP INDEX - -ALTER INDEX - -EXPLAIN - -UPDATE STATISTICS - -CREATE SCHEMA - -USE - -DROP SCHEMA - -GRANT - -REVOKE - - - - - -Other Grammar - - - - - - -Constraint - -Options - -Hint - -Scan Hint - -Cache Hint - -Index Hint - -Small Hint - -Seek To Column Hint - -Join Hint - -Serial Hint - -Column Def - -Table Ref - -Sequence Ref - -Column Ref - -Select Expression - -Select Statement - -Split Point - -Table Spec - -Aliased Table Ref - - -Join Type - -Func Argument - -Class Name - -Jar Path - -Order - -Expression - -And Condition - -Boolean Condition - -Condition - -RHS Operand - -Operand - -Summand - -Factor - -Term - -Array Constructor - -Sequence - -Cast - -Row Value Constructor - -Bind Parameter - - -Value - -Case - -Case When - -Name - -Quoted Name - -Alias - -Null - -Data Type - -SQL Data Type - -HBase Data Type - -String - -Boolean - -Numeric - -Int - -Long - -Decimal - -Number - -Comments - - - - - - -SELECT - - -selectStatement [ { UNION ALL selectStatement [...] } ] -[ ORDER BY order [,...] ] [ LIMIT {bindParameter | number} ] -[ OFFSET {bindParameter | number} [ ROW | ROWS ] ] [ FETCH { FIRST | NEXT } {bindParameter | number} { ROW | ROWS } ONLY ] - - -selectStatement UNION ALL selectStatement ... ORDER BY order , ... LIMITbindParameter< /td>number OFFSETbindParameternumber < /td>ROWROWS FETCHFIRSTNEXTbindParameternumberROWROWSONLY - - - -Selects data from one or more tables. UNION ALL combines rows from multiple select statements. ORDER BY sorts the result based on the given expressions. LIMIT(or FETCH FIRST) limits the number of rows returned by the query with no limit applied if unspecified or specified as null or less than zero. The LIMIT(or FETCH FIRST) clause is executed after the ORDER BY clause to support to
svn commit: r1893731 [4/4] - in /phoenix/site: publish/ publish/language/ source/src/site/markdown/
Modified: phoenix/site/publish/metrics.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/metrics.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/metrics.html (original) +++ phoenix/site/publish/metrics.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/multi-tenancy.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/multi-tenancy.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/multi-tenancy.html (original) +++ phoenix/site/publish/multi-tenancy.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/namspace_mapping.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/namspace_mapping.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/namspace_mapping.html (original) +++ phoenix/site/publish/namspace_mapping.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/news.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/news.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/news.html (original) +++ phoenix/site/publish/news.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/omid.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/omid.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/omid.html (original) +++ phoenix/site/publish/omid.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/paged.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/paged.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/paged.html (original) +++ phoenix/site/publish/paged.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/performance.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/performance.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/performance.html (original) +++ phoenix/site/publish/performance.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/pherf.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/pherf.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/pherf.html (original) +++ phoenix/site/publish/pherf.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/phoenix_mr.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_mr.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/phoenix_mr.html (original) +++ phoenix/site/publish/phoenix_mr.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/phoenix_on_emr.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_on_emr.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/phoenix_on_emr.html (original) +++ phoenix/site/publish/phoenix_on_emr.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/phoenix_orm.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_orm.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/phoenix_orm.html (original) +++ phoenix/site/publish/phoenix_orm.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/phoenix_python.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_python.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/phoenix_python.html (original) +++ phoenix/site/publish/phoenix_python.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modified: phoenix/site/publish/phoenix_spark.html URL: http://svn.apache.org/viewvc/phoenix/site/publish/phoenix_spark.html?rev=1893731&r1=1893730&r2=1893731&view=diff == --- phoenix/site/publish/phoenix_spark.html (original) +++ phoenix/site/publish/phoenix_spark.html Wed Sep 29 18:15:00 2021 @@ -1,7 +1,7 @@ Modifi
Apache-Phoenix | 4.x | HBase 1.6 | Build #328 SUCCESS
4.x branch HBase 1.6 build #328 status SUCCESS Build #328 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/4.x/328/
Apache-Phoenix | 4.x | HBase 1.6 | Build #329 SUCCESS
4.x branch HBase 1.6 build #329 status SUCCESS Build #329 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/4.x/329/
Apache-Phoenix | 5.1 | HBase 2.1 | Build #96 SUCCESS
5.1 branch HBase 2.1 build #96 status SUCCESS Build #96 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/96/
Apache-Phoenix | master | HBase 2.1 | Build #345 SUCCESS
master branch HBase 2.1 build #345 status SUCCESS Build #345 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/master/345/
Apache-Phoenix | master | HBase 2.1 | Build #346 SUCCESS
master branch HBase 2.1 build #346 status SUCCESS Build #346 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/master/346/
Apache-Phoenix | 5.1 | HBase 2.1 | Build #97 SUCCESS
5.1 branch HBase 2.1 build #97 status SUCCESS Build #97 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/97/
Apache-Phoenix | 5.1 | HBase 2.3 | Build #97 FAILURE
5.1 branch HBase 2.3 build #97 status FAILURE Build #97 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/97/
Apache-Phoenix | 4.16 | HBase 1.6 | Build #88 SUCCESS
4.16 branch HBase 1.6 build #88 status SUCCESS Build #88 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/4.16/88/
Apache-Phoenix | 4.16 | HBase 1.3 | Build #88 FAILURE
4.16 branch HBase 1.3 build #88 status FAILURE Build #88 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/4.16/88/
Apache-Phoenix | master | HBase 2.2 | Build #345 FAILURE
master branch HBase 2.2 build #345 status FAILURE Build #345 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/master/345/
Apache-Phoenix | master | HBase 2.3 | Build #345 SUCCESS
master branch HBase 2.3 build #345 status SUCCESS Build #345 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/master/345/
Apache-Phoenix | 5.1 | HBase 2.4 | Build #96 SUCCESS
5.1 branch HBase 2.4 build #96 status SUCCESS Build #96 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/96/
Apache-Phoenix | master | HBase 2.4 | Build #345 SUCCESS
master branch HBase 2.4 build #345 status SUCCESS Build #345 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/master/345/
Apache-Phoenix | 5.1 | HBase 2.3 | Build #96 FAILURE
5.1 branch HBase 2.3 build #96 status FAILURE Build #96 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/96/
Apache-Phoenix | 4.16 | HBase 1.3 | Build #89 FAILURE
4.16 branch HBase 1.3 build #89 status FAILURE Build #89 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/4.16/89/
Apache-Phoenix | 5.1 | HBase 2.4 | Build #97 FAILURE
5.1 branch HBase 2.4 build #97 status FAILURE Build #97 https://ci-hadoop.apache.org/job/Phoenix/job/Phoenix-mulitbranch/job/5.1/97/
[phoenix] branch 4.16 updated: PHOENIX-6563 Unable to use 'UPPER'/'LOWER' together with 'IN'
This is an automated email from the ASF dual-hosted git repository. richardantal pushed a commit to branch 4.16 in repository https://gitbox.apache.org/repos/asf/phoenix.git The following commit(s) were added to refs/heads/4.16 by this push: new e902881 PHOENIX-6563 Unable to use 'UPPER'/'LOWER' together with 'IN' e902881 is described below commit e902881d645ab0dcdc6e6213f11f42c59bad102c Author: Richard Antal AuthorDate: Tue Sep 28 13:49:44 2021 +0200 PHOENIX-6563 Unable to use 'UPPER'/'LOWER' together with 'IN' --- .../java/org/apache/phoenix/end2end/InListIT.java | 52 ++ .../phoenix/expression/function/LowerFunction.java | 7 ++- .../phoenix/expression/function/UpperFunction.java | 7 ++- 3 files changed, 64 insertions(+), 2 deletions(-) diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java index d1ebdd2..b16f704 100644 --- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java +++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java @@ -593,6 +593,58 @@ public class InListIT extends ParallelStatsDisabledIT { } } +@Test +public void testUpperWithInChar() throws Exception { +String baseTable = generateUniqueName(); +try (Connection conn = DriverManager.getConnection(getUrl()); + Statement stmt = conn.createStatement()) { +stmt.execute("CREATE TABLE " + baseTable + +" (ID BIGINT NOT NULL primary key, A CHAR(2))"); +PreparedStatement pstmt = conn.prepareStatement("UPSERT INTO " + baseTable + +" VALUES (?, ?)"); +pstmt.setInt(1, 1); +pstmt.setString(2, "a"); +pstmt.executeUpdate(); +conn.commit(); +pstmt.setInt(1, 2); +pstmt.setString(2, "b"); +pstmt.executeUpdate(); +conn.commit(); + +ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM " + baseTable + +" WHERE UPPER(A) IN ('A', 'C')"); +assertTrue(rs.next()); +assertEquals(rs.getString(2), "a"); +assertFalse(rs.next()); +} +} + +@Test +public void testLowerWithInChar() throws Exception { +String baseTable = generateUniqueName(); +try (Connection conn = DriverManager.getConnection(getUrl()); + Statement stmt = conn.createStatement()) { +stmt.execute("CREATE TABLE " + baseTable + +" (ID BIGINT NOT NULL primary key, A CHAR(2))"); +PreparedStatement pstmt = conn.prepareStatement("UPSERT INTO " + baseTable + +" VALUES (?, ?)"); +pstmt.setInt(1, 1); +pstmt.setString(2, "A"); +pstmt.executeUpdate(); +conn.commit(); +pstmt.setInt(1, 2); +pstmt.setString(2, "B"); +pstmt.executeUpdate(); +conn.commit(); + +ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM " + baseTable + +" WHERE LOWER(A) IN ('a', 'c')"); +assertTrue(rs.next()); +assertEquals(rs.getString(2), "A"); +assertFalse(rs.next()); +} +} + @Test(expected = TypeMismatchException.class) public void testInListExpressionWithNotValidElements() throws Exception { try (Connection conn = DriverManager.getConnection(getUrl())) { diff --git a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java index 8d468b3..f444d36 100644 --- a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java +++ b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java @@ -50,7 +50,7 @@ public class LowerFunction extends ScalarFunction { } private void initialize() { -if(children.size() > 1) { +if (children.size() > 1) { String localeISOCode = getLiteralValue(1, String.class); locale = LocaleUtils.get().getLocaleByIsoCode(localeISOCode); } @@ -89,6 +89,11 @@ public class LowerFunction extends ScalarFunction { } @Override +public Integer getMaxLength() { +return getStrExpression().getMaxLength(); +} + +@Override public boolean isNullable() { return getStrExpression().isNullable(); } diff --git a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java index c8e7096..0969269 100644 --- a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java +++ b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java
[phoenix] branch 4.x updated: PHOENIX-6563 Unable to use 'UPPER'/'LOWER' together with 'IN'
This is an automated email from the ASF dual-hosted git repository. richardantal pushed a commit to branch 4.x in repository https://gitbox.apache.org/repos/asf/phoenix.git The following commit(s) were added to refs/heads/4.x by this push: new 4df9540 PHOENIX-6563 Unable to use 'UPPER'/'LOWER' together with 'IN' 4df9540 is described below commit 4df9540362809b84a627ef1ac7540d697e7cdd22 Author: Richard Antal AuthorDate: Tue Sep 28 13:49:44 2021 +0200 PHOENIX-6563 Unable to use 'UPPER'/'LOWER' together with 'IN' --- .../java/org/apache/phoenix/end2end/InListIT.java | 52 ++ .../phoenix/expression/function/LowerFunction.java | 7 ++- .../phoenix/expression/function/UpperFunction.java | 7 ++- 3 files changed, 64 insertions(+), 2 deletions(-) diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java index d1ebdd2..b16f704 100644 --- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java +++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java @@ -593,6 +593,58 @@ public class InListIT extends ParallelStatsDisabledIT { } } +@Test +public void testUpperWithInChar() throws Exception { +String baseTable = generateUniqueName(); +try (Connection conn = DriverManager.getConnection(getUrl()); + Statement stmt = conn.createStatement()) { +stmt.execute("CREATE TABLE " + baseTable + +" (ID BIGINT NOT NULL primary key, A CHAR(2))"); +PreparedStatement pstmt = conn.prepareStatement("UPSERT INTO " + baseTable + +" VALUES (?, ?)"); +pstmt.setInt(1, 1); +pstmt.setString(2, "a"); +pstmt.executeUpdate(); +conn.commit(); +pstmt.setInt(1, 2); +pstmt.setString(2, "b"); +pstmt.executeUpdate(); +conn.commit(); + +ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM " + baseTable + +" WHERE UPPER(A) IN ('A', 'C')"); +assertTrue(rs.next()); +assertEquals(rs.getString(2), "a"); +assertFalse(rs.next()); +} +} + +@Test +public void testLowerWithInChar() throws Exception { +String baseTable = generateUniqueName(); +try (Connection conn = DriverManager.getConnection(getUrl()); + Statement stmt = conn.createStatement()) { +stmt.execute("CREATE TABLE " + baseTable + +" (ID BIGINT NOT NULL primary key, A CHAR(2))"); +PreparedStatement pstmt = conn.prepareStatement("UPSERT INTO " + baseTable + +" VALUES (?, ?)"); +pstmt.setInt(1, 1); +pstmt.setString(2, "A"); +pstmt.executeUpdate(); +conn.commit(); +pstmt.setInt(1, 2); +pstmt.setString(2, "B"); +pstmt.executeUpdate(); +conn.commit(); + +ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM " + baseTable + +" WHERE LOWER(A) IN ('a', 'c')"); +assertTrue(rs.next()); +assertEquals(rs.getString(2), "A"); +assertFalse(rs.next()); +} +} + @Test(expected = TypeMismatchException.class) public void testInListExpressionWithNotValidElements() throws Exception { try (Connection conn = DriverManager.getConnection(getUrl())) { diff --git a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java index 8d468b3..f444d36 100644 --- a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java +++ b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java @@ -50,7 +50,7 @@ public class LowerFunction extends ScalarFunction { } private void initialize() { -if(children.size() > 1) { +if (children.size() > 1) { String localeISOCode = getLiteralValue(1, String.class); locale = LocaleUtils.get().getLocaleByIsoCode(localeISOCode); } @@ -89,6 +89,11 @@ public class LowerFunction extends ScalarFunction { } @Override +public Integer getMaxLength() { +return getStrExpression().getMaxLength(); +} + +@Override public boolean isNullable() { return getStrExpression().isNullable(); } diff --git a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java index c8e7096..0969269 100644 --- a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java +++ b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java @@
[phoenix] branch 5.1 updated: PHOENIX-6563 Unable to use 'UPPER'/'LOWER' together with 'IN'
This is an automated email from the ASF dual-hosted git repository. richardantal 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 5e92f26 PHOENIX-6563 Unable to use 'UPPER'/'LOWER' together with 'IN' 5e92f26 is described below commit 5e92f26145eb69e8435556b9e8a119b86333128a Author: Richard Antal AuthorDate: Tue Sep 28 13:49:44 2021 +0200 PHOENIX-6563 Unable to use 'UPPER'/'LOWER' together with 'IN' --- .../java/org/apache/phoenix/end2end/InListIT.java | 52 ++ .../phoenix/expression/function/LowerFunction.java | 7 ++- .../phoenix/expression/function/UpperFunction.java | 7 ++- 3 files changed, 64 insertions(+), 2 deletions(-) diff --git a/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java b/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java index d71400c..c64426c 100644 --- a/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java +++ b/phoenix-core/src/it/java/org/apache/phoenix/end2end/InListIT.java @@ -592,6 +592,58 @@ public class InListIT extends ParallelStatsDisabledIT { } } +@Test +public void testUpperWithInChar() throws Exception { +String baseTable = generateUniqueName(); +try (Connection conn = DriverManager.getConnection(getUrl()); + Statement stmt = conn.createStatement()) { +stmt.execute("CREATE TABLE " + baseTable + +" (ID BIGINT NOT NULL primary key, A CHAR(2))"); +PreparedStatement pstmt = conn.prepareStatement("UPSERT INTO " + baseTable + +" VALUES (?, ?)"); +pstmt.setInt(1, 1); +pstmt.setString(2, "a"); +pstmt.executeUpdate(); +conn.commit(); +pstmt.setInt(1, 2); +pstmt.setString(2, "b"); +pstmt.executeUpdate(); +conn.commit(); + +ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM " + baseTable + +" WHERE UPPER(A) IN ('A', 'C')"); +assertTrue(rs.next()); +assertEquals(rs.getString(2), "a"); +assertFalse(rs.next()); +} +} + +@Test +public void testLowerWithInChar() throws Exception { +String baseTable = generateUniqueName(); +try (Connection conn = DriverManager.getConnection(getUrl()); + Statement stmt = conn.createStatement()) { +stmt.execute("CREATE TABLE " + baseTable + +" (ID BIGINT NOT NULL primary key, A CHAR(2))"); +PreparedStatement pstmt = conn.prepareStatement("UPSERT INTO " + baseTable + +" VALUES (?, ?)"); +pstmt.setInt(1, 1); +pstmt.setString(2, "A"); +pstmt.executeUpdate(); +conn.commit(); +pstmt.setInt(1, 2); +pstmt.setString(2, "B"); +pstmt.executeUpdate(); +conn.commit(); + +ResultSet rs = conn.createStatement().executeQuery("SELECT * FROM " + baseTable + +" WHERE LOWER(A) IN ('a', 'c')"); +assertTrue(rs.next()); +assertEquals(rs.getString(2), "A"); +assertFalse(rs.next()); +} +} + @Test(expected = TypeMismatchException.class) public void testInListExpressionWithNotValidElements() throws Exception { try (Connection conn = DriverManager.getConnection(getUrl())) { diff --git a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java index 8d468b3..f444d36 100644 --- a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java +++ b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/LowerFunction.java @@ -50,7 +50,7 @@ public class LowerFunction extends ScalarFunction { } private void initialize() { -if(children.size() > 1) { +if (children.size() > 1) { String localeISOCode = getLiteralValue(1, String.class); locale = LocaleUtils.get().getLocaleByIsoCode(localeISOCode); } @@ -89,6 +89,11 @@ public class LowerFunction extends ScalarFunction { } @Override +public Integer getMaxLength() { +return getStrExpression().getMaxLength(); +} + +@Override public boolean isNullable() { return getStrExpression().isNullable(); } diff --git a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java index c8e7096..0969269 100644 --- a/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java +++ b/phoenix-core/src/main/java/org/apache/phoenix/expression/function/UpperFunction.java @@
[phoenix] branch master updated (dd3d853 -> 4e5ac4d)
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.git. from dd3d853 PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority add 4e5ac4d PHOENIX-6563 Unable to use 'UPPER'/'LOWER' together with 'IN' No new revisions were added by this update. Summary of changes: .../java/org/apache/phoenix/end2end/InListIT.java | 52 ++ .../phoenix/expression/function/LowerFunction.java | 7 ++- .../phoenix/expression/function/UpperFunction.java | 7 ++- 3 files changed, 64 insertions(+), 2 deletions(-)
[phoenix] branch 4.16 updated: PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority
This is an automated email from the ASF dual-hosted git repository. stoty pushed a commit to branch 4.16 in repository https://gitbox.apache.org/repos/asf/phoenix.git The following commit(s) were added to refs/heads/4.16 by this push: new d7d6ebd PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority d7d6ebd is described below commit d7d6ebd476e536efb989637d2516ce48ce207981 Author: Istvan Toth AuthorDate: Tue Sep 21 15:16:54 2021 +0200 PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority --- .../phoenix/cache/aggcache/SpillManager.java | 2 +- .../apache/phoenix/compile/ExpressionCompiler.java | 3 ++- .../org/apache/phoenix/compile/JoinCompiler.java | 1 - .../phoenix/compile/OrderPreservingTracker.java| 3 ++- .../phoenix/compile/ServerBuildIndexCompiler.java | 2 +- .../apache/phoenix/compile/SubselectRewriter.java | 3 ++- .../phoenix/compile/TupleProjectionCompiler.java | 2 +- .../phoenix/coprocessor/MetaDataEndpointImpl.java | 7 +++-- .../coprocessor/PhoenixAccessController.java | 6 +++-- .../org/apache/phoenix/execute/BaseQueryPlan.java | 4 ++- .../org/apache/phoenix/execute/HashJoinPlan.java | 4 ++- .../apache/phoenix/expression/LikeExpression.java | 10 +++- .../expression/ProjectedColumnExpression.java | 2 +- .../aggregator/BaseDecimalStddevAggregator.java| 3 +-- .../aggregator/FirstLastValueServerAggregator.java | 5 ++-- .../expression/function/ArrayFillFunction.java | 2 +- .../phoenix/expression/util/regex/JONIPattern.java | 2 +- .../TrackingParallelWriterIndexCommitter.java | 2 +- .../apache/phoenix/index/PhoenixIndexCodec.java| 2 +- .../iterate/NonAggregateRegionScannerFactory.java | 2 +- .../org/apache/phoenix/jdbc/PhoenixConnection.java | 7 ++--- .../phoenix/jdbc/PhoenixPreparedStatement.java | 5 .../phoenix/mapreduce/CsvBulkImportUtil.java | 7 +++-- .../phoenix/mapreduce/MultiHfileOutputFormat.java | 7 - .../apache/phoenix/mapreduce/OrphanViewTool.java | 16 +--- .../phoenix/mapreduce/PhoenixInputFormat.java | 2 +- .../PhoenixServerBuildIndexInputFormat.java| 10 .../bulkload/TargetTableRefFunctions.java | 10 .../mapreduce/index/IndexScrutinyMapper.java | 2 +- .../mapreduce/index/IndexScrutinyTableOutput.java | 2 +- .../phoenix/mapreduce/index/IndexScrutinyTool.java | 1 - .../apache/phoenix/mapreduce/index/IndexTool.java | 2 +- .../phoenix/mapreduce/index/IndexUpgradeTool.java | 4 ++- .../index/IndexVerificationOutputRepository.java | 2 +- .../index/IndexVerificationResultRepository.java | 12 - .../index/PhoenixIndexImportDirectMapper.java | 6 +++-- .../index/PhoenixIndexImportDirectReducer.java | 2 +- .../index/PhoenixIndexPartialBuildMapper.java | 6 +++-- .../index/PhoenixServerBuildIndexMapper.java | 7 +++-- .../index/automation/PhoenixMRJobSubmitter.java| 1 - .../util/DefaultMultiViewSplitStrategy.java| 2 +- .../mapreduce/util/PhoenixConfigurationUtil.java | 4 +-- .../phoenix/monitoring/CombinableMetric.java | 6 ++--- .../phoenix/monitoring/CombinableMetricImpl.java | 2 +- .../java/org/apache/phoenix/optimize/Cost.java | 4 +-- .../apache/phoenix/parse/ChangePermsStatement.java | 3 ++- .../java/org/apache/phoenix/parse/PFunction.java | 6 +++-- .../phoenix/query/ConnectionQueryServicesImpl.java | 9 --- .../query/ConnectionlessQueryServicesImpl.java | 4 --- .../phoenix/query/ITGuidePostsCacheFactory.java| 2 +- .../org/apache/phoenix/query/QueryConstants.java | 5 ++-- .../apache/phoenix/query/QueryServicesOptions.java | 2 +- .../org/apache/phoenix/schema/MetaDataClient.java | 20 --- .../org/apache/phoenix/schema/PMetaDataImpl.java | 2 +- .../java/org/apache/phoenix/schema/PTableImpl.java | 2 +- .../apache/phoenix/schema/SequenceAllocation.java | 4 +++ .../phoenix/schema/stats/GuidePostsInfo.java | 5 .../phoenix/schema/stats/UpdateStatisticsTool.java | 5 +++- .../java/org/apache/phoenix/schema/task/Task.java | 4 +++ .../schema/tool/SchemaSynthesisProcessor.java | 7 +++-- .../org/apache/phoenix/schema/tool/SchemaTool.java | 4 +++ .../phoenix/schema/types/PArrayDataType.java | 4 +++ .../schema/types/PArrayDataTypeEncoder.java| 2 +- .../org/apache/phoenix/schema/types/PDataType.java | 8 +- .../org/apache/phoenix/schema/types/PDecimal.java | 5 ++-- .../apache/phoenix/schema/types/PhoenixArray.java | 2 +- .../org/apache/phoenix/trace/TracingUtils.java | 8 -- .../org/apache/phoenix/trace/util/NullSpan.java| 2 +- .../java/org/apache/phoenix/util/ColumnInfo.java | 5 ++-- .../java/org/apache/phoenix/util/IndexUtil.java| 3 ++- .../java/org/apache/phoenix/util/MetaDataUtil.java | 5 ++-- .../org/apache/phoenix/util/PhoenixMRJobUtil.java | 3 ++- .../org/apac
[phoenix] branch 4.x updated: PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority
This is an automated email from the ASF dual-hosted git repository. stoty pushed a commit to branch 4.x in repository https://gitbox.apache.org/repos/asf/phoenix.git The following commit(s) were added to refs/heads/4.x by this push: new a9101b4 PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority a9101b4 is described below commit a9101bf9d16af28aad55c166493ef96ad0bc Author: Istvan Toth AuthorDate: Tue Sep 21 15:16:54 2021 +0200 PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority --- .../phoenix/cache/aggcache/SpillManager.java | 2 +- .../apache/phoenix/compile/ExpressionCompiler.java | 3 ++- .../org/apache/phoenix/compile/JoinCompiler.java | 1 - .../phoenix/compile/OrderPreservingTracker.java| 3 ++- .../phoenix/compile/ServerBuildIndexCompiler.java | 2 +- .../apache/phoenix/compile/SubselectRewriter.java | 3 ++- .../phoenix/compile/TupleProjectionCompiler.java | 2 +- .../phoenix/coprocessor/MetaDataEndpointImpl.java | 22 +++- .../coprocessor/PhoenixAccessController.java | 2 +- .../org/apache/phoenix/execute/BaseQueryPlan.java | 4 ++- .../org/apache/phoenix/execute/HashJoinPlan.java | 4 ++- .../apache/phoenix/expression/LikeExpression.java | 10 +++- .../expression/ProjectedColumnExpression.java | 2 +- .../aggregator/BaseDecimalStddevAggregator.java| 3 +-- .../aggregator/FirstLastValueServerAggregator.java | 5 ++-- .../expression/function/ArrayFillFunction.java | 2 +- .../phoenix/expression/util/regex/JONIPattern.java | 2 +- .../TrackingParallelWriterIndexCommitter.java | 2 +- .../apache/phoenix/index/PhoenixIndexCodec.java| 2 +- .../iterate/NonAggregateRegionScannerFactory.java | 2 +- .../org/apache/phoenix/jdbc/PhoenixConnection.java | 7 ++--- .../phoenix/jdbc/PhoenixPreparedStatement.java | 5 .../phoenix/mapreduce/CsvBulkImportUtil.java | 7 +++-- .../phoenix/mapreduce/MultiHfileOutputFormat.java | 7 - .../apache/phoenix/mapreduce/OrphanViewTool.java | 16 +--- .../phoenix/mapreduce/PhoenixInputFormat.java | 2 +- .../PhoenixServerBuildIndexInputFormat.java| 10 .../bulkload/TargetTableRefFunctions.java | 10 .../mapreduce/index/IndexScrutinyMapper.java | 2 +- .../mapreduce/index/IndexScrutinyTableOutput.java | 2 +- .../phoenix/mapreduce/index/IndexScrutinyTool.java | 1 - .../apache/phoenix/mapreduce/index/IndexTool.java | 2 +- .../phoenix/mapreduce/index/IndexUpgradeTool.java | 4 ++- .../index/IndexVerificationOutputRepository.java | 2 +- .../index/IndexVerificationResultRepository.java | 12 - .../index/PhoenixIndexImportDirectMapper.java | 6 +++-- .../index/PhoenixIndexImportDirectReducer.java | 2 +- .../index/PhoenixIndexPartialBuildMapper.java | 6 +++-- .../index/PhoenixServerBuildIndexMapper.java | 7 +++-- .../index/automation/PhoenixMRJobSubmitter.java| 1 - .../util/DefaultMultiViewSplitStrategy.java| 2 +- .../mapreduce/util/PhoenixConfigurationUtil.java | 4 +-- .../phoenix/monitoring/CombinableMetric.java | 6 ++--- .../phoenix/monitoring/CombinableMetricImpl.java | 2 +- .../phoenix/monitoring/TableMetricsManager.java| 4 +++ .../java/org/apache/phoenix/optimize/Cost.java | 4 +-- .../apache/phoenix/parse/ChangePermsStatement.java | 3 ++- .../java/org/apache/phoenix/parse/PFunction.java | 6 +++-- .../phoenix/query/ConnectionQueryServicesImpl.java | 12 + .../query/ConnectionlessQueryServicesImpl.java | 4 --- .../phoenix/query/ITGuidePostsCacheFactory.java| 2 +- .../org/apache/phoenix/query/QueryConstants.java | 5 ++-- .../apache/phoenix/query/QueryServicesOptions.java | 2 +- .../org/apache/phoenix/schema/MetaDataClient.java | 20 --- .../org/apache/phoenix/schema/PMetaDataImpl.java | 2 +- .../java/org/apache/phoenix/schema/PTableImpl.java | 2 +- .../apache/phoenix/schema/SequenceAllocation.java | 4 +++ .../phoenix/schema/stats/GuidePostsInfo.java | 5 .../phoenix/schema/stats/UpdateStatisticsTool.java | 5 +++- .../java/org/apache/phoenix/schema/task/Task.java | 4 +++ .../schema/tool/SchemaSynthesisProcessor.java | 7 +++-- .../org/apache/phoenix/schema/tool/SchemaTool.java | 4 +++ .../phoenix/schema/types/PArrayDataType.java | 4 +++ .../schema/types/PArrayDataTypeEncoder.java| 2 +- .../org/apache/phoenix/schema/types/PDataType.java | 8 +- .../org/apache/phoenix/schema/types/PDecimal.java | 5 ++-- .../apache/phoenix/schema/types/PhoenixArray.java | 2 +- .../org/apache/phoenix/trace/TracingUtils.java | 8 -- .../org/apache/phoenix/trace/util/NullSpan.java| 2 +- .../java/org/apache/phoenix/util/ColumnInfo.java | 5 ++-- .../java/org/apache/phoenix/util/IndexUtil.java| 3 ++- .../java/org/apache/phoenix/util/MetaDataUtil.java | 5 ++-- .../
[phoenix] branch 5.1 updated: PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority
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 cdf35a9 PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority cdf35a9 is described below commit cdf35a921a93b3f2fe7b5e4c1e29d58f3dce7056 Author: Istvan Toth AuthorDate: Tue Sep 21 15:16:54 2021 +0200 PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority --- .../phoenix/cache/aggcache/SpillManager.java | 2 +- .../apache/phoenix/compile/ExpressionCompiler.java | 3 ++- .../org/apache/phoenix/compile/JoinCompiler.java | 1 - .../phoenix/compile/OrderPreservingTracker.java| 3 ++- .../phoenix/compile/ServerBuildIndexCompiler.java | 2 +- .../apache/phoenix/compile/SubselectRewriter.java | 3 ++- .../phoenix/compile/TupleProjectionCompiler.java | 2 +- .../phoenix/coprocessor/MetaDataEndpointImpl.java | 7 +++-- .../coprocessor/PhoenixAccessController.java | 2 +- .../org/apache/phoenix/execute/BaseQueryPlan.java | 4 ++- .../org/apache/phoenix/execute/HashJoinPlan.java | 4 ++- .../apache/phoenix/expression/LikeExpression.java | 10 +++- .../expression/ProjectedColumnExpression.java | 2 +- .../aggregator/BaseDecimalStddevAggregator.java| 3 +-- .../aggregator/FirstLastValueServerAggregator.java | 5 ++-- .../expression/function/ArrayFillFunction.java | 2 +- .../phoenix/expression/util/regex/JONIPattern.java | 2 +- .../TrackingParallelWriterIndexCommitter.java | 2 +- .../apache/phoenix/index/PhoenixIndexCodec.java| 2 +- .../iterate/NonAggregateRegionScannerFactory.java | 2 +- .../org/apache/phoenix/jdbc/PhoenixConnection.java | 7 ++--- .../phoenix/jdbc/PhoenixPreparedStatement.java | 5 .../phoenix/mapreduce/CsvBulkImportUtil.java | 8 +++--- .../phoenix/mapreduce/MultiHfileOutputFormat.java | 7 - .../apache/phoenix/mapreduce/OrphanViewTool.java | 16 +--- .../phoenix/mapreduce/PhoenixInputFormat.java | 2 +- .../PhoenixServerBuildIndexInputFormat.java| 10 .../bulkload/TargetTableRefFunctions.java | 10 .../mapreduce/index/IndexScrutinyMapper.java | 2 +- .../mapreduce/index/IndexScrutinyTableOutput.java | 2 +- .../phoenix/mapreduce/index/IndexScrutinyTool.java | 1 - .../apache/phoenix/mapreduce/index/IndexTool.java | 2 +- .../phoenix/mapreduce/index/IndexUpgradeTool.java | 4 ++- .../index/IndexVerificationOutputRepository.java | 2 +- .../index/IndexVerificationResultRepository.java | 12 - .../index/PhoenixIndexImportDirectMapper.java | 6 +++-- .../index/PhoenixIndexImportDirectReducer.java | 2 +- .../index/PhoenixIndexPartialBuildMapper.java | 6 +++-- .../index/PhoenixServerBuildIndexMapper.java | 7 +++-- .../index/automation/PhoenixMRJobSubmitter.java| 1 - .../util/DefaultMultiViewSplitStrategy.java| 2 +- .../mapreduce/util/PhoenixConfigurationUtil.java | 4 +-- .../phoenix/monitoring/CombinableMetric.java | 6 ++--- .../phoenix/monitoring/CombinableMetricImpl.java | 2 +- .../java/org/apache/phoenix/optimize/Cost.java | 4 +-- .../apache/phoenix/parse/ChangePermsStatement.java | 3 ++- .../java/org/apache/phoenix/parse/PFunction.java | 6 +++-- .../phoenix/query/ConnectionQueryServicesImpl.java | 9 --- .../query/ConnectionlessQueryServicesImpl.java | 4 --- .../phoenix/query/ITGuidePostsCacheFactory.java| 2 +- .../org/apache/phoenix/query/QueryConstants.java | 5 ++-- .../apache/phoenix/query/QueryServicesOptions.java | 2 +- .../org/apache/phoenix/schema/MetaDataClient.java | 20 --- .../org/apache/phoenix/schema/PMetaDataImpl.java | 2 +- .../java/org/apache/phoenix/schema/PTableImpl.java | 2 +- .../apache/phoenix/schema/SequenceAllocation.java | 4 +++ .../phoenix/schema/stats/GuidePostsInfo.java | 5 .../phoenix/schema/stats/UpdateStatisticsTool.java | 5 +++- .../java/org/apache/phoenix/schema/task/Task.java | 4 +++ .../schema/tool/SchemaSynthesisProcessor.java | 7 +++-- .../org/apache/phoenix/schema/tool/SchemaTool.java | 4 +++ .../phoenix/schema/types/PArrayDataType.java | 4 +++ .../schema/types/PArrayDataTypeEncoder.java| 2 +- .../org/apache/phoenix/schema/types/PDataType.java | 8 +- .../org/apache/phoenix/schema/types/PDecimal.java | 5 ++-- .../apache/phoenix/schema/types/PhoenixArray.java | 2 +- .../org/apache/phoenix/trace/TracingUtils.java | 8 -- .../org/apache/phoenix/trace/util/NullSpan.java| 2 +- .../java/org/apache/phoenix/util/ColumnInfo.java | 5 ++-- .../java/org/apache/phoenix/util/IndexUtil.java| 3 ++- .../java/org/apache/phoenix/util/MetaDataUtil.java | 5 ++-- .../org/apache/phoenix/util/PhoenixMRJobUtil.java | 3 ++- .../org/apache/p
[phoenix] branch master updated: PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority
This is an automated email from the ASF dual-hosted git repository. stoty pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/phoenix.git The following commit(s) were added to refs/heads/master by this push: new dd3d853 PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority dd3d853 is described below commit dd3d85366a0be46a1b3221600835a74bf27b343c Author: Istvan Toth AuthorDate: Tue Sep 21 15:16:54 2021 +0200 PHOENIX-6557 Fix code problems flagged by SpotBugs as High priority --- .../phoenix/cache/aggcache/SpillManager.java | 2 +- .../apache/phoenix/compile/ExpressionCompiler.java | 3 ++- .../org/apache/phoenix/compile/JoinCompiler.java | 1 - .../phoenix/compile/OrderPreservingTracker.java| 3 ++- .../phoenix/compile/ServerBuildIndexCompiler.java | 2 +- .../apache/phoenix/compile/SubselectRewriter.java | 3 ++- .../phoenix/compile/TupleProjectionCompiler.java | 2 +- .../phoenix/coprocessor/MetaDataEndpointImpl.java | 22 +++- .../coprocessor/PhoenixAccessController.java | 2 +- .../org/apache/phoenix/execute/BaseQueryPlan.java | 4 ++- .../org/apache/phoenix/execute/HashJoinPlan.java | 4 ++- .../apache/phoenix/expression/LikeExpression.java | 10 +++- .../expression/ProjectedColumnExpression.java | 2 +- .../aggregator/BaseDecimalStddevAggregator.java| 3 +-- .../aggregator/FirstLastValueServerAggregator.java | 5 ++-- .../expression/function/ArrayFillFunction.java | 2 +- .../phoenix/expression/util/regex/JONIPattern.java | 2 +- .../TrackingParallelWriterIndexCommitter.java | 2 +- .../apache/phoenix/index/PhoenixIndexCodec.java| 2 +- .../iterate/NonAggregateRegionScannerFactory.java | 2 +- .../org/apache/phoenix/jdbc/PhoenixConnection.java | 7 ++--- .../phoenix/jdbc/PhoenixPreparedStatement.java | 5 .../phoenix/mapreduce/CsvBulkImportUtil.java | 8 +++--- .../phoenix/mapreduce/MultiHfileOutputFormat.java | 7 - .../apache/phoenix/mapreduce/OrphanViewTool.java | 16 +--- .../phoenix/mapreduce/PhoenixInputFormat.java | 2 +- .../PhoenixServerBuildIndexInputFormat.java| 10 .../bulkload/TargetTableRefFunctions.java | 10 .../mapreduce/index/IndexScrutinyMapper.java | 2 +- .../mapreduce/index/IndexScrutinyTableOutput.java | 2 +- .../phoenix/mapreduce/index/IndexScrutinyTool.java | 1 - .../apache/phoenix/mapreduce/index/IndexTool.java | 2 +- .../phoenix/mapreduce/index/IndexUpgradeTool.java | 4 ++- .../index/IndexVerificationOutputRepository.java | 2 +- .../index/IndexVerificationResultRepository.java | 12 - .../index/PhoenixIndexImportDirectMapper.java | 6 +++-- .../index/PhoenixIndexImportDirectReducer.java | 2 +- .../index/PhoenixIndexPartialBuildMapper.java | 6 +++-- .../index/PhoenixServerBuildIndexMapper.java | 7 +++-- .../index/automation/PhoenixMRJobSubmitter.java| 1 - .../util/DefaultMultiViewSplitStrategy.java| 2 +- .../mapreduce/util/PhoenixConfigurationUtil.java | 4 +-- .../phoenix/monitoring/CombinableMetric.java | 6 ++--- .../phoenix/monitoring/CombinableMetricImpl.java | 2 +- .../phoenix/monitoring/TableMetricsManager.java| 4 +++ .../java/org/apache/phoenix/optimize/Cost.java | 4 +-- .../apache/phoenix/parse/ChangePermsStatement.java | 3 ++- .../java/org/apache/phoenix/parse/PFunction.java | 6 +++-- .../phoenix/query/ConnectionQueryServicesImpl.java | 12 + .../query/ConnectionlessQueryServicesImpl.java | 4 --- .../phoenix/query/ITGuidePostsCacheFactory.java| 2 +- .../org/apache/phoenix/query/QueryConstants.java | 5 ++-- .../apache/phoenix/query/QueryServicesOptions.java | 2 +- .../org/apache/phoenix/schema/MetaDataClient.java | 20 --- .../org/apache/phoenix/schema/PMetaDataImpl.java | 2 +- .../java/org/apache/phoenix/schema/PTableImpl.java | 2 +- .../apache/phoenix/schema/SequenceAllocation.java | 4 +++ .../phoenix/schema/stats/GuidePostsInfo.java | 5 .../phoenix/schema/stats/UpdateStatisticsTool.java | 5 +++- .../java/org/apache/phoenix/schema/task/Task.java | 4 +++ .../schema/tool/SchemaSynthesisProcessor.java | 7 +++-- .../org/apache/phoenix/schema/tool/SchemaTool.java | 4 +++ .../phoenix/schema/types/PArrayDataType.java | 4 +++ .../schema/types/PArrayDataTypeEncoder.java| 2 +- .../org/apache/phoenix/schema/types/PDataType.java | 8 +- .../org/apache/phoenix/schema/types/PDecimal.java | 5 ++-- .../apache/phoenix/schema/types/PhoenixArray.java | 2 +- .../org/apache/phoenix/trace/TracingUtils.java | 8 -- .../org/apache/phoenix/trace/util/NullSpan.java| 2 +- .../java/org/apache/phoenix/util/ColumnInfo.java | 5 ++-- .../java/org/apache/phoenix/util/IndexUtil.java| 3 ++- .../java/org/apache/phoenix/util/MetaDataUtil.java | 5 ++-