错误 #25127
报警批注—查询报警批注—报警批注id存在的情况下查询结果为空
0%
描述
接口路径: /dmp-alarm/alarm/comment/query?userId=c2e9e49079f24ef78da248d3bfc04bec&groupCode=apiauto&projectId=Pj6120000001
header:
header:{
"Content-Type":"application/json;charset=utf-8"
}
入参:
{
"criteria": {
"recordId": "de115fb2-2afe-4d26-941e-910e20ea5039",
"content": "我是批注内容",
"id": "0bb4b356-423b-405b-9d72-b04730a49da0"
},
"page": 1,
"size": 20,
"orders": [
{
"column": "recordId",
"asc": true
}
],
"onlyCount": false
}
响应:
{
"result": "success",
"message": null,
"data": [
], "count": "0"
}
期望值:success
实际值:success
业务精准断言结果:【Pass】
模糊断言期望包含值:"id":"
业务模糊断言结果:【false】
替换后的sql:{"select count(*) from dmp_alarm.alarm_comment where group_code='apiauto' and project_id='Pj6120000001' and valid='1' and record_id='de115fb2-2afe-4d26-941e-910e20ea5039' and id='0bb4b356-423b-405b-9d72-b04730a49da0'":"$.count"}
sql断言数据库查询结果:1
sql断言响应报文验证结果:0
sql断言结果:【Fail】
预期结果:
sql断言成功,能正确查询到指定的批注信息
实际结果:
sql断言失败,查询id结果为空
文件