Text search (LIKE) not working

So far, CB4 and N1QL have been pretty great.
However, for the life of me I cannot get LIKE to work properly.

I’ve created a primary index, as well as an index specifically on the text field needed as additional effort.

SELECT blah FROM bucket WHERE content LIKE '%the%';

The query does not fail, however it always returns an empty result set. Manually checking, there are definitely documents that should match.
Checking the cheat sheet shows an example of text search, so I am assuming this functionality should currently exist.

Any direction is appreciated.

Just for completeness, which version are you running?