[Mono-dev] Sybase ASA Odbc, timestamp, fractional seconds, possible bug in mono Odbc stack?

[A Nagappan]

Hi,

Fixed the issue in SVN trunk - revision 77937.

Thanks
Nagappan

Nagappan A <anagappan at novell.com>
Linux Desktop Testing Project - http://ldtp.freedesktop.org
http://nagappanal.blogspot.com

Novell, Inc.
SUSE® Linux Enterprise 10
Your Linux is ready™
http://www.novell.com/linux


>>> Mads Bondo Dydensborg <mbd at dbc.dk> 05/16/07 2:56 PM >>>
onsdag 16 maj 2007 11:08 skrev A Nagappan:
> Hi,
>   From the stack trace it looks like the issue is in System.DateTime,

How did you determine this? My impression was that the ODBC stack hands
over a 
frational second value in nanoseconds, and DateTime expects the
fractional 
value to be in milliseconds?

If that is the case, I can hardly blame DateTime for expecting a
millisecond 
value, can I?

Please advise.

Regards,

Mads


> could you please file a bug on that ? With a generic test-case to
> reproduce this bug.
> 
>
http://bugzilla.ximian.com/enter_bug.cgi?product=Mono%3A%20Class%20Libraries
> and Component as System.
> 
> Thanks
> Nagappan
> 
> 
> Nagappan A <anagappan at novell.com>
> Linux Desktop Testing Project - http://ldtp.freedesktop.org
> http://nagappanal.blogspot.com
> 
> Novell, Inc.
> SUSE* Linux Enterprise 10
> Your Linux is ready*
> http://www.novell.com/linux
> 
> 
> 
> >>> On Fri, May 4, 2007 at  6:15 PM, in message
> <200705041445.27847.mbd at dbc.dk>,
> Mads Bondo Dydensborg <mbd at dbc.dk> wrote: 
> > fredag 04 maj 2007 10:56 skrev A Nagappan:
> >> Hi,
> >> 
> >> Could you please send me a test.cs file to reproduce this bug ?
> > 
> > Please find it attached.
> > 
> > Running "select PublishedTime from PublishingJob" from isql returns:
> > 2007- 05- 03 10:57:15.000
> > 2007- 05- 03 10:57:15.920
> > 2007- 05- 03 10:57:15.000
> > 2007- 05- 03 10:57:15.000
> > 
> > And, the output from the test.cs program is:
> > 
> > $ mono -- debug test.exe
> > Creating connection
> > Opening connection
> > Executing command
> > Reading data
> > Column 0: 5/3/2007 10:57:15 AM
> > 
> > Unhandled Exception: System.ArgumentOutOfRangeException: Argument is
> out of 
> > range.
> > Parameter name: Parameters describe an unrepresentable DateTime.
> >   at System.DateTime..ctor (Int32 year, Int32 month, Int32 day,
Int32
> hour, 
> > Int32 minute, Int32 second, Int32 millisecond) [0x00000]
> >   at System.Data.Odbc.OdbcDataReader.GetValue (Int32 ordinal)
> [0x00415] 
> > in 
> >
>
/home/compile/Compile/Mono/mcs/class/System.Data/System.Data.Odbc/OdbcDataRea
> > der.cs:730
> >   at System.Data.Odbc.OdbcDataReader.get_Item (Int32 index)
[0x00000]
> 
> > in 
> >
>
/home/compile/Compile/Mono/mcs/class/System.Data/System.Data.Odbc/OdbcDataRea
> > der.cs:153
> >   at Test.OdbcTest.OdbcTest.Main (System.String[] args) [0x00057] 
> > in /home/madsdyd/Tests/OdbcDateTime/test.cs:26
> > 
> > So, the first row is correctly made into a DateTime, the next is
not.
> 
> > Stripping the fractional of all dates in the database works, but is
> not 
> > really what I want :- )
> > 
> > Regards & thanks in advance for your help.
> > 
> > Mads
> 
> 
> 
> 

-- 
Med venlig hilsen/Regards

Systemudvikler/Systemsdeveloper cand.scient.dat, Ph.d., Mads Bondo
Dydensborg
Dansk BiblioteksCenter A/S, Tempovej 7-11, 2750 Ballerup, Tlf. +45 44 86
77 34