Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Not a Bug
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
Query 11 from DBT3 benchmark returns an empty set for mariadb-5.3.0:
select ps_partkey, sum(ps_supplycost * ps_availqty) as value
from partsupp, supplier, nation
where ps_suppkey = s_suppkey and s_nationkey = n_nationkey
and n_name = 'GERMANY'
group by ps_partkey
having sum(ps_supplycost * ps_availqty) >
(select sum(ps_supplycost * ps_availqty) * 0.0001
from partsupp, supplier, nation
where ps_suppkey = s_suppkey and s_nationkey = n_nationkey
and n_name = 'GERMANY')
order by value desc;
The query is supposed to return some rows.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Re: Q11 from DBT3 returns an empty set
Could you explain how to repeat? For me it returns "some" rows:
...
| 1596 | 110565 |
| 295 | 97604.25 |
-----------------------+
359 rows in set (0.03 sec)
Checked on latest 5.3 and dbt3 set got from Timour and downloaded from Philip's URL... (BTW sizes was very different).
Re: Q11 from DBT3 returns an empty set
As we figured out the result depends on the fraction of the database.
Launchpad bug id: 820163
Re: Q11 from DBT3 returns an empty set
DBT3 of various sizes:
http://bazaar.launchpad.net/~randgen/randgen/rqg2/files/head:/conf/dbt3/