Bernt M. Johnsen wrote:
[...]
// Doesn't work but seems like it could/should based on above queries...
ij> select sin(i) from t1 group by sin(i);
ERROR 42Y30: The SELECT list of a grouped query contains at least one
invalid expression. If a SELECT list has a GROUP BY, the list may only
contain valid grouping expressions and valid aggregate expressions.
[...]
To me it seems natural that this one doesn't work. To group by double
or float values is not reasonable.
Thank you for the reply, Bernt. Perhaps this is the detail I was missing. When
you say "is not reasonable", can you elaborate on why that's the case (excuse me
if that's a naive question)? Is it because the types are imprecise?
I did notice that following works:
ij> create table td (d double);
0 rows inserted/updated/deleted
ij> insert into td values 2.08, 3.08;
2 rows inserted/updated/deleted
ij> select d from td group by d;
D
----------------------
2.08
3.08
If it is not reasonable to group by a double, then should this query work? Or
should we be throwing the same error that we throw for "sin(i)"?
Army
