[jira] [Comment Edited] (PHOENIX-3298) Create Table: Single column primary key may not be null

["James Taylor (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/PHOENIX-3298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15505747#comment-15505747 ] 

James Taylor edited comment on PHOENIX-3298 at 9/20/16 6:46 AM:
----------------------------------------------------------------

Phoenix assumes that a single column PK is not nullable because it doesn't allow a nullable single column PK. Since we're parsing the create table statement, seems like we can handle this ourselves. We could deprecate this behavior potentially too and change the tests.


was (Author: jamestaylor):
Phoenix assumes that a single column PK is not nullable because it doesn't allow a non nullable single column PK. Since we're parsing the create table statement, seems like we can handle this ourselves. We could deprecate this behavior potentially too and change the tests.

> Create Table: Single column primary key may not be null
> -------------------------------------------------------
>
>                 Key: PHOENIX-3298
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3298
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Eric Lomore
>
> Create table statements with a single column currently must have "NOT NULL" identifier to pass tests.
> Running this code results in failure
> {code}CREATE TABLE t (k VARCHAR PRIMARY KEY DESC){code}
> While this allows tests to pass
> {code}CREATE TABLE t (k VARCHAR NOT NULL PRIMARY KEY DESC){code}
> Must either enforce the not null condition and update test cases, or apply a fix.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)