[Mono-bugs] [Bug 533916] New: Cannot query or create a FTS3 table in sqlite.

[bugzilla_noreply at novell.com]

http://bugzilla.novell.com/show_bug.cgi?id=533916


           Summary: Cannot query or create a FTS3 table in sqlite.
    Classification: Mono
           Product: Mono: Class Libraries
           Version: SVN
          Platform: i386
        OS/Version: Other
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Mono.Data.Sqlite
        AssignedTo: mhabersack at novell.com
        ReportedBy: demis.bellot at gmail.com
         QAContact: mono-bugs at lists.ximian.com
          Found By: ---


Created an attachment (id=314931)
 --> (http://bugzilla.novell.com/attachment.cgi?id=314931)
NET Console application with sqlite FTS3 bug

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.1.2)
Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729)

I have attached a .NET Console application that works in both mono and .NET on
windows. I have also included an sqlite3 lib with the following flags: 

CFLAGS="-Os -DSQLITE_ENABLE_FTS3=1 -DSQLITE_CORE=1
-DSQLITE_ENABLE_FTS3_PARENTHESIS=1"

I can create and query the FTS table using the compiled 'sqlite3' command-line
sql client.

The only time I get an exception is when running it on mono (built from latest
SVN) on CentOS:

Unhandled Exception: Mono.Data.Sqlite.SqliteException: Sqlite error
near "VIRTUAL": syntax error
  at Mono.Data.Sqlite.Sqlite3.Prepare (System.String strSql,
Mono.Data.Sqlite.SqliteStatement previous, System.String& strRemain) [0x00000] 
  at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x00000] 

Reproducible: Always

Steps to Reproduce:
1.
2.
3.
Actual Results:  
Unhandled Exception: Mono.Data.Sqlite.SqliteException: Sqlite error
near "VIRTUAL": syntax error
  at Mono.Data.Sqlite.Sqlite3.Prepare (System.String strSql,
Mono.Data.Sqlite.SqliteStatement previous, System.String& strRemain) [0x00000] 
  at Mono.Data.Sqlite.SqliteCommand.BuildNextCommand () [0x00000] 

Expected Results:  
Found 1 matching tracks

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