Re: query does not return after increasing range in 'between' clause

Oh ya…

select fact.store_tag,fact.period,fact.upc upcid,
case when mkt_tag = 4480 then market.description else '' end retailmarket,
case when mkt_tag = 100 then market.description else '' end compmarket,
case when mkt_tag = 4480 then dollars else 0 end base_dollars,
case when mkt_tag = 100 then dollars else 0 end ref_dollars,
case when mkt_tag = 4480 then units else 0 end base_units,
case when mkt_tag = 100 then units else 0 end ref_units,
case when mkt_tag = 100 then acv else null end avg_acv,
case when mkt_tag = 4480 then b_dollars else 0 end base_base_dollars,
case when mkt_tag = 100 then b_dollars else 0 end ref_base_dollars,
case when mkt_tag = 4480 then b_units else 0 end base_base_units,
case when mkt_tag = 100 then b_units else 0 end ref_base_units,
product.lvl,product.upc,
product.description as description,
product.category,product.category_tag,
product.subcategory,
product.company,product.brand,
market.mkt_tag as mkt_tag,
period.period,
period.orderno
from
sg_dm_b.t_week_f fact,
sg_dm_b.nb_products product,
sg_dm_b.nb_markets market,
sg_dm_b.nb_periods period
where (product.product_key = fact.upc)
and (market.mkt_tag = fact.store_tag)
and (period.period = fact.period)
and fact.store_tag in(100,4480)
and product.lvl = 'UPC'
and product.category_tag = 'GRBYFD'
and period.orderno between 1446 and 1450;
— change to period.orderno between 1447 and 1450 gives the none material version of the plan.

On Aug 27, 2014, at 1:18 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:

> On 08/27/2014 11:02 AM, Dennis wrote:
>> Hi, I am having bad luck with a query that should return zero rows but
>> actually never returns (completes execution.)
>>
>
> And the query is :) ?
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>