You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Elaine_WangLing (JIRA)" <ji...@apache.org> on 2016/07/22 01:28:20 UTC
[jira] [Created] (TRAFODION-2124) ERROR[8433] is returned while
select from table (statistics(NULL, 'ACTIVE_QUERIES=30')) with Queries
having Chinese Characters running.
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)