• unknown's avatar
    bug #24186 (nested query across partitions returns fewer records) · 94046b73
    unknown authored
    Subselect's engine checks table->status field to determine if the
    record was properly found when we use keyread upon the table.
    Partition engine checks all the partitions for given key
    before return. So if matching record was found in the first
    partition and no matching records were found in the second, 
    we have table->status == NOT_FOUND after the function, what
    makes subselects to skip matching records.
    The patch adds table->status= 0 if we actually found something.
    
    
    mysql-test/r/partition.result:
      result fixed
    mysql-test/t/partition.test:
      testcase
    sql/ha_partition.cc:
      table->status set to 0 if we found something in previous partitions
    94046b73
partition.test 35.7 KB