Skip to content
  • Chaithra Gopalareddy's avatar
    70725c78
    Bug#30321546: OPTIMIZER TRACE SHOWS DIFFERENT ACTIONS FOR A QUERY IF ANOTHER QUERY · 70725c78
    Chaithra Gopalareddy authored
                  RUN BEFORE
    
    Problem:
    Table's cond_set bitmap gets set when the first query in the bugpage
    is run. The same value for cond_set is used for the second query too
    as the bits are not reset. As a result, optimizer tries to calculate
    condition filtering effect for the second query when there are no
    predicates on the fields of the table, resulting in the extra trace.
    Query execution does not get affected because the other checks do not
    pass.
    
    Solution:
    Reset the bitmap "cond_set" in clear_column_bitmaps() similar to other
    bitmaps.TABLE::init() calls clear_column_bitmaps() there by resetting
    the bitmap for the next query.
    
    Reviewed by: Dag Wanvik <dag.wanvik@oracle.com>
    70725c78
    Bug#30321546: OPTIMIZER TRACE SHOWS DIFFERENT ACTIONS FOR A QUERY IF ANOTHER QUERY
    Chaithra Gopalareddy authored
                  RUN BEFORE
    
    Problem:
    Table's cond_set bitmap gets set when the first query in the bugpage
    is run. The same value for cond_set is used for the second query too
    as the bits are not reset. As a result, optimizer tries to calculate
    condition filtering effect for the second query when there are no
    predicates on the fields of the table, resulting in the extra trace.
    Query execution does not get affected because the other checks do not
    pass.
    
    Solution:
    Reset the bitmap "cond_set" in clear_column_bitmaps() similar to other
    bitmaps.TABLE::init() calls clear_column_bitmaps() there by resetting
    the bitmap for the next query.
    
    Reviewed by: Dag Wanvik <dag.wanvik@oracle.com>
Loading