[TRAFODION-2725] SQL types are REAL, FLOAT, and DOUBLE. Some values are inserted, a stack overflow occurs when SQLGetData is executed.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.2.0
• Component/s: client-odbc-windows
• Assignee: Unassigned
• Reporter: 苏锦佩
• Created: 25/Aug/17 07:47
• Updated: 15/Sep/18 07:30
• Resolved: 12/Oct/17 12:29

Description

The inserted value is -2.22507e-308, and the SQLGetData receive buffer is greater than 256，when the double column data is fetched, the program sends a crash.
example:
TCHAR tempbuf[256] =

{0}

;
SQLExecDirect(hstmt, (SQLTCHAR*)"CREATE TABLE TB_DOUBLE (ID INT, C DOUBLE PRECISION)", SQL_NTS);
SQLExecDirect(hstmt, (SQLTCHAR*)"INSERT INTO TB_DOUBLE VALUES (1,-2.22507e-308)", SQL_NTS);
SQLExecDirect(hstmt, (SQLTCHAR*)"SELECT * FROM TB_DOUBLE", SQL_NTS);
SQLNumResultCols(hstmt, &numOfCols);
SQLFetch(hstmt);
for(i = 1; i <= numOfCols; i++){
SQLGetData(hstmt,(SWORD)i,SQL_C_CHAR,tempbuf,sizeof(tempbuf),&len);
｝

Issue Links

• relates to: TRAFODION-2828 Multi-threaded batch loading causes the program to crash
• links to: GitHub Pull Request #1218
• links to: GitHub Pull Request #1220