Closed sam1988 closed 11 years ago
Well, better check your results. The first set of results is what you supposed to get. I checked it by loading the data at scale 20 to Oracle 11 and my Oracle results are identical to that of Alenka. You might also take Scale 1 results, multiply it by 20 and see that your N|O results are a bit off.
using dbgen to generate 20G data and then running q1 and q6
and i check the results with mysql and monetdb.
and the result running q6 with alenka and mysql ,monetdb the result is the same
but running q1 i get different results
alenka results: A|F|1132393551078.85|755169104|25.50|38239.09|0.05|1118803345410.88|1075769269507.28|0.04|29613505| R|F|1132556540140.25|755284493|25.51|38246.80|0.05|1118968269619.38|1075930611640.11|0.04|29611797| N|O|2229413402673.42|1486771871|25.50|38235.37|0.05|2202675535336.87|2117943983015.22|0.04|58307621| N|F|29582901058.72|19739848|25.53|38262.38|0.05|29230208447.21|28103693343.31|0.04|773159|
mysql results: N|O|2293949394287.65|1529813855|25.50|38234.94|0.05|2266438501095.17|2179254402765.45|0.04|53307656| R|F|1132556540140.25|755284493|25.51|38246.80|0.05|1118968269619.38|1075930611640.11|0.04|29611797| A|F|1132393551078.85|755169104|25.50|38239.09|0.05|1118803345410.88|1075769269507.28|0.04|29613505| N|F|29582901058.72|19739848|25.53|38262.38|0.05|29230208447.21|28103693343.31|0.04|773159|
we get four rows and only one row(the first row of mysql resluts) is different with alenka and the result with monetdb is same as mysql