[SERVER-83221] Clustered Collections listIndexes should show TTL Created: 14/Nov/23  Updated: 17/Jan/24  Resolved: 15/Jan/24

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: 6.0.0
Fix Version/s: 7.3.0-rc0

Type: Bug Priority: Minor - P4
Reporter: Michael Gargiulo Assignee: Brad Cater
Resolution: Fixed Votes: 0
Labels: storex-ranked
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Problem/Incident
Related
Assigned Teams:
Storage Execution
Backwards Compatibility: Fully Compatible
Operating System: ALL
Steps To Reproduce:

db.createCollection( "rule_wf_session_continue_new", { clusteredIndex: {key: {_id: 1},unique: true }, expireAfterSeconds: 15552000 }) 

db.rule_wf_session_continue_new.getIndexes() 

[
{
    v: 2,
    key: { _id: 1 },
    name: '_id_',
    unique: true,
    clustered: true
  }
] 

Sprint: Execution Team 2024-01-08, Execution Team 2024-01-22
Participants:
Linked BF Score: 52

 Description   

Clustered collections allow for the creation of a TTL property to be created on the "clustered index" yet we only show the TTL option as part of listCollections today and not as part of listIndexes. The listIndexes spec omits the TTL properties

The expected output of listIndexes should include the TTL as part of the index spec.



 Comments   
Comment by Githook User [ 11/Jan/24 ]

Author:

{'name': 'Brad Cater', 'email': '152920274+brad-cater-mongodb@users.noreply.github.com', 'username': 'brad-cater-mongodb'}

Message: SERVER-83221 Add the TTL, expireAfterSeconds, to clustered index info on getIndexes(). (#17813)

GitOrigin-RevId: 204dddfb1bcf3139ec6085cda132fa02a76a6b77
Branch: master
https://github.com/mongodb/mongo/commit/cdd99a1e3a4d6536d85284a3b464a5ab944567d3

Generated at Thu Feb 08 06:51:34 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.