[jira] [Created] (DRILL-3505) MongoDB _id is returned as null when t.*, t._id is used in the projection

[Tugdual Grall (JIRA)]

Tugdual Grall created DRILL-3505:
------------------------------------

             Summary: MongoDB _id is returned as null when  t.*, t._id is used 
in the projection
                 Key: DRILL-3505
                 URL: https://issues.apache.org/jira/browse/DRILL-3505
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - MongoDB
    Affects Versions: 1.1.0
         Environment: Drill 1.1 Stand alone
Java 8 OSX
MongoDB 3.0.4
            Reporter: Tugdual Grall
            Assignee: B Anil Kumar
            Priority: Minor


By default, and choice of implementation the _id is not visible when using
{code}
select * from mongo.db.collection c
{code}

and this is OK

However, if I want to return the _id I need to specify it in the projection
{code}
select c._id , c.name from mongo.db.collection c
{code}

but if I want "all the column" I would like to be able to write:
{code}
select c._id , c.* from mongo.db.collection c
{code}

but this return "NULL" for the _id column





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)