You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "James Taylor (JIRA)" <ji...@apache.org> on 2014/06/06 19:40:01 UTC
[jira] [Created] (PHOENIX-1028) Prevent declaration of non PK
columns as NOT NULL
James Taylor created PHOENIX-1028:
-------------------------------------
Summary: 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
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)