DynamoDB查询调整日期范围上限后返回空结果的问题求助

大家好，我遇到了一个DynamoDB查询的奇怪问题，希望能得到大家的帮助：

我在名为HISTORICO-teste的表中有这样一条记录：

id,"data_dia","nome_completo","nome_produto","nome_tuna","numero_socio","preco_quantidade","quantidade","tipo","valor_conta","valor_pagamento"
compra_pagamento,"2024-11-09T01:26:57.748Z","","chupa chups","joker","177","0.4","1","compra","'-0.40","null"

当我使用以下查询代码时，能够正常返回这条记录：

const params = {
  TableName: 'HISTORICO-teste',
  KeyConditionExpression: 'id = :id AND data_dia BETWEEN :data_inicial AND :data_final',
  ScanIndexForward: false,
  FilterExpression: '#nome_tuna = :nome_tuna',
  ExpressionAttributeNames: { '#nome_tuna': 'nome_tuna' },
  ExpressionAttributeValues: {
    ':data_inicial': '2024-08-07T00:00:00.000Z',
    ':data_final': '2025-07-08T23:59:59.999Z',
    ':nome_tuna': 'joker',
    ':id': 'compra_pagamento'
  }
}

await dynamo.query(params).then(result => {
  console.log(result.Items);
});

对应的查询日志返回了正确结果：

START RequestId: 8a743c09-4f50-44d3-bbac-6e0bdfcebf5b Version: $LATEST
2025-07-16T15:28:10.330Z 8a743c09-4f50-44d3-bbac-6e0bdfcebf5b INFO 2024-08-07T00:00:00.000Z
2025-07-16T15:28:10.330Z 8a743c09-4f50-44d3-bbac-6e0bdfcebf5b INFO 2025-07-08T23:59:59.999Z
2025-07-16T15:28:10.430Z 8a743c09-4f50-44d3-bbac-6e0bdfcebf5b INFO [
  {
    nome_produto: 'chupa chups',
    tipo: 'compra',
    data_dia: '2024-11-09T01:26:57.748Z',
    valor_pagamento: null,
    valor_conta: '-0.40',
    numero_socio: 177,
    quantidade: 1,
    id: 'compra_pagamento',
    nome_tuna: 'joker',
    nome_completo: '',
    preco_quantidade: 0.4
  }
]
END RequestId: 8a743c09-4f50-44d3-bbac-6e0bdfcebf5b
REPORT RequestId: 8a743c09-4f50-44d3-bbac-6e0bdfcebf5b Duration: 111.26 ms Billed Duration: 112 ms Memory Size: 2000 MB Max Memory Used: 91 MB Init Duration: 382.70 ms

但是，当我把查询参数中的:data_final值从2025-07-08T23:59:59.999Z修改为2025-07-09T23:59:59.999Z后，查询就返回空数组了，对应的日志如下：

START RequestId: 845c6a5e-379d-432e-99db-340bc912bec0 Version: $LATEST
2025-07-16T15:30:25.621Z 845c6a5e-379d-432e-99db-340bc912bec0 INFO 2024-08-07T00:00:00.000Z
2025-07-16T15:30:25.622Z 845c6a5e-379d-432e-99db-340bc912bec0 INFO 2025-07-09T23:59:59.999Z
2025-07-16T15:30:25.721Z 845c6a5e-379d-432e-99db-340bc912bec0 INFO []
END RequestId: 845c6a5e-379d-432e-99db-340bc912bec0
REPORT RequestId: 845c6a5e-379d-432e-99db-340bc912bec0 Duration: 109.04 ms Billed Duration: 110 ms Memory Size: 2000 MB Max Memory Used: 91 MB Init Duration: 381.52 ms

补充几个关键点：

• 我的表中还有很多从2024-08-07T00:00:00.000Z到当前日期的每日数据
• 我在AWS控制台中执行相同的日期范围查询时，是可以正常返回这条记录的

内容来源于stack exchange