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 09:32:34 AM
List:com.googlegroups.google-gears

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?