--output text returns multiple results

[tbjornli]

Describe the bug

We have a script that fetches the latest RDS snapshot available, which suddenly stopped working. After some troubleshooting I noticed that the output of the command returns two rows instead of one when using text as formatting.

$ aws rds describe-db-snapshots --db-instance-identifier production --query 'DBSnapshots[-1].[DBSnapshotIdentifier]' --output text
rds:production-2025-12-28-04-40
rds:production-2026-01-02-04-40

If I use any other output formatting it returns only the single, expected row.

Json:

$ aws rds describe-db-snapshots --db-instance-identifier production --query 'DBSnapshots[-1].[DBSnapshotIdentifier]' --output json
[
    "rds:production-2026-01-02-04-40"
]

Table:

$ aws rds describe-db-snapshots --db-instance-identifier production --query 'DBSnapshots[-1].[DBSnapshotIdentifier]' --output table
-------------------------------------
|        DescribeDBSnapshots        |
+-----------------------------------+
|  rds:production-2026-01-02-04-40  |
+-----------------------------------+

We are currently using version 2.32.26 installed via snap, but I get the same result with version 2.32.[22-25], and 1.44.[5-9].

If you need more information, please let me know.

Regression Issue

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

Expected Behavior

Should return only return one line. Expected result

aws rds describe-db-snapshots --db-instance-identifier production --query 'DBSnapshots[-1].[DBSnapshotIdentifier]' --output text
rds:production-2026-01-02-04-40

Current Behavior

$ aws rds describe-db-snapshots --db-instance-identifier production --query 'DBSnapshots[-1].[DBSnapshotIdentifier]' --output text
rds:production-2025-12-28-04-40
rds:production-2026-01-02-04-40

Reproduction Steps

Run the above command.

Possible Solution

No response

Additional Information/Context

No response

CLI version used

2.32.26

Environment details (OS name and version, etc.)

Ubuntu 24.04.3 LTS