@Test
@FixFor( "MODE-2220" )
public void shouldSupportLowerCaseOperand() throws Exception {

    Node nodeA = session.getRootNode().addNode("A");
    nodeA.setProperty("something", "SOME UPPERCASE TEXT");
    session.save();
    try {
        String sql = "SELECT [jcr:path] FROM [nt:unstructured] AS node WHERE LOWER(node.something) LIKE '%uppercase%'";
        Query query = session.getWorkspace().getQueryManager().createQuery(sql, Query.JCR_SQL2);
        NodeIterator nodes = query.execute().getNodes();
        assertEquals(1, nodes.getSize());
        assertEquals("/A", nodes.nextNode().getPath());
    } finally {
        nodeA.remove();
        session.save();
    }
}