Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MEDIAN aggregation causes subsequent columns to return empty cells #52

Open
Schaechtle opened this issue Oct 14, 2022 · 0 comments
Open
Labels
bug Something isn't working

Comments

@Schaechtle
Copy link
Contributor

Examples of MEDIAN aggregation causing subsequent columns to return empty cells

iql> SELECT MEDIAN(Perigee_km), AVG(Perigee_km) FROM d

| MEDIAN(Perigee_km) | AVG(Perigee_km) |
|--------------------+-----------------|
|               1413 |                 |


iql> SELECT MEDIAN(Perigee_km), Perigee_km FROM d
| MEDIAN(Perigee_km) | Perigee_km |
|--------------------+------------|
|               1413 |            |

The following runs fine

iql> SELECT MEDIAN(Perigee_km) FROM d

| MEDIAN(Perigee_km) |
|--------------------|
|               1413 |


iql> SELECT AVG(Perigee_km), MEDIAN(Perigee_km) FROM d

|    AVG(Perigee_km) | MEDIAN(Perigee_km) |
|--------------------+--------------------|
| 15507.611492281303 |               1413 |

This was tested with the satellites data and with iql-strict.

@zane zane added the bug Something isn't working label Oct 18, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants