[TRAFODION-2702] [ODBC] The SQL type is set to CHAR (n) CHARACTER SET USC2, SQLGetData to read data multiple times returns the wrong length value

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0, 2.3
• Fix Version/s: 2.2.0, 2.3
• Component/s: client-odbc-linux
• Environment: CentOS
• Assignee: Unassigned
• Reporter: haolin.song
• Created: 03/Aug/17 08:18
• Updated: 15/Sep/18 07:32
• Resolved: 12/Oct/17 12:26

Description

The SQL type is set to 'CHAR (N)' CHARACTER SET USC2, SQLGetData will read data multiple times when the length of buffer is less than the length of the data but returns wrong size of length.
"CREATE TABLE TB_DEBUG(C1 CHAR(20) CHARACTER SET UCS2)"
"INSERT INTO TB_DEBUG VALUES (_UCS2'0123456789abcdefghij')"
"select * from TB_DEBUG"
SQLFetch(hstmt);
while (retcode != SQL_NO_DATA_FOUND)
...
retcode = SQLGetData(hstmt,(SWORD)(1),SQL_C_CHAR,UCS2Output,11,&len);
...

the SQLGetData will return 5 times and the len is 20,31,21,11,1

Issue Links

• links to: GitHub Pull Request #1197
• links to: GitHub Pull Request #1214