Bugs item #1082816, was opened at 2004-12-10 02:42
Message generated for change (Comment added) made by sf-robot
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1082816&group_id=56967

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/ODBC
Group: SQL CVS Head
>Status: Closed
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Steffen Goeldner (sgoeldner)
Assigned to: Sjoerd Mullender (sjoerd)
Summary: SQLColumns: integer vs. int

Initial Comment:
OS: Windows 2000
Compiler: MS VC++ Toolkit 2003
Parser tools: UnxUtils

Running perl -MDBI _c.pl, with _c.pl:

  DBI->connect->column_info( undef,'sys','env', undef )-
>dump_results;

shows

  DBD::ODBC::db column_info failed: [Microsoft][ODBC 
Driver Manager] Invalid string or buffer length (SQL-
HY090)(DBD: describe/SQLBindCol err=-1) at _c.pl line 1.

The ODBC log shows:

        perl cols       c2c-c10 EXIT  
SQLDescribeCol  with return code 0 (SQL_SUCCESS)
                HSTMT               014A29B0
                UWORD                        7 
                UCHAR *             0x013FEC0D [      
11] "column_size"
                SWORD                      255 
                SWORD *             0x01400B38 (11)
                SWORD *             0x01400B42 (0)
                SQLULEN *           0x01400B3C 
(4294967292)
                SWORD *             0x01400B40 (0)
                SWORD *             0x01400B44 (2)

        perl cols       c2c-c10 ENTER SQLBindCol 
                HSTMT               014A29B0
                UWORD                        7 
                SWORD                        1 
<SQL_C_CHAR>
                PTR                0x013FEB7C
                SQLLEN                    -3
                SQLLEN *            0x01400B58

        perl cols       c2c-c10 EXIT  SQLBindCol  
with return code -1 (SQL_ERROR)
                HSTMT               014A29B0
                UWORD                        7 
                SWORD                        1 
<SQL_C_CHAR>
                PTR                0x013FEB7C
                SQLLEN                    -3
                SQLLEN *            0x01400B58

                DIAG [HY090] [Microsoft][ODBC 
Driver Manager] Invalid string or buffer length (0) 


The DataType (0) and ColumnSize (4294967292) are 
wrong.
The attached patch changes

  "integer" to "int"

in SQLColumns.c.


----------------------------------------------------------------------

>Comment By: SourceForge Robot (sf-robot)
Date: 2007-11-29 19:20

Message:
Logged In: YES 
user_id=1312539
Originator: NO

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 365 days (the time period specified by
the administrator of this Tracker).

----------------------------------------------------------------------

Comment By: Stefan Manegold (stmane)
Date: 2006-11-29 01:04

Message:
Logged In: YES 
user_id=572415
Originator: NO

over-ruling "sf-robot":
re-set to "Pending" since adding a proper test has neither been done nor
finally been discarded, yet.

User (submitter) & developer (assignee),
please check, again.


----------------------------------------------------------------------

Comment By: SourceForge Robot (sf-robot)
Date: 2006-11-09 19:20

Message:
Logged In: YES 
user_id=1312539

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 365 days (the time period specified by
the administrator of this Tracker).

----------------------------------------------------------------------

Comment By: Sjoerd Mullender (sjoerd)
Date: 2005-11-09 04:22

Message:
Logged In: YES 
user_id=43607

BugDay_2005-11-09, sjoerd: NO TEST / POSTPONED
We need tests for *all* ODBC functions.

----------------------------------------------------------------------

Comment By: Niels Nes (nielsnes)
Date: 2004-12-10 13:47

Message:
Logged In: YES 
user_id=43556

applied patch

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=1082816&group_id=56967

-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell.  From the desktop to the data center, Linux is going
mainstream.  Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs

Reply via email to