Elaine_WangLing created TRAFODION-2124:
------------------------------------------
Summary: ERROR[8433] is returned while select from table
(statistics(NULL, 'ACTIVE_QUERIES=30')) with Queries having Chinese Characters
running.
Key: TRAFODION-2124
URL: https://issues.apache.org/jira/browse/TRAFODION-2124
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Affects Versions: 2.1-incubating
Environment: Release 2.1.0 & Release 2.2.0
Reporter: Elaine_WangLing
[Pre-condition]
1. create table used this DDL
create table qa_elaine.JDBC_T_CHAR18 ( BIZ_TYPE
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , CALL_TYPE CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED , ROAMTYPE
LARGEINT DEFAULT NULL NOT SERIALIZED , IMSI
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
DEFAULT NULL NOT SERIALIZED , MSISDN CHAR(30
CHARS) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT NOT NULL NOT
DROPPABLE NOT SERIALIZED , OTHER_PARTY CHAR(30 CHARS)
CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED ,
THIRD_PARTY CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE
DEFAULT DEFAULT NULL NOT SERIALIZED , START_TIME
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , END_TIME CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED , CALL_DURATION
LARGEINT DEFAULT NULL NOT SERIALIZED , MSC
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
DEFAULT NULL NOT SERIALIZED , TRUNK_GROUPOUT CHAR(30
CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , TRUNK_GROUPIN CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED , CALLING_LAC
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
DEFAULT NULL NOT SERIALIZED , CALLED_LAC CHAR(30
CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , CALLING_CELL CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED , CALLED_CELL
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
DEFAULT NULL NOT SERIALIZED , HOME_AREA_CODE CHAR(30
CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , VISIT_AREA_CODE CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED ,
CALLED_HOME_CODE CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE
DEFAULT DEFAULT NULL NOT SERIALIZED , CALLED_CODE
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , THIRD_HOME_CODE CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED , THIRD_CODE
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
DEFAULT NULL NOT SERIALIZED , FORWARDCAUSE CHAR(30
CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , VPN_FLAG CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED , LONG_TYPE
LARGEINT DEFAULT NULL NOT SERIALIZED , CARRY_TYPE
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
DEFAULT NULL NOT SERIALIZED , CARRIER_CD CHAR(30
CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , CFEE LARGEINT DEFAULT NULL NOT
SERIALIZED , ACCT_ITEM_TYPE_A LARGEINT DEFAULT NULL NOT
SERIALIZED , LFEE LARGEINT DEFAULT NULL NOT
SERIALIZED , ACCT_ITEM_TYPE_B LARGEINT DEFAULT NULL NOT
SERIALIZED , FEE_ADD LARGEINT DEFAULT NULL NOT
SERIALIZED , ACCT_ITEM_TYPE_C LARGEINT DEFAULT NULL NOT
SERIALIZED , SERVID CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED , BILLING_MODE
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
DEFAULT NULL NOT SERIALIZED , EVENT_TYPE LARGEINT
DEFAULT NULL NOT SERIALIZED , PRODUCT_ID CHAR(30
CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , ESN_CODE CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED , IMEI
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
DEFAULT NULL NOT SERIALIZED , PROV_OFFER_ID CHAR(30
CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , PROV_RATEDATE CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED ,
PROV_BILLING_CYCLE_ID LARGEINT DEFAULT NULL NOT SERIALIZED ,
CDR_KEY CHAR(60 CHARS) CHARACTER SET UTF8 COLLATE
DEFAULT DEFAULT NULL NOT SERIALIZED , RATE_TIMES
LARGEINT DEFAULT NULL NOT SERIALIZED , RESERVER1
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , RESERVER2 CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED , RESERVER3
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
DEFAULT NULL NOT SERIALIZED , RESERVER4 CHAR(30
CHARS) CHARACTER SET UTF8 COLLATE DEFAULT DEFAULT NULL NOT
SERIALIZED , RESERVER5 CHAR(30 CHARS) CHARACTER SET
UTF8 COLLATE DEFAULT DEFAULT NULL NOT SERIALIZED , PROV_ID
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT
NO DEFAULT NOT NULL NOT DROPPABLE NOT SERIALIZED , DAY_ID
CHAR(30 CHARS) CHARACTER SET UTF8 COLLATE DEFAULT NO DEFAULT
NOT NULL NOT DROPPABLE NOT SERIALIZED ) STORE BY (MSISDN ASC, PROV_ID
ASC) SALT USING 200 PARTITIONS ON (MSISDN) ATTRIBUTES ALIGNED
FORMAT HBASE_OPTIONS ( DATA_BLOCK_ENCODING = 'FAST_DIFF',
COMPRESSION = 'SNAPPY', MEMSTORE_FLUSH_SIZE = '1073741824' )
2. insert values into the table. Here come one example,
insert into qa_elaine.JDBC_T_CHAR18 values('共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', 1, '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', 1, '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', 1, '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华', 1, 1, 1,
1, 1, 1, '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华', 1, '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', 1, '共名共华中华中华人中中国人和国人和华', 1, '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华',
'共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华', '共名共华中华中华人中中国人和国人和华')
[Steps]
Run below query via any client, such as Windows Trafci
select current_timestamp "Time" -- (1) Now
,cast(tokenstr('lastActivity:',
variable_info) -- (2) Last Activity
as NUMERIC(18) ) "Last Activity
Seconds"
,cast(tokenstr('Qid:', variable_info)
-- (3) QID
as varchar(175) CHARACTER SET UTF8)
"Query ID"
, cast(tokenstr('State:', variable_info)
-- (4) State
as char(30)) "Execution State"
, cast(substr(variable_info,
-- (5) SQL Source
position(' sqlSrc: ' in
variable_info) + char_length(' sqlSrc: ')+1,
char_length(variable_info) -
( position(' sqlSrc: '
in variable_info) + char_length(' sqlSrc: ')+1 ))
as char(256) CHARACTER SET UTF8)
"Query Text"
, cast(tokenstr('sqlSrcLen:',
variable_info)
as NUMERIC(18) ) "Full Text Length"
from table (statistics(NULL,
'ACTIVE_QUERIES=30'))
order by 2 descending;
Check the results
[Actuall]ERROR[8433] is returned
SQL>select current_timestamp "Time" -- (1) Now
+> ,cast(tokenstr('lastActivity:',
variable_info) -- (2) Last Activity
+> as NUMERIC(18) ) "Last Activity
Seconds"
+> ,cast(tokenstr('Qid:', variable_info)
-- (3) QID
+> as varchar(175) CHARACTER SET UTF8)
"Query ID"
+> , cast(tokenstr('State:', variable_info)
-- (4) State
+> as char(30)) "Execution State"
+> , cast(substr(variable_info,
-- (5) SQL Source
+> position(' sqlSrc: ' in
variable_info) + char_length(' sqlSrc: ')+1,
+> char_length(variable_info) -
+> ( position(' sqlSrc: '
in variable_info) + char_length(' sqlSrc: ')+1 ))
+> as char(256) CHARACTER SET UTF8)
"Query Text"
+> , cast(tokenstr('sqlSrcLen:',
variable_info)
+> as NUMERIC(18) ) "Full Text Length"
+> from table (statistics(NULL,
'ACTIVE_QUERIES=30'))
+> order by 2 descending;
*** ERROR[8433] Invalid UTF8 character encountered in CHAR FUNCTION.
[2016-07-22 09:18:40]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
