Repeating fields and brackets won't return any results

[Electric_Soul]

Hello

I need help understanding FQL. I thought I did

Please download my file for testing

 

Query

I highlighted all differences between the first and the other statements. The value "aha" is inside the second repetition of the field 'test::name'

 

Result of evaluation

 

Question

Why won't the SQL statement sql02 return anything. Looking at statement sql03, it looks like only the last statement inside the brackets is being evaluated. Looks like a BUG to me.

 

Thank you

Edited April 25, 2017 by Electric_Soul

[beverly]

This is a X-post on FM Community:

https://community.filemaker.com/message/658922

Please see all replies there before duplicating here.

While there may be people here that have answers different, it's important to let everyone know you have cross-posted to more than one forum.

Thanks!

[Electric_Soul]

I always do.

[Electric_Soul]

After one reply within the FM community forums, I decided to treat this like a bug and report it in the FM forums. Will see what comes out of this.

 

https://community.filemaker.com/message/659657#659657