public void testLimitOnly() { var expected = "select sql_calc_found_rows * from emp order by emp.id limit 0, 10"; var transformer = new MysqlPagingTransformer(-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 MysqlPagingTransformer(offset, limit, rowNumberColumn); return(transformer.Transform(node)); }