freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] problems using freetds with php & unixodbc

From: Axel Westhagen <axel.westhagen AT limbas.com>
To: freetds AT lists.ibiblio.org
Subject: [freetds] problems using freetds with php & unixodbc
Date: Wed, 09 Oct 2013 10:56:09 +0200

I add two trace files with the same statement execute from php and from isql.
They are different. iodbc use sqlPrepare.
It seems there is a Problem at "Null value is eliminated by an aggregate or
other SET operation" ?

thanks a lot

Axel

#### isql ######

[ODBC][25106][SQLAllocHandle.c][510]
Entry:
Handle Type = 3
Input Handle = 0x8387130
[ODBC][25106][SQLAllocHandle.c][872]
Exit:[SQL_SUCCESS]
Output Handle = 0x83d54b0
[ODBC][25106][SQLPrepare.c][189]
Entry:
Statement = 0x83d54b0
SQL = [select sum(vat_eur) from gi_costs_union; ][length =
41 (SQL_NTS)]
[ODBC][25106][SQLPrepare.c][364]
Exit:[SQL_SUCCESS]
[ODBC][25106][SQLExecute.c][183]
Entry:
Statement = 0x83d54b0
[ODBC][25106][SQLExecute.c][344]
Exit:[SQL_SUCCESS]
[ODBC][25106][SQLNumResultCols.c][149]
Entry:
Statement = 0x83d54b0
Column Count = 0xbfdbd26a
[ODBC][25106][SQLNumResultCols.c][234]
Exit:[SQL_SUCCESS]
Count = 0xbfdbd26a -> 1
[ODBC][25106][SQLNumResultCols.c][149]
Entry:
Statement = 0x83d54b0
Column Count = 0xbfdbcfb8
[ODBC][25106][SQLNumResultCols.c][234]
Exit:[SQL_SUCCESS]
Count = 0xbfdbcfb8 -> 1
[ODBC][25106][SQLColAttribute.c][277]
Entry:
Statement = 0x83d54b0
Column Number = 1
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0xbfdbce34
[ODBC][25106][SQLColAttribute.c][648]
Exit:[SQL_SUCCESS]
[ODBC][25106][SQLColAttribute.c][277]
Entry:
Statement = 0x83d54b0
Column Number = 1
Field Identifier = SQL_DESC_LABEL
Character Attr = 0xbfdbce3b
Buffer Length = 301
String Length = (nil)
Numeric Attribute = (nil)
[ODBC][25106][SQLColAttribute.c][648]
Exit:[SQL_SUCCESS]
[ODBC][25106][SQLColAttribute.c][277]
Entry:
Statement = 0x83d54b0
Column Number = 1
Field Identifier = SQL_DESC_LABEL
Character Attr = 0xbfdbd0fb
Buffer Length = 301
String Length = (nil)
Numeric Attribute = (nil)
[ODBC][25106][SQLColAttribute.c][648]
Exit:[SQL_SUCCESS]
[ODBC][25106][SQLNumResultCols.c][149]
Entry:
Statement = 0x83d54b0
Column Count = 0xbfdbcfb8
[ODBC][25106][SQLNumResultCols.c][234]
Exit:[SQL_SUCCESS]
Count = 0xbfdbcfb8 -> 1
[ODBC][25106][SQLFetch.c][158]
Entry:
Statement = 0x83d54b0
[ODBC][25106][SQLFetch.c][340]
Exit:[SQL_SUCCESS]
[ODBC][25106][SQLColAttribute.c][277]
Entry:
Statement = 0x83d54b0
Column Number = 1
Field Identifier = SQL_DESC_DISPLAY_SIZE
Character Attr = (nil)
Buffer Length = 0
String Length = (nil)
Numeric Attribute = 0xbfdbce34
[ODBC][25106][SQLColAttribute.c][648]
Exit:[SQL_SUCCESS]
[ODBC][25106][SQLColAttribute.c][277]
Entry:
Statement = 0x83d54b0
Column Number = 1
Field Identifier = SQL_DESC_LABEL
Character Attr = 0xbfdbce3b
Buffer Length = 301
String Length = (nil)
Numeric Attribute = (nil)
[ODBC][25106][SQLColAttribute.c][648]
Exit:[SQL_SUCCESS]
[ODBC][25106][SQLGetData.c][224]
Entry:
Statement = 0x83d54b0
Column Number = 1
Target Type = 1 SQL_CHAR
Buffer Length = 301
Target Value = 0xbfdbd0fb
StrLen Or Ind = 0xbfdbcfb4
[ODBC][25106][SQLGetData.c][470]
Exit:[SQL_SUCCESS]
Buffer = [119341,2808231654]
Strlen Or Ind = 0xbfdbcfb4 -> 17
[ODBC][25106][SQLFetch.c][158]
Entry:
Statement = 0x83d54b0
[ODBC][25106][SQLFetch.c][340]
Exit:[SQL_NO_DATA]
[ODBC][25106][SQLRowCount.c][166]
Entry:
Statement = 0x83d54b0
Row Count = 0xbfdbd230
[ODBC][25106][SQLRowCount.c][237]
Exit:[SQL_SUCCESS]
Row Count = 0xbfdbd230 -> 1
[ODBC][25106][SQLMoreResults.c][155]
Entry:
Statement = 0x83d54b0
[ODBC][25106][SQLMoreResults.c][311]
Exit:[SQL_NO_DATA]
[ODBC][25106][SQLFreeStmt.c][140]
Entry:
Statement = 0x83d54b0
Option = 1
[ODBC][25106][SQLFreeHandle.c][365]
Entry:
Handle Type = 3
Input Handle = 0x83d54b0
[ODBC][25106][SQLFreeHandle.c][462]
Exit:[SQL_SUCCESS]

