[Devel] [ openser-Bugs-1598507 ] table_version() fail with Oracle Instant Client driver

[SourceForge.net]

Bugs item #1598507, was opened at 2006-11-17 19:06
Message generated for change (Comment added) made by bogdan_iancu
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1598507&group_id=139143

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: modules
Group: ver 1.1.x
>Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Marcos Hack (marcoshack)
Assigned to: Bogdan (bogdan_iancu)
Summary: table_version() fail with Oracle Instant Client driver

Initial Comment:

I'm using unixodbc module with Oracle Instant Client as database driver.

When using module 'auth_db' the function db/db.c:table_version() fail because 'VAL_TYPE(ver) != DB_INT'.

The problem is that Instant Client ODBC driver returns  SQL_DECIMAL for a SMALLINT column in database.

I've added SQL_DECIMAL to 'switch(DataType)' in modules/unixodbc/res.c:get_column() as DB_INT.

Regards.


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

>Comment By: Bogdan (bogdan_iancu)
Date: 2006-11-22 16:41

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

Thanks for the patch - it is on CVS now.

regards,
bogdan

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

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1598507&group_id=139143