Skip to content
  • Sreeharsha Ramanavarapu's avatar
    cec51276
    Bug #25899921: INCORRECT BEHAVIOR WITH DESC INDEX AND · cec51276
    Sreeharsha Ramanavarapu authored
                   DELETE STATEMENT
    
    Issue:
    ------
    In case of an UPDATE/DELETE statement with an
    ORDER BY ... LIMIT, table scan is used. When the optimizer
    tries to check if there is a cheaper ordering compared to
    filesort, some checks are missing.
    
    Solution:
    ---------
    Use the table object instead of the JOIN_TAB object.
    cec51276
    Bug #25899921: INCORRECT BEHAVIOR WITH DESC INDEX AND
    Sreeharsha Ramanavarapu authored
                   DELETE STATEMENT
    
    Issue:
    ------
    In case of an UPDATE/DELETE statement with an
    ORDER BY ... LIMIT, table scan is used. When the optimizer
    tries to check if there is a cheaper ordering compared to
    filesort, some checks are missing.
    
    Solution:
    ---------
    Use the table object instead of the JOIN_TAB object.
Loading