[MonetDB-users] Bug....

Pierre BOIZOT pierre.boizot at gmail.com
Tue Sep 23 22:37:18 CEST 2008


Hi all,

a test with the gold data ....
no errors on the load

if i stop and restart the database errors is allways here.

sql>select age,gender, count(*), avg(price) from car group by age, gender;
+-----+-------+-------------+-----------------------+
| age |gender |count_gender |avg_price              |
+=====+=======+=============+=======================+
|  19 |f      |      110025 |   -1449.6788093615087 |
|  41 |m      |       97200 |   -6411.6489300411522 |
........
52 |f      |       95940 |   -6467.6865332499483 |
+-----+-------+-------------+-----------------------+
Timer    2694.008 msec 92 rows
sql>select count(*) from car where price = 0;
+--------+
| count_ |
+========+
|      0 |
+--------+
Timer    2502.145 msec 1 rows
sql>select count(*) from car where price < 0;
+--------+
| count_ |
+========+
|      0 |
+--------+
Timer     148.724 msec 1 rows


see the trace file .

Regards
Pierre

-- 
Pierre Boizot
Rue des philosophes , 13
1400 Yverdon les bains
Mobile : +41 795713660
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20080923/7fd170b6/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bugmonetdb.trc
Type: application/octet-stream
Size: 11281 bytes
Desc: not available
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20080923/7fd170b6/attachment.obj>


More information about the users-list mailing list