[HIVE-8283] Missing break in FilterSelectivityEstimator#visitCall()

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 0.14.0
• Assignee: Navis Ryu
• Reporter: Ted Yu
• Created: 27/Sep/14 16:21
• Updated: 13/Nov/14 19:43
• Resolved: 07/Oct/14 15:21

Description

    case NOT_EQUALS: {
      selectivity = computeNotEqualitySelectivity(call);
    }

    case LESS_THAN_OR_EQUAL:
    case GREATER_THAN_OR_EQUAL:
    case LESS_THAN:
    case GREATER_THAN: {
      selectivity = ((double) 1 / (double) 3);
      break;
    }

break is missing for NOT_EQUALS case. selectivity would be overwritten with 1/3.

Issue Links

• relates to: HIVE-8315 CBO : Negate condition underestimates selectivity which results in an in-efficient plan