public void testLimitOnly()
{
var expected = "select * from emp order by emp.id limit 10 offset 0";
var transformer = new SqlitePagingTransformer(-1, 10, null);
var parser = new DomaSqlParser("select * from emp order by emp.id");
var node = transformer.Transform(parser.Parse());
var parameters = new List <ParameterEmulator>();
var builder = new DomaSqlBuilder(node, parameters, _config);
var result = builder.Build();
result.ParsedSql.Is(expected);
}
internal override ISqlNode ToPagingSqlNode(ISqlNode node, long offset, long limit, string rowNumberColumn)
{
var transformer = new SqlitePagingTransformer(offset, limit, rowNumberColumn);
return(transformer.Transform(node));
}
