Querying for n < x does not return all records that it should

[rickfero]

Checkboxes for prior research

• I've gone through Developer Guide and API reference
• I've checked AWS Forums and StackOverflow.
• I've searched for previous similar issues and didn't find any solution.

Describe the bug

  const command = new ScanCommand({
      TableName: 'Message',
      FilterExpression: '#version < :version',
      ExpressionAttributeNames: {
        '#version': '_lastInspectionVersion',
      },
      ExpressionAttributeValues: {
        ':version': { N: '1' },
      },
    });

  const response = await this.Client.send(command);

returns only 1 item

When looking in the same database (the only database I have) I can see there are way more than one

In general any query that queries on a number does not return all records.

Using "@aws-sdk/client-dynamodb": "^3.656.0",

Regression Issue

• Select this option if this issue appears to be a regression.

SDK version number

"@aws-sdk/client-dynamodb": "^3.656.0",

Which JavaScript Runtime is this issue in?

Node.js

Details of the browser/Node.js/ReactNative version

v20.14.0

Reproduction Steps

const command = new ScanCommand({
TableName: 'Message',
FilterExpression: '#version < :version',
ExpressionAttributeNames: {
'#version': '_lastInspectionVersion',
},
ExpressionAttributeValues: {
':version': { N: '1' },
},
});

const response = await this.Client.send(command);

Observed Behavior

One record returned

Expected Behavior

Over 1000 records returned

Possible Solution

?

Additional Information/Context

No response

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs and link to relevant comments in this thread.