#8647: select * from (select from .. ) as temp displays an extra _id column

tariqrahiman reported 2013-04-10T00:29:01Z · last modified 2013-04-12T20:43:11Z

select * from (select from .. ) as temp displays an extra _id column

Dev	emil.goicovici
QA	JennyNishimura

Priority	Low
Complexity	Unknown

Component	MongoSQL
Version	14.0

Version: 14.0-dev-36

Build #: 31873

Build Date: 2013-Apr-09 09:02:56 AM

select * from (select from .. ) as temp displays an extra _id column

1. Open a query window and execute below queries against the baseball table. You can see for the 3rd query _id gets displayed which seems to be incorrect.

2. Compare the same set of queries against the SQL Server Orders table and you can see the difference

SELECT city a, teamName b FROM baseball

select a,b from ( SELECT city a, teamName b FROM baseball) as temp

select * from ( SELECT city a, teamName FROM baseball) as table

1 attachment

Screen Shot 2013-04-09 at 5.25.59 PM.png

2013-04-10T00:29:01Z

70 KB

All Comments (2) Change History

emil.goicovici 2013-04-10T14:37:39Z

Fixed the extra _id issue; fixed the fields order inside the resultset.

tariqrahiman 2013-04-12T20:43:11Z

Verified in 14.0-dev-38

Search Tips

Aqua Data Studio / nhilam

select * from (select from .. ) as temp displays an extra _id column

1 attachment

Issue #8647

Completion

1 issue link

Issue #9420

Search Tips

Aqua Data Studio / nhilam

Title

select * from (select from .. ) as temp displays an extra _id column

1 attachment

Issue #8647

Completion

1 issue link

Issue #9420