[jira] [Resolved] (PHOENIX-2540) Same column twice in CREATE TABLE leads unusable state of the table

["YoungWoo Kim (JIRA)" <ji...@apache.org>]

     [ 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)