@FixFor( "MODE-1840" )
@Test
public void shouldBeAbleToCreateAndExecuteJcrSql2QueryWithBindVariableInsideContains() throws RepositoryException {

    String sql = "select [jcr:path] from [nt:unstructured] as n where contains(n.something, $expression)";
    Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
    query.bindValue("expression", session.getValueFactory().createValue("cat wearing"));
    QueryResult result = query.execute();
    validateQuery().rowCount(1).hasColumns("jcr:path").hasNodesAtPaths("/Other/NodeA[2]").validate(query, result);
}