Easily find issues by searching: #<Issue ID>
Example: #1832
Tested on Aqua Data Studio 14.0.0-beta-33 Build #: 32981 on Ubuntu 12.04( Mongo DB 2.4.3) and Windows XP ( Mongo DB 2.0.9).
Next statements give next results:
SELECT b.valuation,b.city FROM baseball b GROUP BY b.valuation,b.city
Dotted field names only alowed on the top level
SELECT b.valuation FROM baseball b GROUP BY b.valuation
empty result set instead rows
|
|
80 KB
Tested in Aqua Data Studio 14.0.0-beta-55 Build #: 33118 .Alias of FROM does not work in HAVING caluse:
SELECT b.valuation FROM baseball b GROUP BY b.valuation HAVING b.valuation>0
gives empty result set instead rows as next statement returns:
SELECT valuation FROM baseball GROUP BY valuation HAVING valuation>0
SELECT b.valuation FROM baseball b GROUP BY b.valuation HAVING b.valuation>0
works as expected with the latest build (ADS-14-beta59).
SELECT b.valuation FROM baseball b GROUP BY b.valuation HAVING b.valuation>0
works as expected with the latest build (ADS-14-beta59).
SELECT b.valuation,b.city as oa FROM baseball b GROUP BY b.valuation,b.oa
go
--Dotted field names only alowed on the top level
SELECT b.valuation,b.city as oa FROM baseball b GROUP BY b.valuation,b.oa
go
--Dotted field names only alowed on the top level
Issue #9453 |
| Closed |
| Unreproducible |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS 14.0.0-beta-39 (mongo-jdbc 1.2.2) |
| No time estimate |
1 issue link |
duplicates #9455
Issue #9455Issues with aliases in WHERE and ORDER BY |
Tested in Aqua Data Studio 14.0.0-beta-55 Build #: 33118 .Alias of FROM does not work in HAVING caluse:
SELECT b.valuation FROM baseball b GROUP BY b.valuation HAVING b.valuation>0
gives empty result set instead rows as next statement returns:
SELECT valuation FROM baseball GROUP BY valuation HAVING valuation>0