[
https://issues.apache.org/jira/browse/TRAFODION-2119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15403103#comment-15403103
]
ASF GitHub Bot commented on TRAFODION-2119:
-------------------------------------------
GitHub user traflm opened a pull request:
https://github.com/apache/incubator-trafodion/pull/633
[TRAFODION-2119] DDL warning/error if using store by on utf8 column
If store by is used and the column is not set 'not null', there will be an
extra null indicator header. So the generated hbase split by string will
contain un-initialized character and sometime raise warning or error.
The calling to type->minRepresentableValue should pass the buf address that
take null indicator buffer into account, good examples are in:
-EncodedValue::minMaxValue()
-ConstValue::ConstValue()
but getMinMaxValue() is wrong.
Although the calling conversion is not clear, this will be a fix to the
issue, there are other some places to invoke minRepresentatbleValue, so keep
the current semantics is good from my point of view.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/traflm/incubator-trafodion TRAFODION-2119-1
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/633.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #633
----
commit 6ce98ff1cf7a306403845a8d52f3c5f2801c283d
Author: Liu Ming <[email protected]>
Date: 2016-08-02T00:29:45Z
[TRAFODION-2119] DDL warning/error if using store by on utf8 column
----
> create table report strange WARNING when using store by and
> allow_nullable_unique_key_constraint CQD
> ----------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-2119
> URL: https://issues.apache.org/jira/browse/TRAFODION-2119
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: liu ming
> Assignee: liu ming
>
> cqd allow_nullable_unique_key_constraint 'on' ;
> create table T_RH_DZSP
> (
> s_orgcode CHAR(12) character set utf8,
> s_applydate CHAR(8) character set utf8,
> s_packno varchar(8) character set utf8,
> s_trecode CHAR(10) character set utf8,
> s_trename varchar(60) character set utf8,
> s_taxorgcode varchar(12) character set utf8,
> s_paybnkno varchar(12) character set utf8,
> s_trano varchar(8) character set utf8,
> s_orimsgno CHAR(4) character set utf8,
> f_traamt numeric(18,2),
> s_payeropnbnkno varchar(12) character set utf8,
> payeropbkname varchar(60) character set utf8,
> s_handorgname varchar(200) character set utf8,
> s_payacct varchar(32) character set utf8,
> s_taxvouno varchar(20) character set utf8,
> s_billdate CHAR(8) character set utf8,
> s_taxpaycode varchar(20) character set utf8,
> s_taxpayname varchar(200) character set utf8,
> c_budgettype CHAR(1) character set utf8,
> c_trimflag CHAR(1) character set utf8,
> s_etpcode varchar(20) character set utf8,
> s_etpname varchar(200) character set utf8,
> s_etptype varchar(20) character set utf8,
> s_bdgsbtcode varchar(30) character set utf8,
> s_bdgsbtname varchar(60) character set utf8,
> s_limit CHAR(8) character set utf8,
> s_taxtypecode CHAR(10) character set utf8,
> s_taxkindname varchar(60) character set utf8,
> c_bdglevel CHAR(1) character set utf8,
> c_bdglevelname varchar(60) character set utf8,
> s_taxstartdate CHAR(8) character set utf8,
> s_taxenddate CHAR(8) character set utf8,
> s_astflag varchar(35) character set utf8,
> c_taxtype CHAR(1) character set utf8,
> s_acct CHAR(8) character set utf8,
> s_trastate CHAR(2) character set utf8,
> s_remark varchar(60) character set utf8,
> s_remark1 varchar(60) character set utf8,
> s_remark2 varchar(60) character set utf8,
> s_inputerid varchar(18) character set utf8,
> ts_sysupdate varchar(100) character set utf8,
> s_seq varchar(100) character set utf8
> )
> store by (S_APPLYDATE)
> salt using 48 partitions on (S_APPLYDATE)
> ATTRIBUTES ALIGNED FORMAT
> HBASE_OPTIONS
> (
> DATA_BLOCK_ENCODING = 'FAST_DIFF',
> -- COMPRESSION = 'SNAPPY',
> MEMSTORE_FLUSH_SIZE = '1073741824'
> );
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> *** WARNING[8402] A string overflow occurred during the evaluation of a
> character expression.
> --- SQL operation complete.
> >>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
