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

["Jacques Nadeau (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-3505?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacques Nadeau resolved DRILL-3505.
-----------------------------------
       Resolution: Fixed
    Fix Version/s:     (was: Future)
                   1.3.0

Fixed in 52bfd3b

> 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
>            Priority: Minor
>             Fix For: 1.3.0
>
>
> 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)