Details
-
Type:
Bug
-
Status: Done
-
Resolution: Done
-
Fix Version/s: None
-
Component/s: Qserv
-
Labels:None
-
Story Points:4
-
Team:Data Access and Database
Description
The following shows the problem (See the column names in the results, they are not what user will expect). It happens for all aggregates: min, max, avg, count etc
select min(ra_PS), min(decl_PS), max(ra_PS), max(decl_PS), avg(ra_PS) from Object;
|
+----------------+---------------+---------------+---------------+-------------------------------+
|
| MIN(QS1_MIN) | MIN(QS2_MIN) | MAX(QS3_MAX) | MAX(QS4_MAX) | (SUM(QS6_SUM)/SUM(QS5_COUNT)) |
|
+-----------------+--------------+---------------+---------------+-------------------------------+
|
| 0.041714119635 | -6.1011707745 | 359.938579891 | 3.89870649736 | 112.537203939 |
|
+----------------+---------------+---------------+---------------+-------------------------------+
|
Attachments
Issue Links
- mentioned in
-
Page Loading...
Activity
Done some time back.
I mentioned the other day that one way to return user-expected column names is to ask the (empty) czar MySQL instance by executing the query and seeing what comes back. I can see that there might be some problems with that, but it might be a starting point.