anchor.diff:      ?assertPropsEqual(
           [{startkey,[{<<"a">>,timestamp,5}]},
            {endkey,  [{<<"a">>,timestamp,5}]},
  -         {filter, {'>',{field,<<"b">>,sint64},{const, 10}}},
  +         {filter, {'>',{field,<<"b">>,sint64},{const, 11}}},
            {end_inclusive,true}],
           S?SQL_SELECT.'WHERE'
       ).
  
positive.code:     ?assertPropsEqual(
          [{startkey,[{<<"a">>,timestamp,5}]},
           {endkey,  [{<<"a">>,timestamp,5}]},
           {filter, {'<=',{field,<<"b">>,sint64},{const,8}}},
           {end_inclusive,true}],
          S?SQL_SELECT.'WHERE'
      ).
  
negative.code:          {filter, {'<=',{field,<<"b">>,sint64},{const,10}}},
           {end_inclusive,true}],
          S?SQL_SELECT.'WHERE'
      ).
  
  less_than_or_equal_to_is_less_than_equality_filter_on_same_column_is_impossible_test() ->
      DDL = get_ddl(
          "CREATE TABLE table1("
          "a TIMESTAMP NOT NULL, "
          "b SINT64 NOT NULL, "
          "PRIMARY KEY ((a),a,b))"),
      {ok, Q} = get_query(
          "SELECT * FROM table1 "
          "WHERE a = 1 AND b <= 8 AND b = 10"),
      ?assertEqual(
          {error,{impossible_where_clause, << >>}},
          compile(DDL, Q)
      ).
  
  less_than_or_equal_to_is_less_than_equality_filter_on_same_column_is_impossible_swap_lhs_rhs_test() ->
      DDL = get_ddl(
          "CREATE TABLE table1("
          "a TIMESTAMP NOT NULL, "
          "b SINT64 NOT NULL, "
          "PRIMARY KEY ((a),a,b))"),
      {ok, Q} = get_query(
          "SELECT * FROM table1 "
          "WHERE a = 5 AND b < 11 AND b <= 10"),
      {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'
      ).
  
  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, "
          "b SINT64 NOT NULL, "
          "PRIMARY KEY ((a),a,b))"),
      {ok, Q} = get_query(
          "SELECT * FROM table1 "
          "WHERE a = 1 AND b = 10 AND b <= 8"),
      ?assertEqual(
          {error,{impossible_where_clause, << >>}},
          compile(DDL, Q)
      ).
  
  desc_query_with_additional_column_in_local_key_test() ->
  