anchor.diff:          #filtercheck{'<' = F} ->
               %% duplicate < filter
               {eliminate, Acc};
  +        #filtercheck{'<=' = {_,_,{const,LteVal}}} when LteVal >= LtVal ->
  +            %% query like `a <= 10 AND a < 10` the less than can be eliminated
  +            %% because it is already captured in the less than or equals filter
  +            {eliminate, Acc};
           #filtercheck{'=' = {_,_,{const,EqVal}}} when LtVal > EqVal ->
               %% existing equality check is less than than this less than filter,
               %% so this filter is already included so it can be eliminated
  
positive.code:         S?SQL_SELECT.'WHERE'
      ).
  
  less_than_or_equal_to_on_column_in_local_key_is_added_to_endkey_test() ->
      DDL = get_ddl(
          "CREATE TABLE table1("
  
negative.code:             %% query like `a = 10 AND a <= 10` the less than or equals can be
              %% eliminated because it is already captured in the equality filter
              {eliminate, Acc};
          #filtercheck{'<' = {_,_,{const,LtVal}}} when LteVal >= LtVal ->
              %% query like `a < 10 AND a <= 10` the less than or equals can be
              %% eliminated because it is already captured in the less than filter
              {eliminate, Acc};
          #filtercheck{'<=' = undefined} = Check1 ->
              %% this is the first less than check so just record it
              Check2 = Check1#filtercheck{'<=' = F},
  