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
In ADS doc https://www.aquaclusters.com/app/home/project/public/aquadatastudio/wikibook/MongoDB/page/Query-Reference/Query-Reference#where_syntax for WHERE clause necessary to change:
1. expr [NOT] IN (expr [, expr] …) on expr [NOT] IN (value [, value] …) because expression not possible e.g SELECT city FROM baseball WHERE valuation IN((1+1),(9+1)) gives error
2. expr [NOT] BETWEEN expr AND expr on expr [NOT] BETWEEN value AND value e.g. SELECT city FROM baseball WHERE valuation BETWEEN (1+1) AND (9+1) gives wrong result.
3. Add expr [NOT] BETWEEN (subquery) AND (subquery) . E.g. next statement works correct: SELECT city FROM baseball WHERE valuation BETWEEN (SELECT min(valuation) FROM baseball) AND (SELECT max(valuation) FROM baseball)
I have a few questions regarding what I should edit/delete
for #1.
should I delete
expr [NOT] IN (expr [, expr] …)
and replace it with
expr [NOT] IN (value [, value] …)
for #2
should I delete
expr [NOT] BETWEEN expr AND expr
and replace it with
expr [NOT] BETWEEN value AND value
for #3
I was going to add a new line
expr [NOT] BETWEEN (subquery) AND (subquery)
I close this ticket because it is not a problem with documentation but with realisation. In ADS 14.0 alfa 18 BETWEEN statement accepts expressions but IN statement with expressions gives error, in turn $in statement in Mongo shell does not. I open new ticket for this bug https://www.aquaclusters.com/app/home/project/public/aquadatastudio/issue/9025
I close this ticket because it is not a problem with documentation but with realisation. In ADS 14.0 alfa 18 BETWEEN statement accepts expressions but IN statement with expressions gives error, in turn $in statement in Mongo shell does not. I open new ticket for this bug https://www.aquaclusters.com/app/home/project/public/aquadatastudio/issue/9025
Issue #8908 |
| Closed |
| Fixed |
| Resolved |
Completion |
| No due date |
| No fixed build |
| No time estimate |
I have a few questions regarding what I should edit/delete
for #1.
should I delete
expr [NOT] IN (expr [, expr] …)
and replace it with
expr [NOT] IN (value [, value] …)
for #2
should I delete
expr [NOT] BETWEEN expr AND expr
and replace it with
expr [NOT] BETWEEN value AND value
for #3
I was going to add a new line
expr [NOT] BETWEEN (subquery) AND (subquery)