System.Data.SQLite
Ticket Change Details
Not logged in
Overview

Artifact ID: f1aa7374c96aaccc948e8f2e86ebc4d260bcc073
Ticket: b0778fcc041fdca4a8e0b477351b074d48bc6494
AccessViolationException on ExecuteReader
User & Date: anonymous 2019-02-03 18:13:12
Changes

  1. Change foundin to "1.0.109.2"
  2. Change icomment to:
    1. create table with command:
    
    CREATE TABLE "t_LacCell_txt_cd3fbc38d1484699afbd8f9febc3fa58" ("analysis_result_id" integer primary key autoincrement, "Lac" text, "Cell" text);
    
    2. create index with command:
    
    CREATE INDEX "t_LacCell_txt_cd3fbc38d1484699afbd8f9febc3fa58_Lac_Cell__lower" on "t_LacCell_txt_cd3fbc38d1484699afbd8f9febc3fa58" (lower("Lac"), lower("Cell"))
    
    3. select
        SQLiteConnectionStringBuilder connectionStringBuilder = new SQLiteConnectionStringBuilder()
        {
            DataSource = @"test.sqlite"
        };
    
        SQLiteConnection connection = new SQLiteConnection(connectionStringBuilder.ConnectionString);
        connection.Open();
    
        SQLiteCommand command = connection.CreateCommand();
        command.CommandText = @"
                select * 
                from (""t_LacCell_txt_cd3fbc38d1484699afbd8f9febc3fa58"") 
                where 
                    (lower(""Lac"") is null and 10002 is null or lower(""Lac"") = 10002) 
                    and 
                    (lower(""Cell"") is null and 6378 is null or lower(""Cell"") = 6378);";
    
        using (SQLiteDataReader reader = command.ExecuteReader())
        {
    
        }
                
    4. AccessViolationException on command.ExecuteReader
    
    Exception thrown: read access violation.
    p was nullptr.
    
    call stack:
        SQLite.Interop.dll!sqlite3VdbeCursorMoveto(VdbeCursor * * pp, int * piCol) Line 78081	C
        SQLite.Interop.dll!sqlite3VdbeExec(Vdbe * p) Line 84375	C
        SQLite.Interop.dll!sqlite3Step(Vdbe * p) Line 80303	C
        SQLite.Interop.dll!sqlite3_step(sqlite3_stmt * pStmt) Line 80366	C
        [Managed to Native Transition]	
        System.Data.SQLite.dll!System.Data.SQLite.SQLite3.Step(System.Data.SQLite.SQLiteStatement stmt) Line 1142	C#
        System.Data.SQLite.dll!System.Data.SQLite.SQLiteDataReader.NextResult() Line 1924	C#
        System.Data.SQLite.dll!System.Data.SQLite.SQLiteDataReader.SQLiteDataReader(System.Data.SQLite.SQLiteCommand cmd, System.Data.CommandBehavior behave) Line 124	C#
        System.Data.SQLite.dll!System.Data.SQLite.SQLiteCommand.ExecuteReader(System.Data.CommandBehavior behavior) Line 943	C#
        ConsoleApp4.exe!ConsoleApp4.Program.Main(string[] args) Line 33	C#
        [Native to Managed Transition]	
        mscoreei.dll!00007ff955c17b2d()	Unknown
        mscoree.dll!00007ff955cba57c()	Unknown
        kernel32.dll!00007ff9865f81f4()	Unknown
        ntdll.dll!00007ff986c6a251()	Unknown
    
  3. Change login to "anonymous"
  4. Change mimetype to "text/plain"
  5. Change private_contact to "68c66c2c5181de47674086a5d3f803fbc50b48c6"
  6. Change severity to "Important"
  7. Change status to "Open"
  8. Change title to "AccessViolationException on ExecuteReader"
  9. Change type to "Incident"