Comment 2 for bug 1442730

Verified the fix on cluster Amber7 with Traf 1.1.0RC1 build. SQLCancel worked as expected.

Below are the validation steps in ODBCTest:

 Full Connect(Default)

 Env. Attr. SQL_ATTR_ODBC_VERSION set to SQL_OV_ODBC3

 Successfully connected to DSN 'amber7'.
SQLSetStmtAttr:
    In: StatementHandle = 0x00000000003BB220, Attribute = SQL_ATTR_ASYNC_ENABLE=4, ValuePtr = SQL_ASYNC_ENABLE_ON=1, StringLength = SQL_NTS=-3,
          fAttribute Type = SQL_C_SLONG=-16
    Return: SQL_SUCCESS=0
SQLExecDirect:
    In: Statementhandle = 0x00000000003BB220, StatementText = "select count(*) from trafodion."_MD_".columns a, ...", Statementlength = 105
    Return: SQL_STILL_EXECUTING=2
SQLExecDirect:
    In: Statementhandle = 0x00000000003BB220, StatementText = "select count(*) from trafodion."_MD_".columns a, ...", Statementlength = 105
    Return: SQL_SUCCESS=0
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_STILL_EXECUTING=2
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_STILL_EXECUTING=2
SQLCancel:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_SUCCESS=0
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_ERROR=-1
    stmt: szSqlState = "HY008", *pfNativeError = -8007, *pcbErrorMsg = 131, *ColumnNumber = -1, *RowNumber = -2
          MessageText = "[TRAF][Trafodion ODBC Driver][Trafodion Database] SQL error:*** ERROR[8007] The operation has been canceled. [2015-04-20 20:48:23]"
    stmt: szSqlState = "S1008", *pfNativeError = 0, *pcbErrorMsg = 50, *ColumnNumber = -1, *RowNumber = -2
          MessageText = "[TRAF][Trafodion ODBC Driver] Operation cancelled."
SQLExecDirect:
    In: Statementhandle = 0x00000000003BB220, StatementText = "select count(*) from trafodion."_MD_".columns a, ...", Statementlength = 134
    Return: SQL_STILL_EXECUTING=2
SQLExecDirect:
    In: Statementhandle = 0x00000000003BB220, StatementText = "select count(*) from trafodion."_MD_".columns a, ...", Statementlength = 134
    Return: SQL_SUCCESS=0
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_STILL_EXECUTING=2
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_STILL_EXECUTING=2
SQLCancel:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_SUCCESS=0
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_ERROR=-1
    stmt: szSqlState = "HY008", *pfNativeError = -8007, *pcbErrorMsg = 131, *ColumnNumber = -1, *RowNumber = -2
          MessageText = "[TRAF][Trafodion ODBC Driver][Trafodion Database] SQL error:*** ERROR[8007] The operation has been canceled. [2015-04-20 20:50:08]"
    stmt: szSqlState = "S1008", *pfNativeError = 0, *pcbErrorMsg = 50, *ColumnNumber = -1, *RowNumber = -2
          MessageText = "[TRAF][Trafodion ODBC Driver] Operation cancelled."
SQLExecDirect:
    In: Statementhandle = 0x00000000003BB220, StatementText = "select count(*) from "_MD_".columns a, "_MD_".inde...", Statementlength = 232
    Return: SQL_STILL_EXECUTING=2
SQLExecDirect:
    In: Statementhandle = 0x00000000003BB220, StatementText = "select count(*) from "_MD_".columns a, "_MD_".inde...", Statementlength = 232
    Return: SQL_SUCCESS=0
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_STILL_EXECUTING=2
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_STILL_EXECUTING=2
SQLCancel:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_SUCCESS=0
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_ERROR=-1
    stmt: szSqlState = "HY008", *pfNativeError = -8007, *pcbErrorMsg = 131, *ColumnNumber = -1, *RowNumber = -2
          MessageText = "[TRAF][Trafodion ODBC Driver][Trafodion Database] SQL error:*** ERROR[8007] The operation has been canceled. [2015-04-20 20:52:03]"
    stmt: szSqlState = "S1008", *pfNativeError = 0, *pcbErrorMsg = 50, *ColumnNumber = -1, *RowNumber = -2
          MessageText = "[TRAF][Trafodion ODBC Driver] Operation cancelled."
SQLPrepare:
    In: StatementHandle = 0x00000000003BB220, StatementText = "select count(*) from "_MD_".columns a, "_MD_".inde...", TextLength = 232
    Return: SQL_STILL_EXECUTING=2
SQLPrepare:
    In: StatementHandle = 0x00000000003BB220, StatementText = "select count(*) from "_MD_".columns a, "_MD_".inde...", TextLength = 232
    Return: SQL_SUCCESS=0
SQLExecute:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_STILL_EXECUTING=2
SQLExecute:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_SUCCESS=0
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_STILL_EXECUTING=2
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_STILL_EXECUTING=2
SQLCancel:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_SUCCESS=0
SQLFetch:
    In: StatementHandle = 0x00000000003BB220
    Return: SQL_ERROR=-1
    stmt: szSqlState = "HY008", *pfNativeError = -8007, *pcbErrorMsg = 131, *ColumnNumber = -1, *RowNumber = -2
          MessageText = "[TRAF][Trafodion ODBC Driver][Trafodion Database] SQL error:*** ERROR[8007] The operation has been canceled. [2015-04-20 20:53:56]"
    stmt: szSqlState = "S1008", *pfNativeError = 0, *pcbErrorMsg = 50, *ColumnNumber = -1, *RowNumber = -2
          MessageText = "[TRAF][Trafodion ODBC Driver] Operation cancelled."