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

• "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