You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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>
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:
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/)
The text was updated successfully, but these errors were encountered: