You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@phoenix.apache.org by ma...@apache.org on 2017/03/15 00:01:27 UTC
[2/3] phoenix git commit: Add initial version of 'Test Failure Analysis'

http://git-wip-us.apache.org/repos/asf/phoenix/blob/5e47b460/calcite_failed_tests.csv
----------------------------------------------------------------------
diff --git a/calcite_failed_tests.csv b/calcite_failed_tests.csv
new file mode 100644
index 0000000..ea934bd
--- /dev/null
+++ b/calcite_failed_tests.csv
@@ -0,0 +1,72762 @@
+classname,testcase,error_message,type,info
+org.apache.phoenix.calcite.CalciteDDLIT,testUploadAndDeleteJars,"Error while executing SQL ""select jar_location
+from table(""ListJars""())"": Node [rel#18:Subset#0.ENUMERABLE.[]] could not be implemented; planner state:
+
+Root: rel#18:Subset#0.ENUMERABLE.[]
+Original rel:
+
+Sets:
+Set#0, type: RecordType(VARCHAR JAR_LOCATION)
+ rel#17:Subset#0.NONE.[], best=null, importance=0.9
+  rel#0:LogicalTableFunctionScan.NONE.[](invocation=ListJars(),rowType=RecordType(VARCHAR JAR_LOCATION),elementType=class [Ljava.lang.Object;), rowcount=1.0, cumulative cost={inf}
+ rel#18:Subset#0.ENUMERABLE.[], best=null, importance=1.0
+  rel#19:AbstractConverter.ENUMERABLE.[](input=rel#17:Subset#0.NONE.[],convention=ENUMERABLE,sort=[]), rowcount=1.0, cumulative cost={inf}
+
+",java.sql.SQLException,"java.sql.SQLException: 
+Error while executing SQL ""select jar_location
+from table(""ListJars""())"": Node [rel#18:Subset#0.ENUMERABLE.[]] could not be implemented; planner state:
+
+Root: rel#18:Subset#0.ENUMERABLE.[]
+Original rel:
+
+Sets:
+Set#0, type: RecordType(VARCHAR JAR_LOCATION)
+	rel#17:Subset#0.NONE.[], best=null, importance=0.9
+		rel#0:LogicalTableFunctionScan.NONE.[](invocation=ListJars(),rowType=RecordType(VARCHAR JAR_LOCATION),elementType=class [Ljava.lang.Object;), rowcount=1.0, cumulative cost={inf}
+	rel#18:Subset#0.ENUMERABLE.[], best=null, importance=1.0
+		rel#19:AbstractConverter.ENUMERABLE.[](input=rel#17:Subset#0.NONE.[],convention=ENUMERABLE,sort=[]), rowcount=1.0, cumulative cost={inf}
+
+
+	at org.apache.phoenix.calcite.CalciteDDLIT.testUploadAndDeleteJars(CalciteDDLIT.java:81)
+Caused by: org.apache.calcite.plan.RelOptPlanner$CannotPlanException: 
+Node [rel#18:Subset#0.ENUMERABLE.[]] could not be implemented; planner state:
+
+Root: rel#18:Subset#0.ENUMERABLE.[]
+Original rel:
+
+Sets:
+Set#0, type: RecordType(VARCHAR JAR_LOCATION)
+	rel#17:Subset#0.NONE.[], best=null, importance=0.9
+		rel#0:LogicalTableFunctionScan.NONE.[](invocation=ListJars(),rowType=RecordType(VARCHAR JAR_LOCATION),elementType=class [Ljava.lang.Object;), rowcount=1.0, cumulative cost={inf}
+	rel#18:Subset#0.ENUMERABLE.[], best=null, importance=1.0
+		rel#19:AbstractConverter.ENUMERABLE.[](input=rel#17:Subset#0.NONE.[],convention=ENUMERABLE,sort=[]), rowcount=1.0, cumulative cost={inf}
+
+
+	at org.apache.phoenix.calcite.CalciteDDLIT.testUploadAndDeleteJars(CalciteDDLIT.java:81)
+"
+org.apache.phoenix.calcite.CalciteDMLIT,testDateTimeTimestampAsBindVariables,expected:<12:30:28> but was:<20:30:28>,java.lang.AssertionError,"java.lang.AssertionError: expected:<12:30:28> but was:<20:30:28>
+	at org.apache.phoenix.calcite.CalciteDMLIT.testDateTimeTimestampAsBindVariables(CalciteDMLIT.java:145)
+"
+org.apache.phoenix.calcite.CalciteGlobalIndexIT,testMultiTenant,"expected:<...eConverter
+  Phoenix[ServerProject(TENANT_ID=[$0], ID=[$2], COL0=[$3], COL1=[CAST($1):INTEGER], COL2=[$4])
+    PhoenixTableScan(table=[[phoenix, IDX_MULTITENANT_TEST_TABLE]], filter=[AND(=($0, CAST('10'):VARCHAR CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"" NOT NULL), <=($2], '0004'))])
+> but was:<...eConverter
+  Phoenix[TableScan(table=[[phoenix, MULTITENANT_TEST_TABLE]], filter=[AND(=(CAST($0):VARCHAR(2) CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"" NOT NULL, '10'), <=($1], '0004'))])
+>",org.junit.ComparisonFailure,"org.junit.ComparisonFailure: 
+expected:<...eConverter
+  Phoenix[ServerProject(TENANT_ID=[$0], ID=[$2], COL0=[$3], COL1=[CAST($1):INTEGER], COL2=[$4])
+    PhoenixTableScan(table=[[phoenix, IDX_MULTITENANT_TEST_TABLE]], filter=[AND(=($0, CAST('10'):VARCHAR CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"" NOT NULL), <=($2], '0004'))])
+> but was:<...eConverter
+  Phoenix[TableScan(table=[[phoenix, MULTITENANT_TEST_TABLE]], filter=[AND(=(CAST($0):VARCHAR(2) CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"" NOT NULL, '10'), <=($1], '0004'))])
+>
+	at org.apache.phoenix.calcite.CalciteGlobalIndexIT.testMultiTenant(CalciteGlobalIndexIT.java:145)
+"
+org.apache.phoenix.calcite.CalciteIT,testCorrelateAndDecorrelation,"expected:<...[{2}], EXPR$0=[MAX($[4)], isOrdered=[false])
+        PhoenixTableScan(table=[[phoenix, Join, OrderTable]], filter=[IS NOT NULL($2)]])
+> but was:<...[{2}], EXPR$0=[MAX($[1)], isOrdered=[false])
+        PhoenixServerJoin(condition=[=($2, $0)], joinType=[inner])
+          PhoenixServerProject(item_id=[$2], QUANTITY=[$4])
+            PhoenixTableScan(table=[[phoenix, Join, OrderTable]])
+          PhoenixServerAggregate(group=[{2}], isOrdered=[false])
+            PhoenixTableScan(table=[[phoenix, Join, OrderTable]]])
+>",org.junit.ComparisonFailure,"org.junit.ComparisonFailure: 
+expected:<...[{2}], EXPR$0=[MAX($[4)], isOrdered=[false])
+        PhoenixTableScan(table=[[phoenix, Join, OrderTable]], filter=[IS NOT NULL($2)]])
+> but was:<...[{2}], EXPR$0=[MAX($[1)], isOrdered=[false])
+        PhoenixServerJoin(condition=[=($2, $0)], joinType=[inner])
+          PhoenixServerProject(item_id=[$2], QUANTITY=[$4])
+            PhoenixTableScan(table=[[phoenix, Join, OrderTable]])
+          PhoenixServerAggregate(group=[{2}], isOrdered=[false])
+            PhoenixTableScan(table=[[phoenix, Join, OrderTable]]])
+>
+	at org.apache.phoenix.calcite.CalciteIT.testCorrelateAndDecorrelation(CalciteIT.java:1175)
+"
+org.apache.phoenix.calcite.CalciteIT,testJoin,"expected:<...eConverter
+  Phoenix[ServerJoin(condition=[=($5, $7)], joinType=[inner])
+    PhoenixTableScan(table=[[phoenix, Join, ItemTable]])
+    PhoenixTableScan(table=[[phoenix, Join, SupplierTable]], filter=[=($1, CAST('S5'):VARCHAR CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"" NOT NULL])])
+> but was:<...eConverter
+  Phoenix[ClientProject(item_id=[$0], NAME=[$1], PRICE=[$2], DISCOUNT1=[$3], DISCOUNT2=[$4], supplier_id=[$5], DESCRIPTION=[$6], supplier_id0=[$7], NAME0=[$8], PHONE=[$9], ADDRESS=[$10], LOC_ID=[$11])
+    PhoenixServerJoin(condition=[=($5, $7)], joinType=[inner])
+      PhoenixTableScan(table=[[phoenix, Join, ItemTable]])
+      PhoenixServerProject(supplier_id=[$0], NAME=[$1], PHONE=[$2], ADDRESS=[$3], LOC_ID=[$4], NAME0=[CAST($1):VARCHAR(2) CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary""])
+        PhoenixTableScan(table=[[phoenix, Join, SupplierTable]], filter=[=(CAST($1):VARCHAR(2) CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"", 'S5'])])
+>",org.junit.ComparisonFailure,"org.junit.ComparisonFailure: 
+expected:<...eConverter
+  Phoenix[ServerJoin(condition=[=($5, $7)], joinType=[inner])
+    PhoenixTableScan(table=[[phoenix, Join, ItemTable]])
+    PhoenixTableScan(table=[[phoenix, Join, SupplierTable]], filter=[=($1, CAST('S5'):VARCHAR CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"" NOT NULL])])
+> but was:<...eConverter
+  Phoenix[ClientProject(item_id=[$0], NAME=[$1], PRICE=[$2], DISCOUNT1=[$3], DISCOUNT2=[$4], supplier_id=[$5], DESCRIPTION=[$6], supplier_id0=[$7], NAME0=[$8], PHONE=[$9], ADDRESS=[$10], LOC_ID=[$11])
+    PhoenixServerJoin(condition=[=($5, $7)], joinType=[inner])
+      PhoenixTableScan(table=[[phoenix, Join, ItemTable]])
+      PhoenixServerProject(supplier_id=[$0], NAME=[$1], PHONE=[$2], ADDRESS=[$3], LOC_ID=[$4], NAME0=[CAST($1):VARCHAR(2) CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary""])
+        PhoenixTableScan(table=[[phoenix, Join, SupplierTable]], filter=[=(CAST($1):VARCHAR(2) CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"", 'S5'])])
+>
+	at org.apache.phoenix.calcite.CalciteIT.testJoin(CalciteIT.java:142)
+"
+org.apache.phoenix.calcite.CalciteLocalIndexIT,testMultiTenant,"expected:<...LE]], filter=[AND(=([$0, CAST('10'):VARCHAR CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"" NOT NULL]), <=($1, '0004'))])...> but was:<...LE]], filter=[AND(=([CAST($0):VARCHAR(2) CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"" NOT NULL, '10']), <=($1, '0004'))])...>",org.junit.ComparisonFailure,"org.junit.ComparisonFailure: expected:<...LE]], filter=[AND(=([$0, CAST('10'):VARCHAR CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"" NOT NULL]), <=($1, '0004'))])...> but was:<...LE]], filter=[AND(=([CAST($0):VARCHAR(2) CHARACTER SET ""ISO-8859-1"" COLLATE ""ISO-8859-1$en_US$primary"" NOT NULL, '10']), <=($1, '0004'))])...>
+	at org.apache.phoenix.calcite.CalciteLocalIndexIT.testMultiTenant(CalciteLocalIndexIT.java:156)
+"
+org.apache.phoenix.coprocessor.StatisticsCollectionRunTrackerIT,testUpdateStatsPreventsAnotherUpdateStatsFromRunning,Row count didn't match expected:<-100> but was:<-1>,java.lang.AssertionError,"java.lang.AssertionError: Row count didn't match expected:<-100> but was:<-1>
+	at org.apache.phoenix.coprocessor.StatisticsCollectionRunTrackerIT.testUpdateStatsPreventsAnotherUpdateStatsFromRunning(StatisticsCollectionRunTrackerIT.java:118)
+"
+org.apache.phoenix.coprocessor.StatisticsCollectionRunTrackerIT,testMajorCompactionPreventsUpdateStatsFromRunning,Row count didn't match expected:<-200> but was:<-1>,java.lang.AssertionError,"java.lang.AssertionError: Row count didn't match expected:<-200> but was:<-1>
+	at org.apache.phoenix.coprocessor.StatisticsCollectionRunTrackerIT.testMajorCompactionPreventsUpdateStatsFromRunning(StatisticsCollectionRunTrackerIT.java:106)
+"
+org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT,testAddPKColumnToBaseTableWhoseViewsHaveIndices,does not implement 'class org.apache.phoenix.jdbc.PhoenixStatement',java.sql.SQLException,"java.sql.SQLException: does not implement 'class org.apache.phoenix.jdbc.PhoenixStatement'
+	at org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT.testAddPKColumnToBaseTableWhoseViewsHaveIndices(AlterMultiTenantTableWithViewsIT.java:402)
+"
+org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT,testDropColumnsFromSaltedBaseTableWithViews,expected:<504> but was:<0>,java.lang.AssertionError,"java.lang.AssertionError: expected:<504> but was:<0>
+	at org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT.testDropColumnsFromSaltedBaseTableWithViews(AlterMultiTenantTableWithViewsIT.java:548)
+"
+org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT,testAddingPkAndKeyValueColumnsToBaseTableWithDivergedView,does not implement 'class org.apache.phoenix.jdbc.PhoenixStatement',java.sql.SQLException,"java.sql.SQLException: does not implement 'class org.apache.phoenix.jdbc.PhoenixStatement'
+	at org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT.testAddingPkAndKeyValueColumnsToBaseTableWithDivergedView(AlterMultiTenantTableWithViewsIT.java:468)
+"
+org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT,testCacheInvalidatedAfterDroppingColumnFromBaseTableWithViews,"Error while executing SQL ""SELECT V1 FROM testCacheInvalidatedAfterDroppingColumnFromBaseTableWithViews_view"": From line 1, column 8 to line 1, column 9: Column 'V1' not found in any table",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""SELECT V1 FROM testCacheInvalidatedAfterDroppingColumnFromBaseTableWithViews_view"": From line 1, column 8 to line 1, column 9: Column 'V1' not found in any table
+	at org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT.testCacheInvalidatedAfterDroppingColumnFromBaseTableWithViews(AlterMultiTenantTableWithViewsIT.java:645)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to line 1, column 9: Column 'V1' not found in any table
+	at org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT.testCacheInvalidatedAfterDroppingColumnFromBaseTableWithViews(AlterMultiTenantTableWithViewsIT.java:645)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Column 'V1' not found in any table
+	at org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT.testCacheInvalidatedAfterDroppingColumnFromBaseTableWithViews(AlterMultiTenantTableWithViewsIT.java:645)
+"
+org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT,testAddDropColumnToBaseTablePropagatesToEntireViewHierarchy,,java.lang.AssertionError,"java.lang.AssertionError
+	at org.apache.phoenix.end2end.AlterMultiTenantTableWithViewsIT.testAddDropColumnToBaseTablePropagatesToEntireViewHierarchy(AlterMultiTenantTableWithViewsIT.java:142)
+"
+org.apache.phoenix.end2end.AlterSessionIT,testUpdateConsistency,unknown DDL type SET_OPTION class org.apache.calcite.sql.SqlSetOption,java.lang.AssertionError,"java.lang.AssertionError: unknown DDL type SET_OPTION class org.apache.calcite.sql.SqlSetOption
+	at org.apache.phoenix.end2end.AlterSessionIT.testUpdateConsistency(AlterSessionIT.java:62)
+"
+org.apache.phoenix.end2end.AlterSessionIT,testSetConsistencyInURL,org.apache.calcite.jdbc.PhoenixCalciteFactory$PhoenixCalciteConnection cannot be cast to org.apache.phoenix.jdbc.PhoenixConnection,java.lang.ClassCastException,"java.lang.ClassCastException: org.apache.calcite.jdbc.PhoenixCalciteFactory$PhoenixCalciteConnection cannot be cast to org.apache.phoenix.jdbc.PhoenixConnection
+	at org.apache.phoenix.end2end.AlterSessionIT.testSetConsistencyInURL(AlterSessionIT.java:81)
+"
+org.apache.phoenix.end2end.AlterTableIT,testDropMultipleColumns,"Error while executing SQL ""SELECT COLUMN_COUNT FROM ""SYSTEM"".""CATALOG""
+WHERE TENANT_ID IS NULL AND
+(TABLE_SCHEM, TABLE_NAME) = ('','T000017') AND
+COLUMN_FAMILY IS NULL AND COLUMN_NAME IS NULL"": Unsupported RexNode: ROW",java.sql.SQLException,"java.sql.SQLException: 
+Error while executing SQL ""SELECT COLUMN_COUNT FROM ""SYSTEM"".""CATALOG""
+WHERE TENANT_ID IS NULL AND
+(TABLE_SCHEM, TABLE_NAME) = ('','T000017') AND
+COLUMN_FAMILY IS NULL AND COLUMN_NAME IS NULL"": Unsupported RexNode: ROW
+	at org.apache.phoenix.end2end.AlterTableIT.testDropMultipleColumns(AlterTableIT.java:1054)
+Caused by: java.lang.UnsupportedOperationException: Unsupported RexNode: ROW
+	at org.apache.phoenix.end2end.AlterTableIT.testDropMultipleColumns(AlterTableIT.java:1054)
+"
+org.apache.phoenix.end2end.AlterTableIT,testDropIndexedColumn,expected:<1> but was:<null>,java.lang.AssertionError,"java.lang.AssertionError: expected:<1> but was:<null>
+	at org.apache.phoenix.end2end.AlterTableIT.testDropIndexedColumn(AlterTableIT.java:277)
+"
+org.apache.phoenix.end2end.AlterTableIT,testDeclaringColumnAsRowTimestamp,"Error while preparing statement [SELECT IS_ROW_TIMESTAMP FROM ""SYSTEM"".""CATALOG"" WHERE (TABLE_SCHEM, TABLE_NAME) = ('','T000053') AND
+COLUMN_FAMILY IS NULL AND COLUMN_NAME = ?]",java.sql.SQLException,"java.sql.SQLException: 
+Error while preparing statement [SELECT IS_ROW_TIMESTAMP FROM ""SYSTEM"".""CATALOG"" WHERE (TABLE_SCHEM, TABLE_NAME) = ('','T000053') AND
+COLUMN_FAMILY IS NULL AND COLUMN_NAME = ?]
+	at org.apache.phoenix.end2end.AlterTableIT.assertIsRowTimestampSet(AlterTableIT.java:2169)
+	at org.apache.phoenix.end2end.AlterTableIT.testDeclaringColumnAsRowTimestamp(AlterTableIT.java:2127)
+Caused by: java.lang.UnsupportedOperationException: Unsupported RexNode: ROW
+	at org.apache.phoenix.end2end.AlterTableIT.assertIsRowTimestampSet(AlterTableIT.java:2169)
+	at org.apache.phoenix.end2end.AlterTableIT.testDeclaringColumnAsRowTimestamp(AlterTableIT.java:2127)
+"
+org.apache.phoenix.end2end.AlterTableIT,testAddPKColumnToTableWithIndex,"Error while executing SQL ""SELECT * FROM T000056"": From line 1, column 29 to line 1, column 32: Column 'K2' not found in any table",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""SELECT * FROM T000056"": From line 1, column 29 to line 1, column 32: Column 'K2' not found in any table
+	at org.apache.phoenix.end2end.AlterTableIT.testAddPKColumnToTableWithIndex(AlterTableIT.java:471)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 29 to line 1, column 32: Column 'K2' not found in any table
+	at org.apache.phoenix.end2end.AlterTableIT.testAddPKColumnToTableWithIndex(AlterTableIT.java:471)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Column 'K2' not found in any table
+	at org.apache.phoenix.end2end.AlterTableIT.testAddPKColumnToTableWithIndex(AlterTableIT.java:471)
+"
+org.apache.phoenix.end2end.AlterTableIT,testDropCoveredColumn,"field count: lhs [RecordType(VARCHAR 0:V1, VARCHAR :K, VARCHAR 0:V3)] rhs [RecordType(VARCHAR 0:V1, VARCHAR :K, VARCHAR 0:V2, VARCHAR 0:V3)]",java.lang.AssertionError,"java.lang.AssertionError: field count: lhs [RecordType(VARCHAR 0:V1, VARCHAR :K, VARCHAR 0:V3)] rhs [RecordType(VARCHAR 0:V1, VARCHAR :K, VARCHAR 0:V2, VARCHAR 0:V3)]
+	at org.apache.phoenix.end2end.AlterTableIT.testDropCoveredColumn(AlterTableIT.java:346)
+"
+org.apache.phoenix.end2end.AlterTableIT,testAddMultipleColumns,"Error while executing SQL ""SELECT COLUMN_COUNT FROM ""SYSTEM"".""CATALOG""
+WHERE TENANT_ID IS NULL AND
+(TABLE_SCHEM, TABLE_NAME) = ('','T000110') AND
+COLUMN_FAMILY IS NULL AND COLUMN_NAME IS NULL"": Unsupported RexNode: ROW",java.sql.SQLException,"java.sql.SQLException: 
+Error while executing SQL ""SELECT COLUMN_COUNT FROM ""SYSTEM"".""CATALOG""
+WHERE TENANT_ID IS NULL AND
+(TABLE_SCHEM, TABLE_NAME) = ('','T000110') AND
+COLUMN_FAMILY IS NULL AND COLUMN_NAME IS NULL"": Unsupported RexNode: ROW
+	at org.apache.phoenix.end2end.AlterTableIT.testAddMultipleColumns(AlterTableIT.java:999)
+Caused by: java.lang.UnsupportedOperationException: Unsupported RexNode: ROW
+	at org.apache.phoenix.end2end.AlterTableIT.testAddMultipleColumns(AlterTableIT.java:999)
+"
+org.apache.phoenix.end2end.AlterTableIT,testAddVarCharColToPK,"Error while executing SQL ""SELECT * FROM T000122 WHERE a_string = 'a' AND b_string IS NULL"": From line 1, column 48 to line 1, column 55: Column 'B_STRING' not found in any table",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""SELECT * FROM T000122 WHERE a_string = 'a' AND b_string IS NULL"": From line 1, column 48 to line 1, column 55: Column 'B_STRING' not found in any table
+	at org.apache.phoenix.end2end.AlterTableIT.testAddVarCharColToPK(AlterTableIT.java:168)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 48 to line 1, column 55: Column 'B_STRING' not found in any table
+	at org.apache.phoenix.end2end.AlterTableIT.testAddVarCharColToPK(AlterTableIT.java:168)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Column 'B_STRING' not found in any table
+	at org.apache.phoenix.end2end.AlterTableIT.testAddVarCharColToPK(AlterTableIT.java:168)
+"
+org.apache.phoenix.end2end.AlterTableIT,alterTableFromDifferentClient,"Error while preparing statement [upsert into T000134 (id, field1, field2) values ( ?, ?, ?)]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [upsert into T000134 (id, field1, field2) values ( ?, ?, ?)]
+	at org.apache.phoenix.end2end.AlterTableIT.alterTableFromDifferentClient(AlterTableIT.java:945)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 34 to line 1, column 39: Unknown target column 'FIELD2'
+	at org.apache.phoenix.end2end.AlterTableIT.alterTableFromDifferentClient(AlterTableIT.java:945)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Unknown target column 'FIELD2'
+	at org.apache.phoenix.end2end.AlterTableIT.alterTableFromDifferentClient(AlterTableIT.java:945)
+"
+org.apache.phoenix.end2end.AlterTableIT,testDropColumnsWithImutability,2,java.sql.SQLException,"java.sql.SQLException: 2
+	at org.apache.phoenix.end2end.AlterTableIT.testDropColumnsWithImutability(AlterTableIT.java:867)
+Caused by: java.lang.ArrayIndexOutOfBoundsException: 2
+	at org.apache.phoenix.end2end.AlterTableIT.testDropColumnsWithImutability(AlterTableIT.java:867)
+"
+org.apache.phoenix.end2end.AlterTableIT,testAddVarCols,"Error while executing SQL ""SELECT col5 FROM T000140"": From line 1, column 8 to line 1, column 11: Column 'COL5' not found in any table",java.lang.AssertionError,"java.lang.AssertionError: Error while executing SQL ""SELECT col5 FROM T000140"": From line 1, column 8 to line 1, column 11: Column 'COL5' not found in any table
+	at org.apache.phoenix.end2end.AlterTableIT.testAddVarCols(AlterTableIT.java:616)
+"
+org.apache.phoenix.end2end.AlterTableIT,testDisallowAddingNotNullableColumnNotPartOfPkForExistingTable,,java.sql.SQLException,"java.sql.SQLException
+	at org.apache.phoenix.end2end.AlterTableIT.testDisallowAddingNotNullableColumnNotPartOfPkForExistingTable(AlterTableIT.java:707)
+Caused by: java.lang.NullPointerException
+	at org.apache.phoenix.end2end.AlterTableIT.testDisallowAddingNotNullableColumnNotPartOfPkForExistingTable(AlterTableIT.java:707)
+"
+org.apache.phoenix.end2end.AlterTableIT,testDropSystemTable,expected:<1010> but was:<0>,java.lang.AssertionError,"java.lang.AssertionError: expected:<1010> but was:<0>
+	at org.apache.phoenix.end2end.AlterTableIT.testDropSystemTable(AlterTableIT.java:129)
+"
+org.apache.phoenix.end2end.AlterTableWithViewsIT,testAddExistingViewPkColumnToBaseTableWithViews[AlterTableWithViewsIT_multiTenant=false],"Error while preparing statement [UPSERT INTO T000002_VIEW VALUES(?,?,?,?,?)]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000002_VIEW VALUES(?,?,?,?,?)]
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewPkColumnToBaseTableWithViews(AlterTableWithViewsIT.java:314)
+Caused by: java.lang.IndexOutOfBoundsException: end index (5) must not be greater than size (3)
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewPkColumnToBaseTableWithViews(AlterTableWithViewsIT.java:314)
+"
+org.apache.phoenix.end2end.AlterTableWithViewsIT,testAddExistingViewPkColumnToBaseTableWithMultipleViewsHavingSamePks[AlterTableWithViewsIT_multiTenant=false],"Error while preparing statement [UPSERT INTO T000006_VIEW1 VALUES(?,?,?,?,?)]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000006_VIEW1 VALUES(?,?,?,?,?)]
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewPkColumnToBaseTableWithMultipleViewsHavingSamePks(AlterTableWithViewsIT.java:492)
+Caused by: java.lang.IndexOutOfBoundsException: end index (5) must not be greater than size (3)
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewPkColumnToBaseTableWithMultipleViewsHavingSamePks(AlterTableWithViewsIT.java:492)
+"
+org.apache.phoenix.end2end.AlterTableWithViewsIT,testAddExistingViewColumnToBaseTableWithViews[AlterTableWithViewsIT_multiTenant=false],"Error while preparing statement [UPSERT INTO T000008_VIEW VALUES(?,?,?,?,?, ?, ?, ?, ?)]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000008_VIEW VALUES(?,?,?,?,?, ?, ?, ?, ?)]
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewColumnToBaseTableWithViews(AlterTableWithViewsIT.java:207)
+Caused by: java.lang.IndexOutOfBoundsException: end index (9) must not be greater than size (3)
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewColumnToBaseTableWithViews(AlterTableWithViewsIT.java:207)
+"
+org.apache.phoenix.end2end.AlterTableWithViewsIT,testAlteringViewThatHasChildViews[AlterTableWithViewsIT_multiTenant=false],"Error while executing SQL ""SELECT V5 FROM childView"": From line 1, column 8 to line 1, column 9: Column 'V5' not found in any table",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""SELECT V5 FROM childView"": From line 1, column 8 to line 1, column 9: Column 'V5' not found in any table
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAlteringViewThatHasChildViews(AlterTableWithViewsIT.java:640)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to line 1, column 9: Column 'V5' not found in any table
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAlteringViewThatHasChildViews(AlterTableWithViewsIT.java:640)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Column 'V5' not found in any table
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAlteringViewThatHasChildViews(AlterTableWithViewsIT.java:640)
+"
+org.apache.phoenix.end2end.AlterTableWithViewsIT,testAddExistingViewPkColumnToBaseTableWithViews[AlterTableWithViewsIT_multiTenant=true],"Error while preparing statement [UPSERT INTO T000013_VIEW VALUES(?,?,?,?,?)]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000013_VIEW VALUES(?,?,?,?,?)]
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewPkColumnToBaseTableWithViews(AlterTableWithViewsIT.java:314)
+Caused by: java.lang.IndexOutOfBoundsException: end index (5) must not be greater than size (3)
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewPkColumnToBaseTableWithViews(AlterTableWithViewsIT.java:314)
+"
+org.apache.phoenix.end2end.AlterTableWithViewsIT,testAddExistingViewPkColumnToBaseTableWithMultipleViewsHavingSamePks[AlterTableWithViewsIT_multiTenant=true],"Error while preparing statement [UPSERT INTO T000017_VIEW1 VALUES(?,?,?,?,?)]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000017_VIEW1 VALUES(?,?,?,?,?)]
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewPkColumnToBaseTableWithMultipleViewsHavingSamePks(AlterTableWithViewsIT.java:492)
+Caused by: java.lang.IndexOutOfBoundsException: end index (5) must not be greater than size (3)
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewPkColumnToBaseTableWithMultipleViewsHavingSamePks(AlterTableWithViewsIT.java:492)
+"
+org.apache.phoenix.end2end.AlterTableWithViewsIT,testAddExistingViewColumnToBaseTableWithViews[AlterTableWithViewsIT_multiTenant=true],"Error while preparing statement [UPSERT INTO T000019_VIEW VALUES(?,?,?,?,?, ?, ?, ?, ?)]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000019_VIEW VALUES(?,?,?,?,?, ?, ?, ?, ?)]
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewColumnToBaseTableWithViews(AlterTableWithViewsIT.java:207)
+Caused by: java.lang.IndexOutOfBoundsException: end index (9) must not be greater than size (3)
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAddExistingViewColumnToBaseTableWithViews(AlterTableWithViewsIT.java:207)
+"
+org.apache.phoenix.end2end.AlterTableWithViewsIT,testAlteringViewThatHasChildViews[AlterTableWithViewsIT_multiTenant=true],"Error while executing SQL ""SELECT V5 FROM childView"": From line 1, column 8 to line 1, column 9: Column 'V5' not found in any table",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""SELECT V5 FROM childView"": From line 1, column 8 to line 1, column 9: Column 'V5' not found in any table
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAlteringViewThatHasChildViews(AlterTableWithViewsIT.java:640)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 8 to line 1, column 9: Column 'V5' not found in any table
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAlteringViewThatHasChildViews(AlterTableWithViewsIT.java:640)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Column 'V5' not found in any table
+	at org.apache.phoenix.end2end.AlterTableWithViewsIT.testAlteringViewThatHasChildViews(AlterTableWithViewsIT.java:640)
+"
+org.apache.phoenix.end2end.AppendOnlySchemaIT,testTableAddColumnsDifferentClient,"Error while executing SQL ""UPSERT INTO T000008(hostName, metricVal1) VALUES('host1', 1.0)"": From line 1, column 21 to line 1, column 28: Unknown target column 'HOSTNAME'",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""UPSERT INTO T000008(hostName, metricVal1) VALUES('host1', 1.0)"": From line 1, column 21 to line 1, column 28: Unknown target column 'HOSTNAME'
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testAddColumns(AppendOnlySchemaIT.java:207)
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testTableAddColumnsDifferentClient(AppendOnlySchemaIT.java:285)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 21 to line 1, column 28: Unknown target column 'HOSTNAME'
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testAddColumns(AppendOnlySchemaIT.java:207)
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testTableAddColumnsDifferentClient(AppendOnlySchemaIT.java:285)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Unknown target column 'HOSTNAME'
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testAddColumns(AppendOnlySchemaIT.java:207)
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testTableAddColumnsDifferentClient(AppendOnlySchemaIT.java:285)
+"
+org.apache.phoenix.end2end.AppendOnlySchemaIT,testAddColumnsSameClient,"Error while executing SQL ""UPSERT INTO T000019(hostName, metricVal1) VALUES('host1', 1.0)"": From line 1, column 21 to line 1, column 28: Unknown target column 'HOSTNAME'",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""UPSERT INTO T000019(hostName, metricVal1) VALUES('host1', 1.0)"": From line 1, column 21 to line 1, column 28: Unknown target column 'HOSTNAME'
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testAddColumns(AppendOnlySchemaIT.java:207)
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testAddColumnsSameClient(AppendOnlySchemaIT.java:280)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 21 to line 1, column 28: Unknown target column 'HOSTNAME'
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testAddColumns(AppendOnlySchemaIT.java:207)
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testAddColumnsSameClient(AppendOnlySchemaIT.java:280)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Unknown target column 'HOSTNAME'
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testAddColumns(AppendOnlySchemaIT.java:207)
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testAddColumnsSameClient(AppendOnlySchemaIT.java:280)
+"
+org.apache.phoenix.end2end.AppendOnlySchemaIT,testUpsertRowToDeletedTable,"Error while executing SQL ""UPSERT INTO T000022(hostName, metricVal) VALUES('host1', 1.0)"": From line 1, column 21 to line 1, column 28: Unknown target column 'HOSTNAME'",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""UPSERT INTO T000022(hostName, metricVal) VALUES('host1', 1.0)"": From line 1, column 21 to line 1, column 28: Unknown target column 'HOSTNAME'
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testUpsertRowToDeletedTable(AppendOnlySchemaIT.java:346)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 21 to line 1, column 28: Unknown target column 'HOSTNAME'
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testUpsertRowToDeletedTable(AppendOnlySchemaIT.java:346)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Unknown target column 'HOSTNAME'
+	at org.apache.phoenix.end2end.AppendOnlySchemaIT.testUpsertRowToDeletedTable(AppendOnlySchemaIT.java:346)
+"
+org.apache.phoenix.end2end.ArithmeticQueryIT,testRandomFunction,"Error while executing SQL ""select rand(), rand(), rand(1), rand(2), rand(1) from T000001"": Unsupported SqlFunction: RAND",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""select rand(), rand(), rand(1), rand(2), rand(1) from T000001"": Unsupported SqlFunction: RAND
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testRandomFunction(ArithmeticQueryIT.java:328)
+Caused by: java.lang.UnsupportedOperationException: Unsupported SqlFunction: RAND
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testRandomFunction(ArithmeticQueryIT.java:328)
+"
+org.apache.phoenix.end2end.ArithmeticQueryIT,testDecimalArithmeticWithIntAndLong,Should have caught error.,java.lang.AssertionError,"java.lang.AssertionError: Should have caught error.
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testDecimalArithmeticWithIntAndLong(ArithmeticQueryIT.java:576)
+"
+org.apache.phoenix.end2end.ArithmeticQueryIT,testOrderOfOperationsMultiplicationModulus,"Error while executing SQL ""SELECT six * four % three FROM T000010"": parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""SELECT six * four % three FROM T000010"": parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsMultiplicationModulus(ArithmeticQueryIT.java:938)
+Caused by: java.lang.RuntimeException: parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsMultiplicationModulus(ArithmeticQueryIT.java:938)
+Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsMultiplicationModulus(ArithmeticQueryIT.java:938)
+Caused by: org.apache.phoenix.calcite.parser.TokenMgrError: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsMultiplicationModulus(ArithmeticQueryIT.java:938)
+"
+org.apache.phoenix.end2end.ArithmeticQueryIT,testOrderOfOperationsDivisionModulus,"Error while executing SQL ""SELECT six / four % three FROM T000015"": parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""SELECT six / four % three FROM T000015"": parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsDivisionModulus(ArithmeticQueryIT.java:961)
+Caused by: java.lang.RuntimeException: parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsDivisionModulus(ArithmeticQueryIT.java:961)
+Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsDivisionModulus(ArithmeticQueryIT.java:961)
+Caused by: org.apache.phoenix.calcite.parser.TokenMgrError: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsDivisionModulus(ArithmeticQueryIT.java:961)
+"
+org.apache.phoenix.end2end.ArithmeticQueryIT,testOrderOfOperationsSubtractionModulus,"Error while executing SQL ""SELECT six - four % three FROM T000020"": parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""SELECT six - four % three FROM T000020"": parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsSubtractionModulus(ArithmeticQueryIT.java:892)
+Caused by: java.lang.RuntimeException: parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsSubtractionModulus(ArithmeticQueryIT.java:892)
+Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsSubtractionModulus(ArithmeticQueryIT.java:892)
+Caused by: org.apache.phoenix.calcite.parser.TokenMgrError: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsSubtractionModulus(ArithmeticQueryIT.java:892)
+"
+org.apache.phoenix.end2end.ArithmeticQueryIT,testDecimalUpsertValue,expected:<206> but was:<0>,java.lang.AssertionError,"java.lang.AssertionError: expected:<206> but was:<0>
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testDecimalUpsertValue(ArithmeticQueryIT.java:114)
+"
+org.apache.phoenix.end2end.ArithmeticQueryIT,testDecimalUpsertSelect,expected:<206> but was:<0>,java.lang.AssertionError,"java.lang.AssertionError: expected:<206> but was:<0>
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testDecimalUpsertSelect(ArithmeticQueryIT.java:197)
+"
+org.apache.phoenix.end2end.ArithmeticQueryIT,testOrderOfOperationsAdditionModulus,"Error while executing SQL ""SELECT six + four % three FROM T000027"": parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"",java.sql.SQLException,"java.sql.SQLException: Error while executing SQL ""SELECT six + four % three FROM T000027"": parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsAdditionModulus(ArithmeticQueryIT.java:823)
+Caused by: java.lang.RuntimeException: parse failed: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsAdditionModulus(ArithmeticQueryIT.java:823)
+Caused by: org.apache.calcite.sql.parser.SqlParseException: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsAdditionModulus(ArithmeticQueryIT.java:823)
+Caused by: org.apache.phoenix.calcite.parser.TokenMgrError: Lexical error at line 1, column 19.  Encountered: ""%"" (37), after : """"
+	at org.apache.phoenix.end2end.ArithmeticQueryIT.testOrderOfOperationsAdditionModulus(ArithmeticQueryIT.java:823)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionDouble2,"Error while preparing statement [UPSERT INTO T000001(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000001(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionDouble2(ArrayAppendFunctionIT.java:125)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionDouble2(ArrayAppendFunctionIT.java:125)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionDouble2(ArrayAppendFunctionIT.java:125)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionInWhere1,"Error while preparing statement [UPSERT INTO T000002(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000002(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere1(ArrayAppendFunctionIT.java:423)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere1(ArrayAppendFunctionIT.java:423)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere1(ArrayAppendFunctionIT.java:423)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionInWhere2,"Error while preparing statement [UPSERT INTO T000003(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000003(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere2(ArrayAppendFunctionIT.java:436)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere2(ArrayAppendFunctionIT.java:436)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere2(ArrayAppendFunctionIT.java:436)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionInWhere3,"Error while preparing statement [UPSERT INTO T000004(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000004(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere3(ArrayAppendFunctionIT.java:449)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere3(ArrayAppendFunctionIT.java:449)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere3(ArrayAppendFunctionIT.java:449)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionInWhere4,"Error while preparing statement [UPSERT INTO T000005(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000005(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere4(ArrayAppendFunctionIT.java:462)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere4(ArrayAppendFunctionIT.java:462)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere4(ArrayAppendFunctionIT.java:462)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionInWhere5,"Error while preparing statement [UPSERT INTO T000006(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000006(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere5(ArrayAppendFunctionIT.java:475)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere5(ArrayAppendFunctionIT.java:475)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere5(ArrayAppendFunctionIT.java:475)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionInWhere6,"Error while preparing statement [UPSERT INTO T000007(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000007(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere6(ArrayAppendFunctionIT.java:488)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere6(ArrayAppendFunctionIT.java:488)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere6(ArrayAppendFunctionIT.java:488)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionInWhere7,"Error while preparing statement [UPSERT INTO T000008(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000008(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere7(ArrayAppendFunctionIT.java:501)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere7(ArrayAppendFunctionIT.java:501)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInWhere7(ArrayAppendFunctionIT.java:501)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionInteger,"Error while preparing statement [UPSERT INTO T000009(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000009(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInteger(ArrayAppendFunctionIT.java:91)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInteger(ArrayAppendFunctionIT.java:91)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionInteger(ArrayAppendFunctionIT.java:91)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionVarcharDesc,"Error while preparing statement [UPSERT INTO T000010(pk,varchars,integers,doubles,bigints,chars,chars2,bools) VALUES('e',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],ARRAY['a','bbbb','c','ddd','e','foo'],ARRAY[true,false])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000010(pk,varchars,integers,doubles,bigints,chars,chars2,bools) VALUES('e',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],ARRAY['a','bbbb','c','ddd','e','foo'],ARRAY[true,false])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarcharDesc(ArrayAppendFunctionIT.java:617)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 24 to line 1, column 31: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarcharDesc(ArrayAppendFunctionIT.java:617)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarcharDesc(ArrayAppendFunctionIT.java:617)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionBooleanDesc,"Error while preparing statement [UPSERT INTO T000012(pk,varchars,integers,doubles,bigints,chars,chars2,bools) VALUES(false,ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],ARRAY['a','bbbb','c','ddd','e','foo'],ARRAY[true,false])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000012(pk,varchars,integers,doubles,bigints,chars,chars2,bools) VALUES(false,ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],ARRAY['a','bbbb','c','ddd','e','foo'],ARRAY[true,false])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionBooleanDesc(ArrayAppendFunctionIT.java:650)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 24 to line 1, column 31: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionBooleanDesc(ArrayAppendFunctionIT.java:650)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionBooleanDesc(ArrayAppendFunctionIT.java:650)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionWithNestedFunctions1,"Error while preparing statement [UPSERT INTO T000013(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000013(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNestedFunctions1(ArrayAppendFunctionIT.java:220)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNestedFunctions1(ArrayAppendFunctionIT.java:220)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNestedFunctions1(ArrayAppendFunctionIT.java:220)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionWithNestedFunctions2,"Error while preparing statement [UPSERT INTO T000014(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000014(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNestedFunctions2(ArrayAppendFunctionIT.java:237)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNestedFunctions2(ArrayAppendFunctionIT.java:237)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNestedFunctions2(ArrayAppendFunctionIT.java:237)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionWithNestedFunctions3,"Error while preparing statement [UPSERT INTO T000015(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000015(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNestedFunctions3(ArrayAppendFunctionIT.java:254)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNestedFunctions3(ArrayAppendFunctionIT.java:254)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNestedFunctions3(ArrayAppendFunctionIT.java:254)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionWithUpsertSelect1,ERROR 201 (22000): Illegal data. Unsupported sql type: 5998,java.sql.SQLException,"java.sql.SQLException: ERROR 201 (22000): Illegal data. Unsupported sql type: 5998
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithUpsertSelect1(ArrayAppendFunctionIT.java:353)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionWithUpsertSelect2,ERROR 201 (22000): Illegal data. Unsupported sql type: 5998,java.sql.SQLException,"java.sql.SQLException: ERROR 201 (22000): Illegal data. Unsupported sql type: 5998
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithUpsertSelect2(ArrayAppendFunctionIT.java:393)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionDoublesWithNull,"Error while preparing statement [UPSERT INTO T000020(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000020(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionDoublesWithNull(ArrayAppendFunctionIT.java:531)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionDoublesWithNull(ArrayAppendFunctionIT.java:531)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionDoublesWithNull(ArrayAppendFunctionIT.java:531)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionIntToCharArray,"Unexpected exception, expected<org.apache.phoenix.schema.TypeMismatchException> but was<java.sql.SQLException>",java.lang.Exception,"java.lang.Exception: Unexpected exception, expected<org.apache.phoenix.schema.TypeMismatchException> but was<java.sql.SQLException>
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionIntToCharArray(ArrayAppendFunctionIT.java:174)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionIntToCharArray(ArrayAppendFunctionIT.java:174)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionIntToCharArray(ArrayAppendFunctionIT.java:174)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionIntegerToDoubleArray,"Error while preparing statement [UPSERT INTO T000022(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000022(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionIntegerToDoubleArray(ArrayAppendFunctionIT.java:203)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionIntegerToDoubleArray(ArrayAppendFunctionIT.java:203)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionIntegerToDoubleArray(ArrayAppendFunctionIT.java:203)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionBigint,"Error while preparing statement [UPSERT INTO T000023(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000023(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionBigint(ArrayAppendFunctionIT.java:142)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionBigint(ArrayAppendFunctionIT.java:142)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionBigint(ArrayAppendFunctionIT.java:142)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionDouble,"Error while preparing statement [UPSERT INTO T000024(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000024(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionDouble(ArrayAppendFunctionIT.java:108)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionDouble(ArrayAppendFunctionIT.java:108)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionDouble(ArrayAppendFunctionIT.java:108)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionVarchar,"Error while preparing statement [UPSERT INTO T000025(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000025(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarchar(ArrayAppendFunctionIT.java:74)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarchar(ArrayAppendFunctionIT.java:74)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarchar(ArrayAppendFunctionIT.java:74)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionChar,"Error while preparing statement [UPSERT INTO T000026(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000026(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionChar(ArrayAppendFunctionIT.java:158)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionChar(ArrayAppendFunctionIT.java:158)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionChar(ArrayAppendFunctionIT.java:158)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionVarcharToIntegerArray,"Unexpected exception, expected<org.apache.phoenix.schema.TypeMismatchException> but was<java.sql.SQLException>",java.lang.Exception,"java.lang.Exception: Unexpected exception, expected<org.apache.phoenix.schema.TypeMismatchException> but was<java.sql.SQLException>
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarcharToIntegerArray(ArrayAppendFunctionIT.java:183)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarcharToIntegerArray(ArrayAppendFunctionIT.java:183)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarcharToIntegerArray(ArrayAppendFunctionIT.java:183)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionWithUpsert1,ERROR 201 (22000): Illegal data. Unsupported sql type: 5998,java.sql.SQLException,"java.sql.SQLException: ERROR 201 (22000): Illegal data. Unsupported sql type: 5998
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithUpsert1(ArrayAppendFunctionIT.java:276)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionWithUpsert2,ERROR 201 (22000): Illegal data. Unsupported sql type: 5998,java.sql.SQLException,"java.sql.SQLException: ERROR 201 (22000): Illegal data. Unsupported sql type: 5998
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithUpsert2(ArrayAppendFunctionIT.java:300)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionWithUpsert3,ERROR 201 (22000): Illegal data. Unsupported sql type: 5998,java.sql.SQLException,"java.sql.SQLException: ERROR 201 (22000): Illegal data. Unsupported sql type: 5998
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithUpsert3(ArrayAppendFunctionIT.java:324)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionBigIntDesc,"Error while preparing statement [UPSERT INTO T000031(pk,varchars,integers,doubles,bigints,chars,chars2,bools) VALUES(1112,ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],ARRAY['a','bbbb','c','ddd','e','foo'],ARRAY[true,false])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000031(pk,varchars,integers,doubles,bigints,chars,chars2,bools) VALUES(1112,ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],ARRAY['a','bbbb','c','ddd','e','foo'],ARRAY[true,false])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionBigIntDesc(ArrayAppendFunctionIT.java:634)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 24 to line 1, column 31: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionBigIntDesc(ArrayAppendFunctionIT.java:634)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionBigIntDesc(ArrayAppendFunctionIT.java:634)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionIntegerDesc,"Error while preparing statement [UPSERT INTO T000032(pk,varchars,integers,doubles,bigints,chars,chars2,bools) VALUES(23,ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],ARRAY['a','bbbb','c','ddd','e','foo'],ARRAY[true,false])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000032(pk,varchars,integers,doubles,bigints,chars,chars2,bools) VALUES(23,ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],ARRAY['a','bbbb','c','ddd','e','foo'],ARRAY[true,false])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionIntegerDesc(ArrayAppendFunctionIT.java:599)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 24 to line 1, column 31: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionIntegerDesc(ArrayAppendFunctionIT.java:599)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTablesDesc(ArrayAppendFunctionIT.java:64)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionIntegerDesc(ArrayAppendFunctionIT.java:599)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionVarcharWithNull,"Error while preparing statement [UPSERT INTO T000034(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000034(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarcharWithNull(ArrayAppendFunctionIT.java:514)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarcharWithNull(ArrayAppendFunctionIT.java:514)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionVarcharWithNull(ArrayAppendFunctionIT.java:514)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionWithNull,"Error while preparing statement [UPSERT INTO T000035(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000035(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNull(ArrayAppendFunctionIT.java:565)
+Caused by: org.apache.calcite.runtime.CalciteContextException: From line 1, column 33 to line 1, column 40: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNull(ArrayAppendFunctionIT.java:565)
+Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Cannot assign to target field 'VARCHARS' of type VARCHAR ARRAY from source field 'EXPR$1' of type CHAR(5) ARRAY
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.initTables(ArrayAppendFunctionIT.java:45)
+	at org.apache.phoenix.end2end.ArrayAppendFunctionIT.testArrayAppendFunctionWithNull(ArrayAppendFunctionIT.java:565)
+"
+org.apache.phoenix.end2end.ArrayAppendFunctionIT,testArrayAppendFunctionCharsWithNull,"Error while preparing statement [UPSERT INTO T000036(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,chars2) VALUES('SF Bay Area',ARRAY['2345','46345','23234'],ARRAY[2345,46345,23234,456],ARRAY[23.45,46.345,23.234,45.6,5.78],ARRAY[12,34,56,78,910],ARRAY['a','bbbb','c','ddd','e'],23.45,'wert',NULL,ARRAY['a','bbbb','c','ddd','e','foo'])]",java.sql.SQLException,"java.sql.SQLException: Error while preparing statement [UPSERT INTO T000036(region_name,varchars,integers,doubles,bigints,chars,double1,char1,nullcheck,cha

<TRUNCATED>