database - 错误 4.5 Expression must be a group key or aggregate

Question

升级到 Couchbase 4.5 后，我开始收到此错误“表达式必须是组键或聚合(write。timestamp)”，“code”:4210} .我在这里做错了什么？这是我的查询

选择 max(timestamp) 作为 lastDetect，count(timestamp) 作为 detectCount
从写
其中不缺少 docType AND docType = 'DetectRecord' AND proximityUUID = $uuid AND major = $major AND minor = $minor AND timestamp BETWEEN $startTime AND $endTime ORDER BY timestamp desc limit 1;

示例文档:

{
“编号”:“1234k”，
"docType": "检测记录",
"proximityUUID": "12kdf",
“主要”:“dkf”，
“小”:“广告”，
“时间戳”:1464954200000
}

Answer 1

是的，Marquis，N1QL 在 4.5 中强制执行正确的 GROUP BY 语法/语义。发行说明“行为更改”中提到了这一点:http://developer.couchbase.com/documentation/server/4.5/release-notes/relnotes.html