[jira] [Resolved] (PHOENIX-780) Disallow array type to be used in primary key constraint

["Gabriel Reid (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/PHOENIX-780?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gabriel Reid resolved PHOENIX-780.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> Disallow array type to be used in primary key constraint
> --------------------------------------------------------
>
>                 Key: PHOENIX-780
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-780
>             Project: Phoenix
>          Issue Type: Task
>    Affects Versions: 3.0-Release
>            Reporter: James Taylor
>
> We currently have no check that disallows an ARRAY type be used in the primary key constraint. For example, the following statements should both fail with a SQLException:
>    CREATE TABLE foo (col1 INTEGER ARRAY[10] NOT NULL PRIMARY KEY);
>    CREATE TABLE foo (col1 VARCHAR, col2 INTEGER ARRAY[10]
>        CONSTRAINT pk PRIMARY KEY (col1, col2));
> This check should be done in MetaDataClient.createTable, where we loop through the ColumnDef list and create the PK. Negative tests should be added in QueryCompileTest.



--
This message was sent by Atlassian JIRA
(v6.2#6252)