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>
