Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3505

MongoDB _id is returned as null when t.*, t._id is used in the projection

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 1.1.0
    • 1.3.0
    • Storage - MongoDB
    • None
    • Drill 1.1 Stand alone
      Java 8 OSX
      MongoDB 3.0.4

    Description

      By default, and choice of implementation the _id is not visible when using

      select * from mongo.db.collection c
      

      and this is OK

      However, if I want to return the _id I need to specify it in the projection

      select c._id , c.name from mongo.db.collection c
      

      but if I want "all the column" I would like to be able to write:

      select c._id , c.* from mongo.db.collection c
      

      but this return "NULL" for the _id column

      Attachments

        Activity

          People

            Unassigned Unassigned
            tgrall Tugdual Grall
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: