[
https://issues.apache.org/jira/browse/OAK-3561?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jessie updated OAK-3561:
------------------------
Description:
When working with Oak 1.2.7, I find the following query shows 0 result
(Jackrabbit 2.10 outputs the correct rows).
"SELECT case.[jcr:uuid] as uuid FROM [xx.Patient] as patient INNER JOIN
[xx:Case] as case ON patient.[jcr:uuid] = case.[patient] WHERE patient.[name]
LIKE 'someone%'
case.[patient] is defined as weakreference type, representing patient
I just wonder whether it is a bug or such query should be expressed in another
way in OAK?
Thank you very much!
was:
When working with Oak 1.2.7, I find the following query shows 0 result
(Jackrabbit 2.10 outputs the correct rows).
"SELECT case.[jcr:uuid] as uuid FROM [xx.Patient] as patient INNER JOIN
[xx:Case] as case ON patient.[jcr:uuid] = case.[patient] WHERE patient.[name] =
'someone%'
case.[patient] is defined as weakreference type, representing patient
I just wonder whether it is a bug or such query should be expressed in another
way in OAK?
Thank you very much!
> Query Constraints of "reference" property
> -----------------------------------------
>
> Key: OAK-3561
> URL: https://issues.apache.org/jira/browse/OAK-3561
> Project: Jackrabbit Oak
> Issue Type: Bug
> Components: query
> Affects Versions: 1.2.7
> Environment: Java 1.8.0_11 with Mongodb 3.0.6 on Windows 7
> Reporter: Jessie
>
> When working with Oak 1.2.7, I find the following query shows 0 result
> (Jackrabbit 2.10 outputs the correct rows).
> "SELECT case.[jcr:uuid] as uuid FROM [xx.Patient] as patient INNER JOIN
> [xx:Case] as case ON patient.[jcr:uuid] = case.[patient] WHERE patient.[name]
> LIKE 'someone%'
> case.[patient] is defined as weakreference type, representing patient
> I just wonder whether it is a bug or such query should be expressed in
> another way in OAK?
> Thank you very much!
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
