search

Rupesh029 / typica

Automatically exported from code.google.com/p/typica
Apache License 2.0
0 stars 0 forks source link

Query is not returing correct results #31

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Its hard to say the exact cause of the problem, but basically i am getting 
all sorts of funny behavior with results when i use 
listItemsWithAttributes() (and it may also be related to the other query 
commands as well i haven't verified)

The max results field seems to change the output as well. When it is set 
below the number of results that will be returned i get a good inital list 
and the token to continue.  however when i use the continuation token i 
seem to be getting more (still not all) of the results but duplicate 
results. I will try my best to explain a way to reproduce it.  but there is 
more going on than what i can mention. I can confirm that the results from 
the java T-437 app are different.

Domain: accounts
<displayname> <username> 
a            aasdf
a            aaa
aaaaa        aaaaa
test         afdasdf
a            a
a            boschb4
aaaa         aaaa

What is the expected output? What do you see instead?
I wont mention the expected output because its obvious, but here are some 
scenarios i ran...

['username' starts-with 'a'] maxresults: 10 yields: 
<a,a> 
<aaaa,aaaa> 
<aaaaa,aaaaa> 
<test,afdasdf>

['username' starts-with 'a'] union ['displayname' starts-with 'a']
maxresults: 4 yields: 
<a,a> 
<aaaa,aaaa> 
<aaaaa,aaaaa>
+ CONT TOKEN
<a,a>
<test,afdasdf> 
+ CONT TOKEN
<a, aasdf>
<aaaa,aaaa>
<aaaaa,aaaaa>

['username' starts-with 'a']
maxresults: 3 yields: 
<a,a>
<aaaa,aaaa>
+CONT TOKEN
<a,aasdf>
<aaaaa,aaaaa>
<test,afdasdf>

['username' starts-with 'a'] union ['displayname' starts-with 'a']
maxresults: 3 yields: 
<a,a> 
<aaaa,aaaa> 
+ CONT TOKEN
<a,aasdf>
<aaaaa,aaaaa>
<test,afdasdf> 
+ CONT TOKEN
<a, a>
+ CONT TOKEN
<a,aasdf>
<aaaa,aaaa>
<aaaaa,aaaaa>

What version of the product are you using? On what operating system?
1.4.1 with Java 6 (x86) on Flex Builder(Eclipse 3.3 x86) on Vista x64

Hope this is enough to start on.

Original issue reported on code.google.com by bos...@gmail.com on 22 Oct 2008 at 9:06

GoogleCodeExporter commented 9 years ago 
thread on amazon:
http://developer.amazonwebservices.com/connect/thread.jspa?threadID=25918&tstart
=0

Original comment by bos...@gmail.com on 1 Nov 2008 at 8:55

GoogleCodeExporter commented 9 years ago 
I haven't had a chance to try this. Are we sure this is an SimpleDB problem 
now, vs
in typica?

Original comment by dkavan...@gmail.com on 5 Nov 2008 at 4:13

GoogleCodeExporter commented 9 years ago 
From what I understand, typica doesn't really do any processing, it just passes
forward what it receives.  Given that, there is always the possibility of it 
being in
either place, hard to tell.  I was hoping someone else had experienced the same
problem actually.

Original comment by bos...@gmail.com on 5 Nov 2008 at 4:21

GoogleCodeExporter commented 9 years ago 
OK i just tested this using the scratchpad (Amazon recommended i try that first)
(nice tool btw) and the results I got back there are correct.  The problem 
would now
appear to be related to Typica.

if you would like to access my domain to further evaluate the problem, please 
send me
a private message and i can give you my keys.

Thanks,
Bobby

Original comment by bos...@gmail.com on 5 Nov 2008 at 4:44

GoogleCodeExporter commented 9 years ago 
I just tested with this dataset (using 1-7 as item ids). I set max results to 3 
and get 12 results back (obviously 
with repeats). I'll debug this.

Original comment by dkavan...@gmail.com on 3 Feb 2009 at 3:04

GoogleCodeExporter commented 9 years ago 
I think this answers the question;
http://developer.amazonwebservices.com/connect/thread.jspa?messageID=111108𛈄

No the answer I hoped for either, I'm afraid.. Maybe you weren't able to set 
the max results on the scratchpad?

Original comment by dkavan...@gmail.com on 3 Feb 2009 at 3:16