[MonetDB-users] Bug in EXTRACT?
6 Feb
2011
6 Feb
'11
10:13 a.m.
Hi,
There seems to be a bug in the October SP.
If you run this query:
SELECT EXTRACT(YEAR FROM f1 .a1) as a2, EXTRACT(YEAR FROM f1 .a1) as a3 FROM (select '1996-02-01' as a2, '1996-07-01' as a1) f1
it returns: 1996, 1996-02-01
Instead of: 1996, 1996
The second column is returned as timestamp instead of int. Also, this does not happen if the first aliases (a2, a3) are changed to different names, nor does it happen if the two EXTRACTS are not identical. If one is YEAR and the second is MONTH it works, but if both are MONTH the same bug happens.
I tried it also on the August build and it works fine there.
Any ideas?
--
View this message in context: http://old.nabble.com/Bug-in-EXTRACT--tp30855882p30855882.html
Sent from the monetdb-users mailing list archive at Nabble.com.
4875
Age (days ago)
4875
Last active (days ago)
0 comments
1 participants
participants (1)
-
Alex Bo.