JPA 2 Query Returning Incomplete Results

The following query is only matching the first value found in the select subquery, even though there are match for all values `SELECT p FROM Profile p WHERE p.id IN (SELECT u.group FROM User u WHERE u.id = ?1)` The subquery returns a comma separated list like: `1,2,3`. The query should return matches for all three subquery select results. Anyone know what could be wrong? Thanks.
Can you show the table structure? It seems like User.id should be your primary key. Your subquery is filtering on that, so it would seem you would only get one result.

以上就是JPA 2 Query Returning Incomplete Results的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » JavaScript 答疑

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