I couldn't find any existing bug logs for the below issue and want to make sure that it's not a known issue before I log it.

Basically, performing time computation across columns doesn't work.

percy@percy-sandbox:~$ uname -a
Linux percy-sandbox 3.2.0-33-generic #52-Ubuntu SMP Thu Oct 18 16:29:15 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux

percy@percy-sandbox:~$ monetdbd -v
MonetDB Database Server v1.6 (Oct2012)

percy@percy-sandbox:~$ mclient -u monetdb -d click
password:
Welcome to mclient, the MonetDB/SQL interactive terminal (Oct2012)
Database: MonetDB v11.13.3 (Oct2012), 'mapi:monetdb://percy-sandbox:50000/click'
Type \q to quit, \? for a list of available commands
auto commit mode: on

sql>create table time_table (atime timestamp, btime timestamp, ctime date);
operation successful (33.944ms)

sql>insert into time_table values(timestamp '1970-JAN-1', timestamp '1980-DEC-31', date '2012-JAN-1');
1 affected row (20.649ms)

sql>select * from time_table;
+----------------------------+----------------------------+------------+
| atime                      | btime                      | ctime      |
+============================+============================+============+
| 1970-01-01 00:00:00.000000 | 1980-12-31 00:00:00.000000 | 2012-01-01 |
+----------------------------+----------------------------+------------+
1 tuple (1.402ms)

sql>select btime <> atime from time_table;
+----------+
| <>_btime |
+==========+
| true     |
+----------+
1 tuple (1.208ms)

sql>select btime - timestamp '1975-JAN-01' from time_table;
+---------------+
| sql_sub_btime |
+===============+
|  189302400000 |
+---------------+
1 tuple (1.389ms)

sql>select btime - atime from time_table;
+---------------+
| sql_sub_btime |
+===============+
+---------------+
0 tuples (1.450ms)


Expected result: All queries return 1 tuple
Actual result: The query that performs date subtraction between two columns returns 0 tuples.

Thanks,

--

Percy Wegmann