Simple query not working on property? #338
Description
I apologize if the issue is trivial - but I cannot seem to figure out why this is happening.
// THIS DOESN'T WORK?!?!
$sql = "SELECT * FROM [nt:unstructured] WHERE [nt:unstructured].[path] = '/index.html'";
// THIS WORKS FINE
//$sql = "SELECT * FROM [nt:unstructured] WHERE [nt:unstructured].[path] = '/work'";
$query = $queryManager->createQuery($sql, 'JCR-SQL2');
Here is the XML I am using to initialize PHPCR:
<cms xmlns:jcr="http://www.jcp.org/jcr/1.0" xmlns:nt="http://www.jcp.org/jcr/nt/1.0">
<routes>
<index path="/" slug="cms/types/pages" />
<alias path="/index.html" slug="cms/types/pages" />
<work path="/test" slug="http://test.com" />
</routes>
</cms>
What am I doing wrong?