2618076 - Add Out of range histogram adjustment for lower bound values - SAP ASE

Add Out of range histogram adjustment for lower bound values.

"Out of range histogram adjustment" message is shown for upper bounds as well as an accurate selectivity value:

Estimating selectivity of index 'tempdb..tn.idx', indid 2

i = 5

Estimated selectivity for i,

Out of range histogram adjustment, <<<<<<<<<<<<<<

selectivity = 2.261881e-06,

scan selectivity 2.261886e-06, filter selectivity 2.261886e-06

1 rows, 1 pages

Data Row Cluster Ratio 1

However there is no message for lower bounds  and selectivity value is zero:

Beginning selection of qualifying indexes for table 'tempdb..tn',

Estimating selectivity of index 'tempdb..tn.idx', indid 2

i = -442109

Estimated selectivity for i,

selectivity = 0,

scan selectivity 2.261886e-06, filter selectivity 2.261886e-06

1 rows, 1 pages

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0

CR814024 , 814024, optimizer, costing, Out of range histogram adjustment , lower bounds. , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem