[
https://issues.apache.org/jira/browse/PHOENIX-2540?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
YoungWoo Kim resolved PHOENIX-2540.
-----------------------------------
Resolution: Cannot Reproduce
> Same column twice in CREATE TABLE leads unusable state of the table
> -------------------------------------------------------------------
>
> Key: PHOENIX-2540
> URL: https://issues.apache.org/jira/browse/PHOENIX-2540
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 4.6.0
> Environment: Phoenix 4.6 and current master branch / HBase 1.1.2
> Reporter: YoungWoo Kim
> Fix For: 4.7.0
>
>
> If users define same column twice in a table, the table would be unusable.
> when I try to drop the table, I got ArrayIndexOutOfBoundsException as
> following. To prevent this, CREATE TABLE should check duplicated columns.
> E.g.,
> CREATE TABLE tbl (a varchar not null primary key, b bigint, b bigint, c date);
> This DDL works without an error but It should be failed because column 'b' is
> defined twice.
> {noformat}
> 2015-12-18 12:11:52,171 ERROR
> [B.defaultRpcServer.handler=46,queue=4,port=16020]
> coprocessor.MetaDataEndpointImpl: dropTable failed
> java.lang.ArrayIndexOutOfBoundsException: 20
> at org.apache.phoenix.schema.PTableImpl.init(PTableImpl.java:380)
> at org.apache.phoenix.schema.PTableImpl.<init>(PTableImpl.java:301)
> at org.apache.phoenix.schema.PTableImpl.makePTable(PTableImpl.java:290)
> at
> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:844)
> at
> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:472)
> at
> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.doDropTable(MetaDataEndpointImpl.java:1450)
> at
> org.apache.phoenix.coprocessor.MetaDataEndpointImpl.dropTable(MetaDataEndpointImpl.java:1403)
> at
> org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:11629)
> at
> org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:7435)
> at
> org.apache.hadoop.hbase.regionserver.RSRpcServices.execServiceOnRegion(RSRpcServices.java:1875)
> at
> org.apache.hadoop.hbase.regionserver.RSRpcServices.execService(RSRpcServices.java:1857)
> at
> org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:32209)
> at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2114)
> at org.apache.hadoop.hbase.ipc.CallRunner.run(CallRunner.java:101)
> at
> org.apache.hadoop.hbase.ipc.RpcExecutor.consumerLoop(RpcExecutor.java:130)
> at org.apache.hadoop.hbase.ipc.RpcExecutor$1.run(RpcExecutor.java:107)
> at java.lang.Thread.run(Thread.java:745)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
