anchor.diff:              Acc2 = store_filter_check(Check2, Acc),
               Acc3 = append_to_eliminate_later(F_x, Acc2),
               {F, Acc3};
  +        #filtercheck{'<=' = {_,_,{const,LteVal}}} when LteVal < LtVal ->
  +            {eliminate, Acc};
           #filtercheck{'=' = {_,_,{const,EqVal}}} when LtVal > EqVal ->
               %% existing equality check is less, eliminate this `>` filter.
               {eliminate, Acc};
  
positive.code:         S?SQL_SELECT.'WHERE'
      ).
  
  less_than_filter_is_greater_than_less_than_or_equal_to_filter_on_the_same_column_test() ->
      DDL = get_ddl(
          "CREATE TABLE table1("
          "a TIMESTAMP NOT NULL, "
  
negative.code:         "PRIMARY KEY ((a),a,b))"),
      {ok, Q} = get_query(
          "SELECT * FROM table1 "
          "WHERE a = 5 AND b <= 10 AND b < 11"),
      {ok, [S]} = compile(DDL, Q),
      ?assertPropsEqual(
          [{startkey,[{<<"a">>,timestamp,5}]},
           {endkey,  [{<<"a">>,timestamp,5},{<<"b">>,sint64,10}]},
           {filter, {'<=',{field,<<"b">>,sint64},{const,10}}},
           {end_inclusive,true}],
          S?SQL_SELECT.'WHERE'
      ).
  
  '< eliminated when greater than <= on same column_swap_filter_order_test'() ->
      DDL = get_ddl(
          "CREATE TABLE table1("
          "a TIMESTAMP NOT NULL, "
  