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