Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-83221

Clustered Collections listIndexes should show TTL

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Minor - P4 Minor - P4
    • 7.3.0-rc0
    • Affects Version/s: 6.0.0
    • Component/s: None
    • Labels:
    • Storage Execution
    • Fully Compatible
    • ALL
    • Hide
      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
        }
      ] 
      
      Show
      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 } ]
    • Execution Team 2024-01-08, Execution Team 2024-01-22
    • 52

      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.

            Assignee:
            brad.cater@mongodb.com Brad Cater
            Reporter:
            michael.gargiulo@mongodb.com Michael Gargiulo
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: