search

IITDBGroup / gprom

GProM is a middleware that adds support for provenance to database backends.
http://www.cs.iit.edu/%7edbgroup/research/gprom.php
Apache License 2.0
8 stars 5 forks source link

one level aggregation in TEMPORAL is no longer normalized #19

Closed lordpretzel closed 7 years ago

lordpretzel commented 7 years ago

example on testuser: TEMPORAL (SELECT count(*) AS BOO FROM TEMP_TEST WITH TIME(T_BEGIN, T_END));

lordpretzel commented 7 years ago 
TEMPORAL (SELECT count(*) AS BOO FROM TEMP_TEST WITH TIME(T_BEGIN, T_END));

should return

 BOO | T_B | T_E |
------------------
 4   | 1   | 4   |
 3   | 4   | 6   |
 2   | 6   | 10  |
 1   | 10  | 13  |

but returns

 BOO | T_B | T_E |
------------------
 1   | 1   | 2   |
 1   | 2   | 4   |
 1   | 4   | 6   |
 1   | 6   | 10  |
 1   | 10  | 13  |
 2   | 1   | 2   |
 1   | 1   | 2   |
 1   | 2   | 4   |
 1   | 4   | 6   |
 1   | 6   | 10  |
 1   | 2   | 4   |
 1   | 4   | 6   |
 1   | 2   | 4   |