Re: no rows with order by

jernigam_at_kochind.com wrote:
> If we run the statement below
> Select prd.entry_date, prd.plant_id,
> prd.product_id, prd.unit_id,
> podcommon.gas_conv_eff(prd.plant_id, prd.entry_date,prd.unit_id)
> gc_eff
> From production prd
> Where prd.production <> 0
> And prd.inactive_date is null
> And prd.product_id = 1
> And prd.entry_date > to_date('01/01/2004','mm/dd/yyyy')
> Order by prd.plant_id, prd.entry_date
>
> We get now rows. If we remove the order by clause, we do.
>
> Any ideas? If we remove the function, it also returns rows. Is
> there an issue with sorting and functions?

When checking execution plans you may find that a different set of indexes is used. Maybe one of them has gone awry and is responsible for the empty result.

Kind regards

    robert Received on Thu Jun 30 2005 - 10:10:37 CDT