Simple query not working on property?

[alex-barylski]

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?

[dbu]

i fear that you run into an old bug that we never really sorted out: phpcr/phpcr-utils#104

if you have some time to investigate that stale pull request that would be awesome!