[Mono-bugs] [Bug 470042] New: Mono.Data.Sqlite is unable to create custom functions and collations

[bugzilla_noreply at novell.com]

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


           Summary: Mono.Data.Sqlite is unable to create custom functions
                    and collations
    Classification: Mono
           Product: Mono: Class Libraries
           Version: SVN
          Platform: x86
        OS/Version: Ubuntu
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Mono.Data.Sqlite
        AssignedTo: mhabersack at novell.com
        ReportedBy: jmillikin at gmail.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: ---


Merely trying to open a database connection with custom functions defined
raises an exception from Mono.Data.Sqlite.Sqlite3.CreateFunction(). Based on
the SQLite documentation for custom functions[1] and collations[2], the
definitions of dll-imported functions in UnsafeNativeMethods.cs include
incorrect and nonexistent functions. Among the errors:

* The declarations `sqlite3_create_collation()` and `_create_function()` do not
match the SQLite C API functions.
* `sqlite3_function_free_callbackcookie()` does not exist.
* `SQLite3.CreateFunction()` and `CreateCollation()` do some strange voodoo
with callback cookies for freeing functions, rather than using the `_v2()`
versions of the above functions.

[1] http://www.sqlite.org/c3ref/create_function.html
[2] http://www.sqlite.org/c3ref/create_collation.html

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