System.Data.SQLite

I'm getting the same error with 1.0.46.0.  In my case when I try to fill a table in the dataset this error occurs.  I looked at the definitions of the columns in the table object in the dataset (yes the table was created in the dataset) and one of the columns had it's datatype set to DBNull.  It so happens that this column is defined as text in the sqlite database but actually contains enpty strings or formatted numbers (Ie 001 etc).  In future it will contain text too which is why I defined it as text.  This was not a problem in 1.0.45.0.  All the other columns in the table in the dataset have correct datatypes.

 I hope this helps to quickly fix this issue.

 Many Thanks.

 Adrian

I need more information on this asap so I can duplicate the error here.  If anyone would like to send me a sample database, e-mail me: robert at blackcastlesoft dot com

Robert

 I think I have found a reproducible way for this : create a view across table(s) which returns no rows, and execute DataAdapter.Fill(dataTable) - an error pops in. If you still can not reproduce it, I will send my db and some code. I use types in forementioned query - but allready tested without TYPES - and still crashes.

Close enough.  I was able to duplicate the problem.

Robert

 Any news on this issue? I saw SQLite 3.5.2 was out, so just wanted to ask if there will be a new version soon, or to ask for 1.0.46.1 with fix for this included...

There have been quite a few changes to the core engine with 3.5, so its taking an abnormally long time to get a release out.  I was also waiting for 3.5.2 to even start -- the previous releases were either unstable, or did not work at all on CE.

Robert

Thanks for the info, Robert. 

I am still having the problem with the versione 1.0.47.2

I am getting the error on this query

SELECT * FROM PARTENERI WHERE CodExtern='RO 13027156'

UNION ALL

SELECT CodExtern, Denumire, CodFiscal, Localitate, Adresa, Telefon, SimbolClasa,SimbolCategPret, 0 AS Scadenta, '' AS BancaCont, '' AS RegCom, 0 AS Sold,0 as SoldAgent,DATETIME('NOW') as DataFactScad,DATETIME('NOW') as DataFactScad FROM Parteneri_Noi WHERE CodExtern='RO 13027156'

ORDER BY DENUMIRE

If I take out the ORDER BY it works. The problem is when the second query the select returns an empty result. If you want I can send you the database.

The easiest way to see this problem is

using (SQLiteCommand cmd = cnn.CreateCommand())
{
    cmd.CommandText = "SELECT NULL";
    using (SQLiteDataReader reader = cmd.ExecuteReader())
    {
      reader.Read();
      Type t = reader.GetFieldType(0);
    }
}

The bug occurred when the provider encountered a null value, and had no idea what kind of type to give it (meaning, no table schema to glean a type from).  In such cases, the provider was returning type "DBNull" when a more accurate approach given SQLite's typelessness is to return type "object".

It's fixed for the .48 release.

Robert

Any idea when the .48 will be out? If it will take long could you please do a 47.3?

Thanks,

Dan