[Mono-list] Bug (?) in SqliteDataReader

[Joshua Tauberer]

Nikki Locke wrote:
> Thats a point against my patch.
...
> That's a point against the existing implementation.
...
> That's a point against this proposed fix.
...
> That sounds horrible.
...
> That's a cop-out :-)

Heh, yeah.

> What about putting in some type checking when the data is _written_ to the 
> database, instead? OK, it wouldn't stop exceptions being thrown if the data 
> was written by a some other app, but at least it would make things work 
> consistently.

I don't think there should be a database that can't be read using any
method, even if it wasn't created with Mono.Data.SqliteClient and even
if it has crazy nonuniform data in columns.

> Could I have a copy of the test code you used to try all this out? I want 
> to run it on the Microsoft/Finisar version, to see what happens.

I was just fooling around with your original test case.  For instance,
just change '2006-05-11 11:45:00' to 123.456.  (Or, change the 'date'
type of the column to integer and add some doubles and strings into the
table.  Things like that.)

-- 
- Joshua Tauberer

http://taubz.for.net

"Unfortunately, we're having this discussion. It's too bad,
because guess who listens to the discussion: the enemy."