ISCHILDNODE and ISDESCENDANTNODE not working with %(wildcard)

[oste]

I am trying to leverage ISCHILDNODE with a % wildcard using the Query Builder. I am constructing my query like this

$qb->from()->document('AppBundle\Document', 'd');
//$qb->where()->descendant('/my/%/posts', 'd');
$qb->where()->child('/my/%/posts', 'd');

This gives me a SQL-2 query that looks like this SELECT * FROM [nt:unstructured] AS d WHERE (ISCHILDNODE(d, [/my/%/posts]) Unfortunately this is not working :(

It is worth noting that ISDESCENDANTNODE works as expected SELECT * FROM [nt:unstructured] AS d WHERE (ISDESCENDANTNODE(d, [/my/%/posts])

@dantleech was able to confirm that neither of these work with Jackrabbit in #symfony-cmf irc chat. However they should

[dbu]

this sounds strange. a first step to solve this would be to add such queries to https://github.com/phpcr/phpcr-api-tests/blob/master/tests/06_Query/QuerySql2OperationsTest.php and do a pull request with those. then we can investigate what actually goes on. do you want to do that @oste ?

[oste]

Thanks @dbu, I will try to find some time this week to get that pull request started.