[MDEV-2888] LP:820163 - Q11 from DBT3 returns an empty set Created: 2011-08-03  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Igor Babaev Assignee: Oleksandr Byelkin
Resolution: Not a Bug Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug820163.xml    

 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.



 Comments   
Comment by Philip Stoev (Inactive) [ 2011-08-03 ]

Re: Q11 from DBT3 returns an empty set
DBT3 of various sizes:

http://bazaar.launchpad.net/~randgen/randgen/rqg2/files/head:/conf/dbt3/

Comment by Oleksandr Byelkin [ 2011-08-03 ]

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).

Comment by Oleksandr Byelkin [ 2011-08-03 ]

Re: Q11 from DBT3 returns an empty set
As we figured out the result depends on the fraction of the database.

Comment by Rasmus Johansson (Inactive) [ 2011-08-03 ]

Launchpad bug id: 820163

Generated at Thu Feb 08 06:44:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.