gistfile1.txt

mysql> select assetIndex.assetId, assetIndex.title, assetIndex.url,
    -> assetIndex.synopsis, assetIndex.ownerUserId, assetIndex.groupIdView,
    -> assetIndex.groupIdEdit, assetIndex.creationDate, assetIndex.revisionDate,
    -> assetIndex.className, match (keywords) against ('+following-following*') as
    -> score from assetIndex
    -> where
    ->    -- isPublic = 1 and
    -> ((match (keywords) against ('+following-following*' in boolean mode))
    -> -- and (lineage like '000001000002%')
    -> and (className='WebGUI::Asset' or className='WebGUI::Asset::Event' or
    -> className='WebGUI::Asset::File' or className='WebGUI::Asset::File::Image' or
    -> className='WebGUI::Asset::Post' or className='WebGUI::Asset::Post::Thread' or
    -> className='WebGUI::Asset::RichEdit' or
    -> className='WebGUI::Asset::RSSFromParent' or className='WebGUI::Asset::Snippet'
    -> or className='WebGUI::Asset::Template' or
    -> className='WebGUI::Asset::Wobject::Article' or
    -> className='WebGUI::Asset::Wobject::Calendar' or
    -> className='WebGUI::Asset::Wobject::Collaboration' or
    -> className='WebGUI::Asset::Wobject::DataForm' or
    -> className='WebGUI::Asset::Wobject::Folder' or
    -> className='WebGUI::Asset::Wobject::MessageBoard' or
    -> className='WebGUI::Asset::Wobject::Navigation' or
    -> className='WebGUI::Asset::Wobject::SyndicatedContent' or
    -> className='WebGUI::Asset::Wobject::Thingy'))
    -> order by score
    -> ;


mysql> select assetIndex.assetId, assetIndex.title, assetIndex.url,
    -> assetIndex.synopsis, assetIndex.ownerUserId, assetIndex.groupIdView,
    -> assetIndex.groupIdEdit, assetIndex.creationDate, assetIndex.revisionDate,
    -> assetIndex.className, match (keywords) against ('+following-following*') as
    -> score from assetIndex
    -> where
    ->    -- isPublic = 1 and
    -> ((match (keywords) against ('+following-following*' in boolean mode))
    -> );
Empty set (0.01 sec)

mysql> select count(*) from snippet where snippet like '%following-following%';                                                                                                                                   +----------+
| count(*) |
+----------+
|        1 |
+----------+

mysql> select assetId from assetIndex where match (keywords) against ('+following-following*' in boolean mode);
Empty set (0.00 sec)

mysql> select count(*) from assetIndex where keywords like '%following-following%';
+----------+
| count(*) |
+----------+
|        1 |
+----------+
1 row in set (0.06 sec)

select isPublic from assetIndex where match (keywords) against ('+following*' in boolean mode);
Empty set (0.00 sec)

mysql> select isPublic from assetIndex where match (keywords) against ('following' in boolean mode);
Empty set (0.00 sec)