anchor.diff:              {ok, Sql8b, SF8b} = Result8a,
               Sorted8b = [{<<"1">>,<<"1">>},{<<"10">>,<<"10">>},{<<"11">>,<<"11">>},{<<"2">>,<<"2">>},{<<"3">>,<<"3">>}],
               ?assertEqual(Sorted8b, result_tuples_sort(List8a,SR8#stmtResult.rowFun, SF8b)),
  -            Expected8b = "select col1 c1, col2 from def where col1 < '4' order by col1 asc",
  +            Expected8b = "select col1 as c1, col2 from def where col1 < '4' order by col1 asc",
               ?assertEqual(Expected8b, string:strip(binary_to_list(Sql8b))),
   
               {ok, Sql8c, SF8c} = filter_and_sort(SKey, SR8, {'and',[{1,[<<"$in$">>,<<"1">>,<<"2">>,<<"3">>]}]}, [{?MainIdx,2,<<"asc">>}], [1], IsSec),
               ?assertEqual(Sorted8b, result_tuples_sort(List8a,SR8#stmtResult.rowFun, SF8c)),
               ?LogDebug("Sql8c ~p~n", [Sql8c]),
  -            Expected8c = "select col1 c1 from def where imem.def.col1 in ('1', '2', '3') and col1 < '4' order by col1 asc",
  +            Expected8c = "select col1 as c1 from def where imem.def.col1 in ('1', '2', '3') and col1 < '4' order by col1 asc",
               ?assertEqual(Expected8c, string:strip(binary_to_list(Sql8c))),
   
               {ok, Sql8d, SF8d} = filter_and_sort(SKey, SR8, {'or',[{1,[<<"$in$">>,<<"3">>]}]}, [{?MainIdx,2,<<"asc">>},{?MainIdx,3,<<"desc">>}], [2], IsSec),
  
positive.code:             ?assertEqual(ok, fetch_close(SKey, SR7b, IsSec))
          after
              ?assertEqual(ok, close(SKey, SR7b))
          end,
  
          SR8 = exec(SKey,query8, 100, IsSec, "
              select 
                    col1 as c1
  
negative.code:             false ->    none
          end,
  
          catch imem_meta:drop_table(def),
          catch imem_meta:drop_table(tuple_test),
          catch imem_meta:drop_table(fun_test),
  
          %% test table tuple_test
  
          ?assertEqual(ok, imem_sql:exec(SKey, "
              create table fun_test (
  