Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Minor |
| Complexity | Unknown |
| Component | MongoSQL |
| Version | 17.0 |
Currently, for performance reason, when we retrieve the list of fields for a collection, we only look at the first document. In the schema browser, a tooltip is displayed for the "Fields" node to indicate the "_id" value of the document that is used to retrieve the list of fields.
Enhance the functionality to allow the user to specify which document(s) to be used when retrieving the list of fields.
|
|
59 KB
- Added a JDBC driver property named "showFieldsSampleSize". It indicates how many documents to query to build the list of fields when running the SHOW FIELDS command.
- Default is 1, which means SHOW FIELDS looks at only one document.
- If showFieldsSampleSize > 1, SHOW FIELDS will query the specified sample size of documents and build the list of fields.
- If multiple documents have the same field names but with different data types, the data type of the first document will be used.
- In the schema browser, if showFieldsSampleSize = 1, the tooltip of the "Fields" node will display the _id value of the one document that is used to retrieve the list of fields. If showFieldsSampleSize > 1, the tooltip will display the sample size value.
Issue #14669 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 17.0.8-1 |
| No time estimate |
- Added a JDBC driver property named "showFieldsSampleSize". It indicates how many documents to query to build the list of fields when running the SHOW FIELDS command.
- Default is 1, which means SHOW FIELDS looks at only one document.
- If showFieldsSampleSize > 1, SHOW FIELDS will query the specified sample size of documents and build the list of fields.
- If multiple documents have the same field names but with different data types, the data type of the first document will be used.
- In the schema browser, if showFieldsSampleSize = 1, the tooltip of the "Fields" node will display the _id value of the one document that is used to retrieve the list of fields. If showFieldsSampleSize > 1, the tooltip will display the sample size value.