[
https://issues.apache.org/jira/browse/TRAFODION-2633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
苏锦佩 updated TRAFODION-2633:
---------------------------
Environment:
Server Info:
$ sqvers
TRAF_HOME=/home/xwx/incubator-trafodion/core/sqf
who@host=xwx@weixin-1
JAVA_HOME=/home/xwx/jdk1.7.0_67
SQ_MBTYPE=64d (64-debug)
linux=2.6.32-642.11.1.el6.x86_64
redhat=6.7
libarkcmp_dll.so tdm_arkcmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libarkcmplib.so libarkcmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libcli.so libcli Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libclitest.so libclitest Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libcomexe.so libcomexe Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libcommon.so COMMON Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libdummy.so libdummy Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libeh.so libeh Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
libevlsqms.so sq_evl_lib Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libevlsq.so sq_evl_lib Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libexecutor.so libexecutor Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libgenerator.so libgenerator Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libidtm.so tm_libidtm Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libjdbcT2.so type2 Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
liblmcomp.so liblmcomp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libmtmpi.so mpi_libmtmpi Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libmxocore.so ndcs Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
liboptimizer.so liboptimizer Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libparser.so libparser Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libporting_layer.so libporting_layer Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libqmscommon.so libqmscommon Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsbfs.so libsbfs Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libsblogalt.so libsblogalt Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsbms.so libsbms Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libsbsautil.so libsbsautil Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsbutil.so libsbutil Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libseabasesig.so libseabasesig Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libshbasetmlib.so tm_libshbasetmlib2 Version 3.1.0 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsmdio.so libsmdio Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libsm.so libsm Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
libsort.so libsort Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libsqauth.so dbsecurity_libsqauth Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqcert.so dbsecurity_libsqcert Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqlcat.so libsqlcat Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqlcilib.so libsqlcilib Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libSqlCompilerDebugger.so libSqlCompilerDebugger Version 1.0.1 Apache_Trafodion
Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqlcomp.so libsqlcomp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqlcomp.so xx Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libsqlmsg.so libsqlmsg Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqstatesb.so libsqstatesb Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libstfs.so libstfs Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libstmlib.so tm_libstmlib Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsxatmlib.so tm_libsxatmlib Version 3.1.0 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_measenty.so libtdm_measenty Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_security.so libtdm_security Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlcli_globals.so libtdm_sqlcli_globals Version 1.0.1 Apache_Trafodion
Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlcli.so libcli Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlerrormsg.so libtdm_sqlerrormsg Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlexport.so libtdm_sqlexport Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlexp.so libtdm_sqlexp Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqllangman.so libtdm_sqllangman Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlmxevents.so libtdm_sqlmxevents Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlmxmsg_intl.so libtdm_sqlmxmsg_intl Version 1.0.1 Apache_Trafodion
Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlshare.so libtdm_sqlshare Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_tfds.so libtdm_tfds Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_tmflib.so libtdm_tmflib Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_tmfuser.so libtdm_tmfuser Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtrafodbc64.so libtrafodbc Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtrafodbc_drvr64.so libtrafodbc Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtrafodbc_l64_drvr.so libtrafodbc Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtrafodbc_l64.so libtrafodbc Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libudr_predef.so libudr_predef Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libustat.so libustat Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libwin.so win_libwin Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libxarm.so tm_libxarm Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
clitestdriver clitestdriver Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
dtmci dtmci Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
idtmsrv idtmsrv Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
ldapcheck dbsecurity_ldapcheck Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
ldapconfigcheck dbsecurity_sqldapconfigcheck Version 1.0.1 Apache_Trafodion
Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
monitor monitor Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
monmemlog monmemlog Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
mxlobsrvr sqlci Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
mxosrvr ndcs Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
mxsscp mxsscp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
mxssmp mxssmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
odb64luo odb64luo Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
pstartd pstartd Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
shell shell Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
sqlci sqlci Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
sqwatchdog sqwatchdog Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
tdm_arkcmp tdm_arkcmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
tdm_arkesp tdm_arkesp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
tdm_udrserv tdm_udrserv Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
tm tm Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug [xwx], branch
acc3b34fb-master, date 26Apr17)
tmshutdown tmshutdown Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
hbase-trx-apache1_0-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-apache1_1-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-apache1_2-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-cdh5_4-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-cdh5_5-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-cdh5_7-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-hdp2_3-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
jdbcT2.jar Version 1.0.0 Apache Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb_master, date 26Apr17)
jdbcT4-2.2.0.jar Version 2.2.0 Apache Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb_master, date 26Apr17)
jdbcT4.jar Version 2.2.0 Apache Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb_master, date 26Apr17)
lib_mgmt.jar Version 1.0.0 Apache Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb_master, date 26Apr17)
sqmanvers.jar Version 1.0.2 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb_master, date 26Apr17)
trafodion-dtm-apache-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-dtm-cdh-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-dtm-hdp-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-sql-apache-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-sql-cdh-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-sql-hdp-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-utility-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
Description:
please see below code segment, after SQLFetch buf2 expected result:
{precision = 0x3, scale = 0x0, sign = 0x0, val = {0x80, 0x0 <repeats 15
times>}} ,
Actual:
{precision = 0x3, scale = 0x0, sign = 0x2, val = {0x0 <repeats 15 times>,
0x80}}
void test(SQLHANDLE hstmt)
{
SQLRETURN retcode;
SQL_NUMERIC_STRUCT buf;
SQL_NUMERIC_STRUCT buf2;
memset(&buf, '\0', sizeof(SQL_NUMERIC_STRUCT));
memset(&buf2, '\0', sizeof(SQL_NUMERIC_STRUCT));
buf.precision = 3;
buf.scale = 0;
buf.sign = 0;
buf.val[0] = 128;
SQLLEN len = SQL_NTS;
SQLSMALLINT nc = 0;
int id = 1;
retcode = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SSHORT,
SQL_INTEGER, 0, 0, &id, 0, &len);
check(retcode, "SQLBindParameter", SQL_HANDLE_STMT, hstmt);
len = SQL_NTS;
retcode = SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_NUMERIC,
SQL_TINYINT, 0, 0, &buf, sizeof(SQL_NUMERIC_STRUCT), &len);
check(retcode, "SQLBindParameter", SQL_HANDLE_STMT, hstmt);
char *sqls[] = {
"DROP TABLE TB_TEST",
"CREATE TABLE TB_TEST(ID INT, C TINYINT)",
"INSERT INTO TB_TEST VALUES(?,?)",
"SELECT * FROM TB_TEST",
"END_LOOP"
};
for (int i = 0; strcmp(sqls[i], "END_LOOP"); ++i)
{
retcode = SQLExecDirect(hstmt, (SQLCHAR*)sqls[i], SQL_NTS);
check(retcode, sqls[i], SQL_HANDLE_STMT, hstmt);
}
retcode = SQLNumResultCols(hstmt, &nc);
check(retcode, "SQLNumResultCols", SQL_HANDLE_STMT, hstmt);
retcode = SQLBindCol(hstmt, 2, SQL_C_NUMERIC, &buf2, sizeof(buf2), &len);
check(retcode, "SQLBindCol", SQL_HANDLE_STMT, hstmt);
retcode = SQLFetch(hstmt);
check(retcode, "SQLFetch", SQL_HANDLE_STMT, hstmt);
}
was:
Server Info:
$ sqvers
TRAF_HOME=/home/xwx/incubator-trafodion/core/sqf
who@host=xwx@weixin-1
JAVA_HOME=/home/xwx/jdk1.7.0_67
SQ_MBTYPE=64d (64-debug)
linux=2.6.32-642.11.1.el6.x86_64
redhat=6.7
libarkcmp_dll.so tdm_arkcmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libarkcmplib.so libarkcmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libcli.so libcli Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libclitest.so libclitest Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libcomexe.so libcomexe Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libcommon.so COMMON Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libdummy.so libdummy Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libeh.so libeh Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
libevlsqms.so sq_evl_lib Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libevlsq.so sq_evl_lib Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libexecutor.so libexecutor Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libgenerator.so libgenerator Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libidtm.so tm_libidtm Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libjdbcT2.so type2 Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
liblmcomp.so liblmcomp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libmtmpi.so mpi_libmtmpi Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libmxocore.so ndcs Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
liboptimizer.so liboptimizer Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libparser.so libparser Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libporting_layer.so libporting_layer Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libqmscommon.so libqmscommon Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsbfs.so libsbfs Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libsblogalt.so libsblogalt Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsbms.so libsbms Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libsbsautil.so libsbsautil Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsbutil.so libsbutil Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libseabasesig.so libseabasesig Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libshbasetmlib.so tm_libshbasetmlib2 Version 3.1.0 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsmdio.so libsmdio Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libsm.so libsm Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
libsort.so libsort Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libsqauth.so dbsecurity_libsqauth Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqcert.so dbsecurity_libsqcert Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqlcat.so libsqlcat Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqlcilib.so libsqlcilib Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libSqlCompilerDebugger.so libSqlCompilerDebugger Version 1.0.1 Apache_Trafodion
Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqlcomp.so libsqlcomp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqlcomp.so xx Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libsqlmsg.so libsqlmsg Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsqstatesb.so libsqstatesb Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libstfs.so libstfs Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libstmlib.so tm_libstmlib Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libsxatmlib.so tm_libsxatmlib Version 3.1.0 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_measenty.so libtdm_measenty Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_security.so libtdm_security Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlcli_globals.so libtdm_sqlcli_globals Version 1.0.1 Apache_Trafodion
Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlcli.so libcli Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlerrormsg.so libtdm_sqlerrormsg Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlexport.so libtdm_sqlexport Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlexp.so libtdm_sqlexp Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqllangman.so libtdm_sqllangman Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlmxevents.so libtdm_sqlmxevents Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlmxmsg_intl.so libtdm_sqlmxmsg_intl Version 1.0.1 Apache_Trafodion
Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_sqlshare.so libtdm_sqlshare Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_tfds.so libtdm_tfds Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_tmflib.so libtdm_tmflib Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtdm_tmfuser.so libtdm_tmfuser Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtrafodbc64.so libtrafodbc Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtrafodbc_drvr64.so libtrafodbc Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtrafodbc_l64_drvr.so libtrafodbc Version 1.0.1 Apache_Trafodion Release
2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libtrafodbc_l64.so libtrafodbc Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libudr_predef.so libudr_predef Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
libustat.so libustat Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libwin.so win_libwin Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
libxarm.so tm_libxarm Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
clitestdriver clitestdriver Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
dtmci dtmci Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
idtmsrv idtmsrv Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
ldapcheck dbsecurity_ldapcheck Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
ldapconfigcheck dbsecurity_sqldapconfigcheck Version 1.0.1 Apache_Trafodion
Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
monitor monitor Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
monmemlog monmemlog Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
mxlobsrvr sqlci Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
mxosrvr ndcs Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
mxsscp mxsscp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
mxssmp mxssmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
odb64luo odb64luo Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
pstartd pstartd Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
shell shell Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
sqlci sqlci Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb-master, date 26Apr17)
sqwatchdog sqwatchdog Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
tdm_arkcmp tdm_arkcmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
tdm_arkesp tdm_arkesp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
tdm_udrserv tdm_udrserv Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb-master, date 26Apr17)
tm tm Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug [xwx], branch
acc3b34fb-master, date 26Apr17)
tmshutdown tmshutdown Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb-master, date 26Apr17)
hbase-trx-apache1_0-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-apache1_1-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-apache1_2-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-cdh5_4-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-cdh5_5-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-cdh5_7-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
hbase-trx-hdp2_3-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
jdbcT2.jar Version 1.0.0 Apache Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb_master, date 26Apr17)
jdbcT4-2.2.0.jar Version 2.2.0 Apache Trafodion Release 2.2.0 (Build debug
[xwx], branch acc3b34fb_master, date 26Apr17)
jdbcT4.jar Version 2.2.0 Apache Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb_master, date 26Apr17)
lib_mgmt.jar Version 1.0.0 Apache Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb_master, date 26Apr17)
sqmanvers.jar Version 1.0.2 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
branch acc3b34fb_master, date 26Apr17)
trafodion-dtm-apache-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-dtm-cdh-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-dtm-hdp-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-sql-apache-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
(Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-sql-cdh-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-sql-hdp-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
trafodion-utility-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
debug [xwx], branch acc3b34fb_master, date 26Apr17)
> SQLFetch didn't fetch expected result when converting from SQL_TINYINT to
> SQL_C_NUMERIC
> ---------------------------------------------------------------------------------------
>
> Key: TRAFODION-2633
> URL: https://issues.apache.org/jira/browse/TRAFODION-2633
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-odbc-linux, client-odbc-windows
> Affects Versions: 2.2-incubating
> Environment: Server Info:
> $ sqvers
> TRAF_HOME=/home/xwx/incubator-trafodion/core/sqf
> who@host=xwx@weixin-1
> JAVA_HOME=/home/xwx/jdk1.7.0_67
> SQ_MBTYPE=64d (64-debug)
> linux=2.6.32-642.11.1.el6.x86_64
> redhat=6.7
> libarkcmp_dll.so tdm_arkcmp Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libarkcmplib.so libarkcmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libcli.so libcli Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> libclitest.so libclitest Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libcomexe.so libcomexe Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libcommon.so COMMON Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> libdummy.so libdummy Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libeh.so libeh Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> libevlsqms.so sq_evl_lib Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libevlsq.so sq_evl_lib Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libexecutor.so libexecutor Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libgenerator.so libgenerator Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libidtm.so tm_libidtm Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libjdbcT2.so type2 Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> liblmcomp.so liblmcomp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libmtmpi.so mpi_libmtmpi Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libmxocore.so ndcs Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> liboptimizer.so liboptimizer Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libparser.so libparser Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libporting_layer.so libporting_layer Version 1.0.1 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libqmscommon.so libqmscommon Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsbfs.so libsbfs Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> libsblogalt.so libsblogalt Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsbms.so libsbms Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> libsbsautil.so libsbsautil Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsbutil.so libsbutil Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libseabasesig.so libseabasesig Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libshbasetmlib.so tm_libshbasetmlib2 Version 3.1.0 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsmdio.so libsmdio Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsm.so libsm Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> libsort.so libsort Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> libsqauth.so dbsecurity_libsqauth Version 1.0.1 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsqcert.so dbsecurity_libsqcert Version 1.0.1 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsqlcat.so libsqlcat Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsqlcilib.so libsqlcilib Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libSqlCompilerDebugger.so libSqlCompilerDebugger Version 1.0.1
> Apache_Trafodion Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master,
> date 26Apr17)
> libsqlcomp.so libsqlcomp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsqlcomp.so xx Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> libsqlmsg.so libsqlmsg Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsqstatesb.so libsqstatesb Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libstfs.so libstfs Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> libstmlib.so tm_libstmlib Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libsxatmlib.so tm_libsxatmlib Version 3.1.0 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_measenty.so libtdm_measenty Version 1.0.1 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_security.so libtdm_security Version 1.0.1 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_sqlcli_globals.so libtdm_sqlcli_globals Version 1.0.1 Apache_Trafodion
> Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_sqlcli.so libcli Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_sqlerrormsg.so libtdm_sqlerrormsg Version 1.0.1 Apache_Trafodion
> Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_sqlexport.so libtdm_sqlexport Version 1.0.1 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_sqlexp.so libtdm_sqlexp Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_sqllangman.so libtdm_sqllangman Version 1.0.1 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_sqlmxevents.so libtdm_sqlmxevents Version 1.0.1 Apache_Trafodion
> Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_sqlmxmsg_intl.so libtdm_sqlmxmsg_intl Version 1.0.1 Apache_Trafodion
> Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_sqlshare.so libtdm_sqlshare Version 1.0.1 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_tfds.so libtdm_tfds Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_tmflib.so libtdm_tmflib Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtdm_tmfuser.so libtdm_tmfuser Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtrafodbc64.so libtrafodbc Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtrafodbc_drvr64.so libtrafodbc Version 1.0.1 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtrafodbc_l64_drvr.so libtrafodbc Version 1.0.1 Apache_Trafodion Release
> 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libtrafodbc_l64.so libtrafodbc Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libudr_predef.so libudr_predef Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libustat.so libustat Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libwin.so win_libwin Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> libxarm.so tm_libxarm Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> clitestdriver clitestdriver Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> dtmci dtmci Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
> branch acc3b34fb-master, date 26Apr17)
> idtmsrv idtmsrv Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> ldapcheck dbsecurity_ldapcheck Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> ldapconfigcheck dbsecurity_sqldapconfigcheck Version 1.0.1 Apache_Trafodion
> Release 2.2.0 (Build debug [xwx], branch acc3b34fb-master, date 26Apr17)
> monitor monitor Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> monmemlog monmemlog Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> mxlobsrvr sqlci Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> mxosrvr ndcs Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
> branch acc3b34fb-master, date 26Apr17)
> mxsscp mxsscp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> mxssmp mxssmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> odb64luo odb64luo Version 1.0.0 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> pstartd pstartd Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb-master, date 26Apr17)
> shell shell Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
> branch acc3b34fb-master, date 26Apr17)
> sqlci sqlci Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build debug [xwx],
> branch acc3b34fb-master, date 26Apr17)
> sqwatchdog sqwatchdog Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> tdm_arkcmp tdm_arkcmp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> tdm_arkesp tdm_arkesp Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> tdm_udrserv tdm_udrserv Version 1.0.1 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> tm tm Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build debug [xwx], branch
> acc3b34fb-master, date 26Apr17)
> tmshutdown tmshutdown Version 3.1.0 Apache_Trafodion Release 2.2.0 (Build
> debug [xwx], branch acc3b34fb-master, date 26Apr17)
> hbase-trx-apache1_0-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> hbase-trx-apache1_1-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> hbase-trx-apache1_2-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> hbase-trx-cdh5_4-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> hbase-trx-cdh5_5-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> hbase-trx-cdh5_7-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> hbase-trx-hdp2_3-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> jdbcT2.jar Version 1.0.0 Apache Trafodion Release 2.2.0 (Build debug [xwx],
> branch acc3b34fb_master, date 26Apr17)
> jdbcT4-2.2.0.jar Version 2.2.0 Apache Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb_master, date 26Apr17)
> jdbcT4.jar Version 2.2.0 Apache Trafodion Release 2.2.0 (Build debug [xwx],
> branch acc3b34fb_master, date 26Apr17)
> lib_mgmt.jar Version 1.0.0 Apache Trafodion Release 2.2.0 (Build debug [xwx],
> branch acc3b34fb_master, date 26Apr17)
> sqmanvers.jar Version 1.0.2 Apache_Trafodion Release 2.2.0 (Build debug
> [xwx], branch acc3b34fb_master, date 26Apr17)
> trafodion-dtm-apache-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> trafodion-dtm-cdh-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> trafodion-dtm-hdp-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> trafodion-sql-apache-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> trafodion-sql-cdh-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> trafodion-sql-hdp-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> trafodion-utility-2.2.0.jar Version 1.0.1 Apache_Trafodion Release 2.2.0
> (Build debug [xwx], branch acc3b34fb_master, date 26Apr17)
> Reporter: 苏锦佩
>
> please see below code segment, after SQLFetch buf2 expected result:
> {precision = 0x3, scale = 0x0, sign = 0x0, val = {0x80, 0x0 <repeats 15
> times>}} ,
> Actual:
> {precision = 0x3, scale = 0x0, sign = 0x2, val = {0x0 <repeats 15 times>,
> 0x80}}
> void test(SQLHANDLE hstmt)
> {
> SQLRETURN retcode;
> SQL_NUMERIC_STRUCT buf;
> SQL_NUMERIC_STRUCT buf2;
> memset(&buf, '\0', sizeof(SQL_NUMERIC_STRUCT));
> memset(&buf2, '\0', sizeof(SQL_NUMERIC_STRUCT));
> buf.precision = 3;
> buf.scale = 0;
> buf.sign = 0;
> buf.val[0] = 128;
> SQLLEN len = SQL_NTS;
> SQLSMALLINT nc = 0;
> int id = 1;
> retcode = SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT, SQL_C_SSHORT,
> SQL_INTEGER, 0, 0, &id, 0, &len);
> check(retcode, "SQLBindParameter", SQL_HANDLE_STMT, hstmt);
> len = SQL_NTS;
> retcode = SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT, SQL_C_NUMERIC,
> SQL_TINYINT, 0, 0, &buf, sizeof(SQL_NUMERIC_STRUCT), &len);
> check(retcode, "SQLBindParameter", SQL_HANDLE_STMT, hstmt);
> char *sqls[] = {
> "DROP TABLE TB_TEST",
> "CREATE TABLE TB_TEST(ID INT, C TINYINT)",
> "INSERT INTO TB_TEST VALUES(?,?)",
> "SELECT * FROM TB_TEST",
> "END_LOOP"
> };
> for (int i = 0; strcmp(sqls[i], "END_LOOP"); ++i)
> {
> retcode = SQLExecDirect(hstmt, (SQLCHAR*)sqls[i], SQL_NTS);
> check(retcode, sqls[i], SQL_HANDLE_STMT, hstmt);
> }
> retcode = SQLNumResultCols(hstmt, &nc);
> check(retcode, "SQLNumResultCols", SQL_HANDLE_STMT, hstmt);
> retcode = SQLBindCol(hstmt, 2, SQL_C_NUMERIC, &buf2, sizeof(buf2), &len);
> check(retcode, "SQLBindCol", SQL_HANDLE_STMT, hstmt);
> retcode = SQLFetch(hstmt);
> check(retcode, "SQLFetch", SQL_HANDLE_STMT, hstmt);
> }
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
