[TRAFODION-2205] invalid character error at create schema when authorization is long user

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: sql-cmu
• Environment: Centos6.7 ; R2.2 0825daily
• Assignee: Roberta Marton
• Reporter: Gao, Rui-Xian
• Created: 02/Sep/16 02:08
• Updated: 15/Sep/18 07:31
• Resolved: 12/Apr/18 22:56

Description

invalid character error at create schema when authorization is long user.

The error can only be reproduced from trafci, there is no problem in sqlci.

SQL>create schema myschema4 authorization qauser_1012345678201234567830123456784012345678501234567860123456787012345678801234567890123456781001234567110123456712012345128;

• • • ERROR[2109] Invalid Character error converting SQL statement from character set UTF8 to character set UCS2 (character position 137, byte offset 137). [2016-09-01 08:09:10]
    • ERROR[1323] Unable to grant privileges while creating SB_HISTOGRAMS. [2016-09-01 08:09:10]
    • ERROR[1029] Object TRAFODION.MYSCHEMA4.SB_HISTOGRAMS could not be created. [2016-09-01 08:09:10]
    • ERROR[1058] Unable to create histogram table SB_HISTOGRAMS. [2016-09-01 08:09:10]

Issue Links

• links to: GitHub Pull Request #1516