Clustered Collections listIndexes should show TTL

XMLWordPrintableJSON

    • Storage Execution
    • Fully Compatible
    • ALL
    • v7.0, v6.0
    • 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
    • 200
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      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
              Reporter:
              Michael Gargiulo
              Votes:
              0 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: