• V Narayanan's avatar
    Bug#45803 Inaccurate estimates for partial key values with IBMDB2I · 148141fa
    V Narayanan authored
    Some collations were causing IBMDB2I to report
    inaccurate key range estimations to the optimizer
    for LIKE clauses that select substrings. This can
    be seen by running EXPLAIN. This problem primarily
    affects multi-byte and unicode character sets.
    
    This patch involves substantial changes to several
    modules. There are a number of problems with the
    character set and collation handling. These problems
    have been or are being fixed,  and a comprehensive
    test has been included which should provide much
    better coverage than there was before. This test
    is enabled only for IBM i 6.1, because that version
    has support for the greatest number of collations.
    148141fa
ibmdb2i_collations.test 2.21 KB