[Mono-bugs] [Bug 380252] New: Mono.Data.SQLite crashes on call to SqliteDataAdapter. Fill(DataTable table) with simple SELECT

bugzilla_noreply at novell.com bugzilla_noreply at novell.com
Tue Apr 15 21:19:07 EDT 2008


https://bugzilla.novell.com/show_bug.cgi?id=380252


           Summary: Mono.Data.SQLite crashes on call to
                    SqliteDataAdapter.Fill(DataTable table) with simple
                    SELECT
           Product: Mono: Class Libraries
           Version: 1.9.0
          Platform: i686
        OS/Version: openSUSE 10.3
            Status: NEW
          Severity: Critical
          Priority: P5 - None
         Component: Mono.Data.Sqlite
        AssignedTo: mhabersack at novell.com
        ReportedBy: moliveira at geostats.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: Customer


I am getting a crash when trying to fill a DataTable from a SQLite connection. 
I am using the Mono-1.9_openSUSE-10.3.i686 VMWare image downloaded from 
http://www.go-mono.com/mono-downloads/download.html.  

Below are the code sample and the resulting error.

<<<< CODE SAMPLE

using System;
using System.Data;
using Mono.Data.Sqlite;

namespace TestSqlLite
{
class MainClass
{
public static void Main(string[] args)
{

SqliteConnection conn = new SqliteConnection("Data Source=test.db;version=3");
conn.Open();

SqliteCommand create = new SqliteCommand("CREATE TABLE test (id INTEGER, label
TEXT(50));", conn);
create.ExecuteNonQuery();
create.Dispose();

SqliteCommand insert = new SqliteCommand("INSERT INTO test VALUES (1,
'TEST');", conn);
insert.ExecuteNonQuery();
insert.Dispose();

SqliteCommand sel = new SqliteCommand("SELECT * FROM test;", conn);
SqliteDataAdapter adapter =new SqliteDataAdapter(sel);
DataTable test = new DataTable("test");
adapter.Fill(test);

conn.Close();
}
}
}

>>>>

<<<<EXCEPTION

Unhandled Exception: System.EntryPointNotFoundException:
sqlite3_column_origin_name
  at (wrapper managed-to-native)
Mono.Data.Sqlite.UnsafeNativeMethods:sqlite3_column_origin_name (intptr,int)
  at Mono.Data.Sqlite.Sqlite3.ColumnOriginalName
(Mono.Data.Sqlite.SqliteStatement stmt, Int32 index) [0x00000] in
/tmp/monobuild/build/BUILD/mono-1.9/mcs/class/Mono.Data.Sqlite/Mono.Data
Sqlite_2.0/SQLite3.cs:399  
  at Mono.Data.Sqlite.SqliteDataReader.GetSchemaTable (Boolean wantUniqueInfo,
Boolean wantDefaultValue) [0x00440] in
/tmp/monobuild/build/BUILD/mono-1.9/mcs/class/Mono.Data.Sqlite/Mono.Data
Sqlite_2.0/SQLiteDataReader.cs:667  
  at Mono.Data.Sqlite.SqliteDataReader.GetSchemaTable () [0x00000] in
/tmp/monobuild/build/BUILD/mono-1.9/mcs/class/Mono.Data.Sqlite/Mono.Data
Sqlite_2.0/SQLiteDataReader.cs:600  
  at System.Data.Common.DataAdapter.BuildSchema (IDataReader reader,
System.Data.DataTable table, SchemaType schemaType, MissingSchemaAction
missingSchAction, MissingMappingAction missingMapAction,
System.Data.Common.DataTableMappingCollection dtMapping) [0x0003b] in
/tmp/monobuild/build/BUILD/mono-1.9/mcs/class/System.Data/System.Data.Co
mmon/DataAdapter.cs:284  
  at System.Data.Common.DataAdapter.BuildSchema (IDataReader reader,
System.Data.DataTable table, SchemaType schemaType) [0x00000] in
/tmp/monobuild/build/BUILD/mono-1.9/mcs/class/System.Data/System.Data.Co
mmon/DataAdapter.cs:257  
  at System.Data.Common.DataAdapter.FillTable (System.Data.DataTable dataTable,
IDataReader dataReader, Int32 startRecord, Int32 maxRecords, System.Int32&
counter) [0x00011] in
/tmp/monobuild/build/BUILD/mono-1.9/mcs/class/System.Data/System.Data.Co
mmon/DataAdapter.cs:430  
  at System.Data.Common.DataAdapter.FillInternal (System.Data.DataTable
dataTable, IDataReader dataReader) [0x00030] in
/tmp/monobuild/build/BUILD/mono-1.9/mcs/class/System.Data/System.Data.Co
mmon/DataAdapter.cs:242  
  at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable,
IDataReader dataReader) [0x00000] in
/tmp/monobuild/build/BUILD/mono-1.9/mcs/class/System.Data/System.Data.Co
mmon/DbDataAdapter.cs:271  
  at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable,
IDbCommand command, CommandBehavior behavior) [0x00022] in
/tmp/monobuild/build/BUILD/mono-1.9/mcs/class/System.Data/System.Data.Co
mmon/DbDataAdapter.cs:284  
  at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable)
[0x00011] in
/tmp/monobuild/build/BUILD/mono-1.9/mcs/class/System.Data/System.Data.Co
mmon/DbDataAdapter.cs:256  
  at (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:Fill
(System.Data.DataTable)
  at TestSqlLite.MainClass.Main (System.String[] args) [0x0006d] in
/home/marcelo/TestSqlLite/TestSqlLite/Main.cs:32  


>>>>


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the QA contact for the bug.


More information about the mono-bugs mailing list