SimpleDB 选择计数 (*) iPhone 不一致

发布于 2024-12-16 16:30:27 字数 603 浏览 1 评论 0原文

有人知道为什么这两个 AWS SimpleDB 表达式都有效吗？

selectRequestClassVariable.selectRequestExpressionString = [NSString stringWithFormat:@"select count(*) from %@",DomainName];

此外，第二个表达式可以工作，但在域周围有“”。根据 AWS 的说法，只有第一个应该有效。

selectRequestClassVariable.selectRequestExpressionString = [NSString stringWithFormat:@"select * from `%@` where Attribute > '%ld' limit 2500",DomainName,number];

一个是选择，另一个是选择计数(*)。有人遇到过这种不一致并且知道如何处理吗？需要明确的是，这两种表达方式都有效。根据 AWS 的说法，只有第一个应该。

我问这个问题是因为我需要一个返回超过 2500 的 select 计数 (*)。我读到 select 最多只返回 2500。

谢谢！

原文

Anyone know why both AWS SimpleDB expressions work?

selectRequestClassVariable.selectRequestExpressionString = [NSString stringWithFormat:@"select count(*) from %@",DomainName];

In addition, this second expression works, but has '' around the domain. According to AWS, only the first should work.

selectRequestClassVariable.selectRequestExpressionString = [NSString stringWithFormat:@"select * from `%@` where Attribute > '%ld' limit 2500",DomainName,number];

One is a select, the other is a select count(*). Anyone run into this inconsistency and know how to deal with it? Just to be clear, both expressions shown work. According to AWS only the first should.

I ask because I need a select count (*) that returns more than 2500. I've read that select only returns a max of 2500.

Thanks!

分享到QQ

分享到微博