大小写语法错误

Question

我的查询:

SELECT
CASE WHEN COUNT(o) > 0 THEN true ELSE false
FROM orders o
left join shop_order so on o.id=so.order_id
left join order_details od on so.id=od.shop_order_id
left join offers of on od.offer_id=of.id
WHERE of.offer_type_id=1
and of.type=2
and o.customer_id = ?1
and od.varient_id=?2

错误是:

你有一个错误的SQL语法;查看与您的MariaDB服务器版本对应的手册，以获取在"FROM orders o left join shop_order so on o.d id=so"附近使用的正确语法。Order_id left join order_det

Answer 1

case缺少end关键字。在FROM之前插入END:

SELECT
CASE WHEN COUNT(o) > 0 THEN true ELSE false END
FROM ...

MySQL的错误信息说" near "，但他们真正的意思是" right before "