We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
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
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
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)
Date: 2012-07-06 13:42:18 +0200 From: @njnes
median part is fixed.
Date: 2012-07-17 13:46:39 +0200 From: @grobian
Fix delivered in Jul2012 release
The text was updated successfully, but these errors were encountered:
No branches or pull requests
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
The text was updated successfully, but these errors were encountered: