Inconsistent query result

[kongo09]

I'm currently observing something strange and so far I haven't really
understood why this would happen at all:

Using the following query:

SELECT aid, owner, cover_pid, created, name, description, size, type
FROM album WHERE owner IN (SELECT uid2 FROM friend WHERE uid1 = me())
OR owner = me() LIMIT 2

I select the first two albums of my friends (or myself). Calling this
via batchfb gives me two different albums compared to calling this
directly in the browser manually. Yes, I use the same token for both.

You might say this is coincidence due to the LIMIT 2, but it is not.
Going to a limit of 2000 I get less entries than the limit in both
calls. They come in the same order in both calls. But batchfb doesn't
show the first entry. Limiting to 2 entries, the first of batchfb is
the second entry in the manual call.

However, it cannot really be batchfb loosing the entry because I get 2
entries nevertheless! The second entry by batchfb would have been the
third in a manual call. Somehow, Facebook FQL is not delivering the
first entry when called via batchfb.

No clue what this is. A side effect from the batching? Anyone any idea
where to digg?

[Jeff Schnitzer]

This is really quite strange. I will investigate.

Jeff

[Jeff Schnitzer]

I am unable to reproduce this. That query produces 3560 albums for me
both when I issue the (single) query by hand and when I issue the
query through batchfb.

Are you using the latest version of BatchFB? Not that I expect this
to matter, but it's the first thing I would check.

Looks like a Facebook issue of some sort.

Jeff

[kongo09]

I know it doesn't make any sense. Yes, I'm running the latest batchfb.

I'll try to put together a minimum example as soon as I find the time.

kongo09

On Oct 12, 2:53 am, Jeff Schnitzer <j...@infohazard.org> wrote:
> I am unable to reproduce this.  That query produces 3560 albums for me
> both when I issue the (single) query by hand and when I issue the
> query through batchfb.
>
> Are you using the latest version of BatchFB?  Not that I expect this
> to matter, but it's the first thing I would check.
>
> Looks like a Facebook issue of some sort.
>
> Jeff
>
>
>
>
>
>
>
> On Tue, Oct 11, 2011 at 5:05 PM, Jeff Schnitzer <j...@infohazard.org> wrote:
> > This is really quite strange.  I will investigate.
>
> > Jeff
>

[Jeff Schnitzer]

Try running the test cases. This case should cover your exact query:

http://code.google.com/p/batchfb/source/browse/trunk/src-test/com/googlecode/batchfb/test/QueryResultSizeTests.java

It passes for me using my access token.

To run the tests:

1) checkout the source
2) make sure you have the TestNG eclipse plugin installed
3) create a TestNG run configuration
4) add -DaccessToken=YOURTOKEN to the VM arguments
you can get a token here:
https://developers.facebook.com/tools/access_token/

Try this with your token. I wonder if there isn't some sort of
strange oddity WRT permissions inside FB, specific to your account.

Jeff