[
https://issues.apache.org/jira/browse/PHOENIX-1028?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14021719#comment-14021719
]
Hudson commented on PHOENIX-1028:
---------------------------------
SUCCESS: Integrated in Phoenix | Master | Hadoop1 #252 (See
[https://builds.apache.org/job/Phoenix-master-hadoop1/252/])
PHOENIX-1028 Prevent declaration of non PK columns as NOT NULL (jtaylor: rev
455c1fdb827cd8e6a8d4acd7e6e77ea800329190)
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ToNumberFunctionIT.java
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ToCharFunctionIT.java
PHOENIX-1028 Prevent declaration of non PK columns as NOT NULL (jtaylor: rev
6098d7bd07e1bfdf5f015b55d77e987c5a7cba04)
* phoenix-core/src/it/java/org/apache/phoenix/end2end/ExecuteStatementsIT.java
> Prevent declaration of non PK columns as NOT NULL
> -------------------------------------------------
>
> Key: PHOENIX-1028
> URL: https://issues.apache.org/jira/browse/PHOENIX-1028
> Project: Phoenix
> Issue Type: Bug
> Reporter: James Taylor
> Assignee: maghamravikiran
> Attachments: 0001-PHOENIX-1028.patch
>
>
> The following statement should issue an error, as we're not able to enforce
> not null constraints for non PK columns (i.e. ENTRY_POINT_NAME column):
> {code}
> CREATE TABLE IF NOT EXISTS EVENT.APEX_LIMIT (
> ORGANIZATION_ID CHAR(15) NOT NULL,
> EVENT_TIME DATE NOT NULL,
> USER_ID CHAR(15) NOT NULL,
> ENTRY_POINT_ID CHAR(15) NOT NULL,
> ENTRY_POINT_TYPE CHAR(2) NOT NULL,
> APEX_LIMIT_ID CHAR(15) NOT NULL,
> USERNAME CHAR(80),
> NAMESPACE_PREFIX VARCHAR,
> ENTRY_POINT_NAME VARCHAR NOT NULL,
> EXECUTION_UNIT_NO VARCHAR,
> LIMIT_TYPE VARCHAR,
> LIMIT_VALUE DOUBLE
> CONSTRAINT PK PRIMARY KEY
> (
> ORGANIZATION_ID,
> EVENT_TIME,
> USER_ID,
> ENTRY_POINT_ID,
> ENTRY_POINT_TYPE,
> APEX_LIMIT_ID
> )
> ) VERSIONS=1,MULTI_TENANT=true, SALT_BUCKETS=64
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)
