search

longde123 / csharp-sqlite

Automatically exported from code.google.com/p/csharp-sqlite
Other
0 stars 0 forks source link

Virtual Table Support #171

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
This is just an issue to note that there doesn't seem to be any Virtual Table 
support - or at least it seems to not work for me.

The create runs:
  CREATE VIRTUAL TABLE [SimpleTable] USING FTS3 (
    [Id] integer NOT NULL,
    [Name] text ,
    [BigInt] bigint NOT NULL,
    [IsWorking] integer NOT NULL
  );

the select fails:
  SELECT COUNT(*) FROM [SimpleTable];

with an error:
  SQLite error
  no such table: SimpleTable

Should virtual tables work?

Original issue reported on code.google.com by mattleib...@gmail.com on 27 Oct 2012 at 6:51

GoogleCodeExporter commented 9 years ago 
FTS is not currently supported

Original comment by noah.hart@gmail.com on 29 Oct 2012 at 7:36