FQL Bug：如果 IN 部分返回空，则 SELECT-WHERE-IN 查询会出错！
我正在尝试运行以下 FQL：
SELECT user_id FROM like WHERE object_id IN (SELECT object_id FROM album WHERE owner = me())
但是，这给出了错误：
error_code":604,"error_msg":"您的 语句不可索引。哪里 子句必须包含可索引的 柱子。此类列标有 * 在链接自的表格中 http://developers.facebook.com/docs/reference/fql
两个查询都使用可索引列！经过一些调试，我找到了 IN 部分。基本上，如果 IN 查询返回空（在本例中为“SELECT object_id FROM album WHERE Owner = me()”），您会收到此错误吗？而且，显然有些用户没有专辑！
基本上，整个查询应该不返回结果？？？
这不是一个明显的bug吗？
谢谢。
I am trying to run the following FQL:
SELECT user_id FROM like WHERE object_id IN (SELECT object_id FROM album WHERE owner = me())
But, this gives the error:
error_code":604,"error_msg":"Your
statement is not indexable. The WHERE
clause must contain an indexable
column. Such columns are marked with *
in the tables linked from
http:\/\/developers.facebook.com\/docs\/reference\/fql
Both queries are using indexable columns! And, after some debugging, I traced down the IN part. Basically, if the IN query returns empty (in this case "SELECT object_id FROM album WHERE owner = me()"), you get this error? And, obviously there are some users who don't have an album!
Basically, this whole query should return no result????
Isn't this an obvious bug?
Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
该查询对我来说工作得很好，一个应用程序具有
user_likes权限并返回结果，而另一个没有权限的应用程序返回空结果集。尝试使用不同的应用程序在此处进行查询（如果您设置了多个应用程序） ），如果问题仍然存在，请提交错误！
The query is working just fine for me, one application has the
user_likespermission and it's returning results and another one with no permissions is returning an empty result set.Try the query here with different Applications (if you have setup multiple apps) and if the problem persists file a bug!