#8645: Issues with select * from and alias with mongodb

tariqrahiman reported 2013-04-09T22:39:00Z · last modified 2013-05-01T01:14:20Z

Issues with select * from and alias with mongodb

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

1. Use the below insert to create a collection

2. Open a query window and execute below query

SELECT valuation, valuation FROM baseball

SELECT valuation, valuation ALIAS FROM baseball

SELECT FLATTEN valuation, valuation ALIAS FROM baseball

SELECT Flatten *, valuation FROM baseball

SELECT Flatten *, valuation ALIAS FROM baseball

3. You can see for 2nd query null is being displayed

For the 5th query, the position of valuation is changed and instead of the field valuation ALIAS is being displayed

INSERT INTO baseball

VALUES (
{
"teamName": "Cubs-2",
"city": "Chicago",
"valuation": 10,
"managerName": { "first": "John", "last": "Zimmer" },
"colors": [ "blue", "gray" ],
"stats":
[
{
"year": 1904,
"wins": 100,
"mostRbis": 1000,
"grade": "A",
"battingAvg": 0.300
},
{
"year": 1987,
"wins":80,
"mostRbis":200,
"grade":"A",
"battingAvg":0.267
}
]
} )

1 attachment

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

2013-04-09T22:39:00Z

154 KB

All Comments (2) Change History

emil.goicovici 2013-04-25T06:01:11Z

Alias handling has been rewritten to support these scenarios. Aliases are not supported by MongoDB API, therefore all translations are done at JDBC driver level.

tariqrahiman 2013-05-01T01:14:20Z

Verified in 14.0-dev-47

Search Tips

Aqua Data Studio / nhilam

Issues with select * from and alias with mongodb

1 attachment

Issue #8645

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Issues with select * from and alias with mongodb

1 attachment

Issue #8645

Completion