嵌套逻辑运算符的JPA NamedQueries问题

Question

SELECT * FROM customer c
WHERE (c.is_customer = true) OR (c.is_customer = false AND c.activation_date >  CURRENT_DATE + INTERVAL '3.5 years');

@NamedQuery(name = CustomerBE.NAMED_QUERY,
                query = "SELECT c FROM CustomerBE c "
                       + "WHERE (c.isCustomer= true) OR (c.isCustomer= false AND c.activationDate > CURRENT_DATE + INTERVAL '3.5 years')"
)

Exception Description: Syntax error parsing [SELECT c FROM CustomerBE c WHERE (c.isCustomer= true) OR (c.isCustomer= false AND c.activationDate > CURRENT_DATE + INTERVAL '3.5 years']. 
[41, 297] The expression is not a valid conditional expression.
[297, 298] The query contains a malformed ending

Answer 1

您可能需要在WHERE子句前加一个空格，否则您的字符串将不是有效的JPQL：

“从CustomerBE cWHERE(c.iscustomer=true)O中选择c...”

我不确定这是不是你报告的问题，但这也是一个需要修复的问题。