Roberta Marton commented on TRAFODION-2205:

There is code that converts the user ID to its username.  The buffer sent into 
the conversion routine was not big enough.  In addition, the buffer size check 
was returning an error but did not add an error to the ComDiags area.  
Therefore the returned error was ignored.

Changed max len in call to getAuthNameFromAuthID to the correct size.

Set up the Diags area when buffer size is too small.

> invalid character error at create schema when authorization is long user
> ------------------------------------------------------------------------
>                 Key: TRAFODION-2205
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-2205
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-cmu
>         Environment: Centos6.7
> R2.2 0825daily
>            Reporter: Gao, Rui-Xian
>            Assignee: Roberta Marton
>            Priority: Major
> 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]

This message was sent by Atlassian JIRA

Reply via email to