[CALCITE-194] Array items in MongoDB adapter

• Type: Bug
• Status: In Progress
• Priority: Major
• Resolution: Unresolved
• Component/s: mongodb-adapter
• Labels: github-import pull-request-available
• Assignee: Igor Kryvenko
• Reporter: GitHub Import
• Created: 18/Jun/14 08:32
• Updated: 02/Oct/19 18:38

Description

When MongoDB issue <a href="https://jira.mongodb.org/browse/SERVER-4589">SERVER-4589</a>, "aggregation: need an array indexing operator" is fixed, we will be able to implement

```sql
SELECT loc[0] AS longitude, loc[1] AS latitude FROM zips
```

in the MongoDB adapter. Meantime, look for `Bug.OPTIQnnn_FIXED` in the code.

---------------- Imported from GitHub ----------------
Url: https://github.com/julianhyde/optiq/issues/194
Created by: julianhyde
Labels: bug,
Created at: Wed Mar 19 00:03:01 CET 2014
State: open

Issue Links

• is depended upon by: CALCITE-2337 Release Calcite 1.17.0
• is duplicated by: CALCITE-342 optiq-mongodb examples can't display latitude and longitude
• is related to: CALCITE-3337 Support query arrays of Embedded Documents in MongoDB adapter
• links to: GitHub Pull Request #720
• links to: PR720