4 messages in com.googlegroups.google-gearsRe: [google-gears] Field specified fu...
FromSent OnAttachments
Shumpei Shiraishi26 Sep 2007 00:19 
Scott Hess26 Sep 2007 09:32 
Scott Hess26 Sep 2007 12:56 
Shumpei Shiraishi26 Sep 2007 14:34 
Subject:Re: [google-gears] Field specified full text query doesn't work?
From:Scott Hess (sh.@google.com)
Date:09/26/2007 12:56:07 PM
List:com.googlegroups.google-gears

OK, this is a bug in the interaction between table creation and tokenization and case-sensitive handling of each. In this case, the table was created using uppercase TITLE, and you're using TITLE: in the query, but the tokenizer is lower-casing things, and "TITLE" != "title", so it doesn't work.

The short-term workaround would be to use lowercase in the table creation. Things will still be case-insensitive anywhere where you're referring to the field at the SQL level, so you only need to change the create statement.

-scott

http://code.google.com/p/google-gears/issues/detail?id=251 http://www.sqlite.org/cvstrac/tktview?tn=2671

On 9/26/07, Scott Hess <sh.@google.com> wrote:

Shumpei,

It looks to me like something is all borken, here. I'll look into it this morning.

The "title MATCH 'gears'" approach still seems to work, but that's very limiting.

-scott

On 9/26/07, Shumpei Shiraishi <shum@gmail.com> wrote:

Hi,

I try Gear's full text search capability, but I can't understand how the field specified query work.

For example, there is BOOK table which contains 2 columns.

ROWID TITLE DESCRIPTION

------------------------------------------------ 1 Offline Apps Google Gears, AIR, ... 2 Google Gears Gears reference

and I try to search from this table by following query.

SELECT TITLE, DESCRIPTION FROM BOOK WHERE BOOK MATCH = ?

"offline" -> return row 1, OK. "gears" -> return all rows, OK. "gears -air" -> return row 2, OK. "TITLE:gears" -> return no row, Why???? (expected:return row 2)

Do I have something wrong ? Or in fact, is this query syntax not supported?