SdbNavigator icon indicating copy to clipboard operation
SdbNavigator copied to clipboard

Interpretation of NextToken?

Open gravelld opened this issue 10 years ago • 3 comments

Just wondering if SdbNavigator interprets NextToken correctly?

I ask because if I run:

select count(*) from `My-Domain`

I get different results each time I run. The domain has about 5m items in, so in a normal SDB select query this would return NextToken as it tots up the result.

gravelld avatar Jul 15 '14 16:07 gravelld

Yes, i think it does ;-) You may open the "Developer Tools > Network" in chrome and see the actual call being made and how the NextToken is processed and passed between requests.

Reggino avatar Jul 15 '14 16:07 Reggino

To be more precise: It should work, however i do not have a data-set a big as yours to confirm this.

By looking at the query via the developer tools you may confirm that the actual query performed should be correct.

If you experience any issues, please let me know.

Reggino avatar Jul 15 '14 16:07 Reggino

Yes, I think I can see the calls being made correctly. However the end result is incorrect. Given n calls using NextToken, it gives only the final result in the nth call. In this case, around '300000'.

Now, when you use the CLI you have to then sum all the results together, because this is a count(*) call.

Maybe the UI doesn't have the logic to sum all the results? It is logic specific to count(*).

gravelld avatar Jul 15 '14 16:07 gravelld