Package: qa.debian.org
Severity: normal
User: qa.debian....@packages.debian.org
Usertags: udd

I was checking the information in the table history.sources_count in
UDD, and I see that there is no data in the columns: total_sid_main,
total_sid_contrib, total_sid_nonfree.

Query:
udd=> select ts,total_sid_main, total_sid_contrib, total_sid_nonfree, 
vcstype_git from history.sources_count;

To reproduce:
$ ssh wagner.debian.org
$ psql service=udd
udd=> select ts,total_sid_main, total_sid_contrib, total_sid_nonfree, 
vcstype_git from history.sources_count;

Output:
 ts                         | total_sid_main | total_sid_contrib | 
total_sid_nonfree | vcstype_git 
----------------------------+----------------+-------------------+-------------------+-------------
 2008-12-25 00:00:00        |                |                   |              
     |        1121
 2009-03-10 00:00:00        |                |                   |              
     |        1369
....
 2012-11-26 00:00:02.110947 |                |                   |              
     |        7122
 2012-11-27 00:00:02.472756 |                |                   |              
     |        7123
 2012-11-28 00:00:01.879357 |                |                   |              
     |        7122

Another test:
udd=> select distinct total_sid_main from history.sources_count;
 total_sid_main 
----------------
               
(1 row)


I expected to see something like:
 ts                         | total_sid_main | total_sid_contrib | 
total_sid_nonfree | vcstype_git 
----------------------------+----------------+-------------------+-------------------+-------------
 2008-12-25 00:00:00        | 19557          | 175               | 336          
     |        1121


Thanks for all your work in UDD.

Cheers,
Josué Abarca


-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to