[Sorry for the long lag time on this response.] On Sat, Jan 5, 2008 at 6:35 PM, Gavin <[EMAIL PROTECTED]> wrote: > I am using FTS3 for table Positions_Text. However I am getting an > error 'unable to use function MATCH in the requested context' when > using: > > SELECT DISTINCT [Positions].[PosID] FROM [Categories], [Positions] JOIN > [Positions_Text] ON [Positions].[PosID] = [Positions_Text].[rowid] WHERE > [Description] MATCH 'test' AND [Categories].[PosID] = > [Positions].[PosID] AND > [Categories].[CatID] = '1' > > If I use > > SELECT DISTINCT [Positions].[PosID] FROM [Categories], [Positions] JOIN > [Positions_Text] ON [Positions].[PosID] = [Positions_Text].[rowid] WHERE > [Description] MATCH 'test' AND [Categories].[CatID] = '1' > > removing section: AND [Categories].[PosID] = [Positions].[PosID] > > the query works. Anyone know what the problem is?
I don't see anything obvious. My best guess would be that somehow the different queries are being processed differently due to some decision on the part of the query optimizer, but I can't offhand say why that should matter. Would it be possible to put together .dump output which can be used to replicate the problem? If you don't want to post that to a public list, feel free to contact me directly. Thanks, scott ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
