Viraj Jasani created PHOENIX-7627: ------------------------------------- Summary: Atomic Delete return row fails for case-sensitive schema and table names Key: PHOENIX-7627 URL: https://issues.apache.org/jira/browse/PHOENIX-7627 Project: Phoenix Issue Type: Bug Reporter: Viraj Jasani
Single row atomic delete returning row fails to retrieve the deleted row and convert it to ResultSet if the table name consists of case-sensitive schema and table names. For table name: XYZ.abc123N000001, {code:java} java.sql.SQLException: org.apache.hadoop.hbase.TableNotFoundException: abc123N000001 at org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.deleteRowAndGetMutationState(DeleteCompiler.java:901) at org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.execute(DeleteCompiler.java:856) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:655) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:610) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:609) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:595) at org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeAtomicUpdateReturnRow(PhoenixPreparedStatement.java:234) at org.apache.phoenix.end2end.OnDuplicateKey2IT.validateReturnedRowAfterDelete(OnDuplicateKey2IT.java:459) at org.apache.phoenix.end2end.OnDuplicateKey2IT.testReturnRowResult4(OnDuplicateKey2IT.java:274) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) ... ...Caused by: org.apache.hadoop.hbase.TableNotFoundException: abc123N000001 at org.apache.hadoop.hbase.client.ConnectionImplementation.locateRegionInMeta(ConnectionImplementation.java:1027) at org.apache.hadoop.hbase.client.ConnectionImplementation.locateRegion(ConnectionImplementation.java:897) at org.apache.hadoop.hbase.client.RpcRetryingCallerWithReadReplicas.getRegionLocations(RpcRetryingCallerWithReadReplicas.java:320) at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:159) at org.apache.hadoop.hbase.client.ScannerCallableWithReplicas.call(ScannerCallableWithReplicas.java:53) at org.apache.hadoop.hbase.client.RpcRetryingCallerImpl.callWithoutRetries(RpcRetryingCallerImpl.java:191) at org.apache.hadoop.hbase.client.ClientScanner.call(ClientScanner.java:271) at org.apache.hadoop.hbase.client.ClientScanner.loadCache(ClientScanner.java:440) at org.apache.hadoop.hbase.client.ClientScanner.nextWithSyncCache(ClientScanner.java:314) at org.apache.hadoop.hbase.client.ClientScanner.next(ClientScanner.java:612) at org.apache.phoenix.compile.DeleteCompiler$ServerSelectDeleteMutationPlan.deleteRowAndGetMutationState(DeleteCompiler.java:892) ... 49 more {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)