Type of median error

[monetdb-team]

Date: 2012-06-02 00:07:10 +0200
From: @mlkersten
To: SQL devs <>
Version: -- development
CC: @njnes

Last updated: 2012-06-19 11:20:47 +0200

Comment 17333

Date: 2012-06-02 00:07:10 +0200
From: @mlkersten

User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:12.0) Gecko/20100101 Firefox/12.0
Build Identifier:

Unexpected type mismatch in date expression. The median(date) should return the same as min/max(date)

sql>select median(departure_date) - min(departure_date) from voyages;
types date(0,0) and tinyint(8,0) are not equal for column 'departure_date'
sql>select max(departure_date) - min(departure_date) from voyages;
+------------+
| sql_sub_L1 |
+============+
| 73615 |
+------------+
1 tuple (18.832ms)

Reproducible: Always

Comment 17346

Date: 2012-06-06 16:08:22 +0200
From: @njnes

Changeset 36b7be236d87 made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=36b7be236d87

Changeset description:

fixed bug #3096
	1) added missinge sql create functions for date/time/timestamp
	2) fixed problem with median on empty column

Comment 17348

Date: 2012-06-06 16:09:35 +0200
From: @njnes

fixed by adding the missing create functions in sql

Comment 17353

Date: 2012-06-09 17:01:31 +0200
From: @mlkersten

On the current:

sql>select median(departure_date), min (departure_date) from voyages;
types date(0,0) and tinyint(8,0) are not equal for column 'departure_date'
sql>select median(departure_date) from voyages;
types date(0,0) and tinyint(8,0) are not equal for column 'departure_date'
sql>

Comment 17354

Date: 2012-06-09 20:27:41 +0200
From: @grobian

Jul2012 has not been merged into default yet (http://dev.monetdb.org/hg/MonetDB/graph/)