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 over temporal domains #3112

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Median over temporal domains #3112

monetdb-team opened this issue Nov 30, 2020 · 0 comments
Labels
bug Something isn't working normal SQL

Comments

@monetdb-team
Copy link

Date: 2012-07-05 14:12:45 +0200
From: @mlkersten
To: SQL devs <>
Version: 11.11.5 (Jul2012)
CC: @njnes

Last updated: 2012-07-17 13:46:39 +0200

Comment 17412

Date: 2012-07-05 14:12:45 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:13.0) Gecko/20100101 Firefox/13.0
Build Identifier:

It appears that the SQL median() function does not produce the split anticipated.
Moreover, there is an average over dates missing.

Reproducible: Always

Steps to Reproduce:

sql>select min(departure_date) from voyages;
+------------+
| L1 |
+============+
| 1595-04-02 |
+------------+
1 tuple (1.724ms)
sql>select max(departure_date) from voyages;
+------------+
| L1 |
+============+
| 1796-10-19 |
+------------+
1 tuple (1.921ms)
sql>select avg(departure_date) from voyages;
types date(0,0) and double(53,0) are not equal for column 'departure_date'
sql>select median(departure_date) from voyages;
+------------+
| L1 |
+============+
| 1770-02-23 |
+------------+
1 tuple (5.759ms)
sql>select count() from voyages where departure_date < date '1770-02-23';
+------+
| L1 |
+======+
| 6836 |
+------+
1 tuple (2.758ms)
sql>select count(
) from voyages where departure_date >= date '1770-02-23';
+------+
| L1 |
+======+
| 1279 |
+------+
1 tuple (2.359ms)

Comment 17420

Date: 2012-07-06 13:42:18 +0200
From: @njnes

median part is fixed.

Comment 17474

Date: 2012-07-17 13:46:39 +0200
From: @grobian

Fix delivered in Jul2012 release

@monetdb-team monetdb-team added bug Something isn't working normal SQL labels Nov 30, 2020
@sjoerdmullender sjoerdmullender added this to the Ancient Release milestone Nov 9, 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 normal SQL
Projects
None yet
Development

No branches or pull requests

2 participants