############ php ##########

[ODBC][24866][SQLAllocHandle.c][510]
Entry:
Handle Type = 3
Input Handle = 0xa0c6f68
[ODBC][24866][SQLAllocHandle.c][872]
Exit:[SQL_SUCCESS]
Output Handle = 0xa05a5c8
[ODBC][24866][SQLGetInfo.c][214]
Entry:
Connection = 0xa0c6f68
Info Type = SQL_FETCH_DIRECTION (8)
Info Value = 0xbf9b7248
Buffer Length = 4
StrLen = (nil)
[ODBC][24866][SQLGetInfo.c][528]
Exit:[SQL_SUCCESS]
[ODBC][24866][SQLSetStmtOption.c][174]
Entry:
Statement = 0xa05a5c8
Option = SQL_ATTR_CURSOR_TYPE
Value = 3
[ODBC][24866][SQLSetStmtOption.c][370]
Exit:[SQL_SUCCESS]
[ODBC][24866][SQLExecDirect.c][233]
Entry:
Statement = 0xa05a5c8
SQL = [select sum(vat_eur) from gi_costs_union][length = 39
(SQL_NTS)]
[ODBC][24866][SQLExecDirect.c][496]
Exit:[SQL_SUCCESS_WITH_INFO]
DIAG [01003] [FreeTDS][SQL Server]Warning: Null value is
eliminated by an aggregate or other SET operation.

[ODBC][24866][SQLNumResultCols.c][149]
Entry:
Statement = 0xa05a5c8
Column Count = 0xa004c68
[ODBC][24866][SQLNumResultCols.c][234]
Exit:[SQL_SUCCESS]
Count = 0xa004c68 -> 0
[ODBC][24866][SQLFreeStmt.c][140]
Entry:
Statement = 0xa05a5c8
Option = 1
[ODBC][24866][SQLFreeHandle.c][365]
Entry:
Handle Type = 3
Input Handle = 0xa05a5c8
[ODBC][24866][SQLFreeHandle.c][462]
Exit:[SQL_SUCCESS]
[ODBC][24866][SQLDisconnect.c][204]
Entry:
Connection = 0xa0c6f68
[ODBC][24866][SQLDisconnect.c][341]
Exit:[SQL_SUCCESS]
[ODBC][24866][SQLFreeHandle.c][268]
Entry:
Handle Type = 2
Input Handle = 0xa0c6f68
[ODBC][24866][SQLFreeHandle.c][317]
Exit:[SQL_SUCCESS]
[ODBC][24866][SQLFreeHandle.c][203]
Entry:
Handle Type = 1
Input Handle = 0xa0cb260

[freetds] problems using freetds with php & unixodbc, Axel Westhagen, 10/07/2013
- [freetds] problems using freetds with php & unixodbc, Axel Westhagen, 10/09/2013
  - Re: [freetds] problems using freetds with php & unixodbc, James K. Lowden, 10/09/2013
    - [freetds] problems using freetds with php & unixodbc, Axel Westhagen, 10/10/2013