[
https://issues.apache.org/jira/browse/TRAFODION-2818?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16284442#comment-16284442
]
ASF GitHub Bot commented on TRAFODION-2818:
-------------------------------------------
Github user selvaganesang commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/1311#discussion_r155901708
--- Diff: win-odbc64/odbcclient/drvr35/sqltocconv.cpp ---
@@ -36,6 +36,34 @@
#define MAXCHARLEN 32768 //32K
+// for server2008 when using function pow() then throws
STATUS_ILLEGAL_INSTRUCTION
+__int64 pow(int base, short scale)
+{
+ DWORD dwVersion = 0;
+ DWORD dwBuild = 0;
+
+ dwVersion = GetVersion();
+
+ // Get the build number.
+
+ if (dwVersion < 0x80000000)
+ dwBuild = (DWORD)(HIWORD(dwVersion));
+
+ __int64 retValue = 1;
+ if (dwBuild == 7600)
+ {
+ scale = scale > 18 ? 18 : scale;
+ for (int i = 0; i < scale; i++)
+ retValue = retValue * 10;
+ }
+ else
+ {
+ retValue = pow((double)base, scale);
--- End diff --
I would suggest to retain double data type for return type to enable a
large result to be accommodated without raising numeric overflow. Hence, I
would suggest Trafodion function can have an extra parameter like to pass the
errno as in
double pow (double base, double exponent, int *error)
Pass the errno to be returned to the caller for it handle it. This would
also take care of any ambiguity in resolution of the method
> For Server 2008, function pow() in driver ODBC throws
> STATUS_ILLEGAL_INSTRUCTION
> --------------------------------------------------------------------------------
>
> Key: TRAFODION-2818
> URL: https://issues.apache.org/jira/browse/TRAFODION-2818
> Project: Apache Trafodion
> Issue Type: Bug
> Components: client-odbc-windows
> Affects Versions: any
> Environment: Server 2008 R2
> Reporter: XuWeixin
> Assignee: XuWeixin
> Fix For: any
>
>
> SQL_NUMERIC to SQL_C_CHAR
> ***ERROR: SQLGetData: Expected: SQL_SUCCESS Actual: SQL_ERROR
> State: HY000
> Native Error: 29
> Error: [TRAF][Trafodion ODBC Driver] General error.EXCEPTION: UNKNOWN -
> Exception Code = c000001d
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
