Skip to content
  • Aakanksha Verma's avatar
    4ed0bada
    Bug #25332330 COUNT(*) ON INNODB SOMETIMES RETURNS 0 · 4ed0bada
    Aakanksha Verma authored
    
    
    PROBLEM
    
    When using Index merge optimization current partitioning code in 5.6
    does a memcpy instead of column of copy of the columns on which index
    read is done . Because of which wrong record gets copied and optimizer
    thinks there is no matching record as per the search criteria returning
    0 for the count(*) value . The problem is sporiadic as the plan is not
    always using intersection .
    
    SOLUTION
    
    Added a similar column copy function that would do the copy of required
    column and not overwrite the other as in 5.7.
    
    Reviewed-by: default avatarDebarun <Banerjee&lt;debarun.banerjee@oracle.com>
    RB: 16157
    4ed0bada
    Bug #25332330 COUNT(*) ON INNODB SOMETIMES RETURNS 0
    Aakanksha Verma authored
    
    
    PROBLEM
    
    When using Index merge optimization current partitioning code in 5.6
    does a memcpy instead of column of copy of the columns on which index
    read is done . Because of which wrong record gets copied and optimizer
    thinks there is no matching record as per the search criteria returning
    0 for the count(*) value . The problem is sporiadic as the plan is not
    always using intersection .
    
    SOLUTION
    
    Added a similar column copy function that would do the copy of required
    column and not overwrite the other as in 5.7.
    
    Reviewed-by: default avatarDebarun <Banerjee&lt;debarun.banerjee@oracle.com>
    RB: 16157
Loading