anchor.diff:            "SELECT * FROM tababa WHERE a = 1000 AND b = 'bval' AND c = 3.5 AND d = true"),
       {ok, [Select]} = compile(DDL, Q),
       Key =
  -        [{<<"c">>,double,3.5}, {<<"a">>,sint64,1000},{<<"b">>,varchar,<<"bval">>}],
  -    ?assertEqual(
  +        [{<<"c">>,double,3.5}, {<<"a">>,sint64,1000},{<<"b">>,varchar,<<"bval">>},{<<"d">>,boolean,true}],
  +    ?assertPropsEqual(
           [{startkey, Key},
            {endkey, Key},
            {filter,{'=',{field,<<"d">>,boolean},{const, true}}},
  +         {start_inclusive,true},
            {end_inclusive,true}],
           Select?SQL_SELECT.'WHERE'
       ).
  
positive.code:     {ok, [Select]} = compile(DDL, Q),
      Key =
          [{<<"c">>,double,3.5}, {<<"a">>,sint64,1000},{<<"b">>,varchar,<<"bval">>}],
      ?assertEqual(
          [{startkey, Key},
           {endkey, Key},
           {filter,[]},
  
negative.code:     {ok, Q} = get_query(
            "SELECT * FROM tab4 WHERE a > 0 AND a < 1000 AND a1 = 1"),
      {ok, [Select]} = compile(DDL, Q),
      ?assertPropsEqual(
          [{startkey,[{<<"a1">>,sint64,1}, {<<"a">>,timestamp,1}]},
            {endkey, [{<<"a1">>,sint64,1}, {<<"a">>,timestamp,1000}]},
            {filter,[]}],
  