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: [email protected]
ReportedBy: [email protected]
QAContact: [email protected]
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.
_______________________________________________
mono-bugs maillist - [email protected]
http://lists.ximian.com/mailman/listinfo/mono-bugs
