Further to this, it seems that bigint support was forgotten for the .NET
data provider completely. From revision log:
September 27, 2007, V5.0.2:
* Enhanced database engine
- Added support for 64bit bigint
But if I SELECT CAST(1 AS bigint) then VirtuosoDataReader's GetFieldType
says it's a string yet GetValue gives me an Int32 again.
Is there an updated version of the .NET data provider somewhere that
never made it into the Open-Source Edition code base perhaps?
Regards,
Will
Will Daniels wrote:
> Hi!
>
> I've been doing some stuff using the .NET client library from VOS 5.0.11
> but I encountered a bug with the GetValue and GetValues methods of the
> VirtuosoDataReader class. When getting an int16 value, the object
> returned is actually typed int32 even though GetFieldType correctly
> identifies the column as int16 (for smallint).
>
> I discovered this when reading the INFORMATION_SCHEMA.TABLES view and
> have not had chance yet to test the issue with non-view tables,
> different sized integers or other types, but thought it best to ask
> about the issue first in case it is already known/fixed or considered
> correct.
>
> Thanks,
> Will
>
> ------------------------------------------------------------------------------
> Crystal Reports - New Free Runtime and 30 Day Trial
> Check out the new simplified licensing option that enables unlimited
> royalty-free distribution of the report engine for externally facing
> server and web deployment.
> http://p.sf.net/sfu/businessobjects
> _______________________________________________
> Virtuoso-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-devel
