Hi!
I have made a Contentless FTS4 Table like:
"CREATE VIRTUAL TABLE if not exists OCR USING fts4(content="", `FullOCR`
varchar;"
And managed to insert some data into it.
I have 2 questions:
1.) How to get the proper COUNT on the table ?
The only query seems to work is:
"SELECT COUNT(*) FROM OCR_docsize;" is this the right way to do it ?
2.) How to perform a "JOIN" operation with it?
"SELECT docid FROM OCR WHERE FullOCR MATCH 'framework';" result is "2".
"SELECT * FROM ART INNER JOIN OCR ON ART.ID = (SELECT docid FROM OCR WHERE
FullOCR MATCH 'framework') ORDER BY ID;"
Gives "SQL logic error or missing database:"
"SELECT * FROM ART INNER JOIN OCR_docsize ON ART.ID = (SELECT docid FROM
OCR WHERE FullOCR MATCH 'framework') ORDER BY ID;"
Gives me 9 results back - should be only 1 -
"SELECT * FROM ART NATURAL JOIN (SELECT docid FROM OCR WHERE FullOCR MATCH
'framework') ORDER BY ID;"
Gives me 9 results back - should be only 1 -
What I am missing here?
Any idea?
Thanks,
Marta
