case K_OFFSET: limit = Limit(); plainSelect.setLimit(limit); break; default:
plainSelect.setLimit(limit); } else {
@Override public void visit( PlainSelect plainSelect ) { plainSelect.setLimit( limit ); pagingSql = plainSelect.toString(); logger.debug( "Build paging sql: {}", pagingSql ); plainSelect.setLimit( null ); plainSelect.getSelectItems().clear(); plainSelect.setSelectItems( createCountFunction() ); countingSql.add( plainSelect.toString() ); logger.debug( "Build counting sql: {}", countingSql ); }
public PlainSelect addLimit(PlainSelect selectBody, int maxLimit) { Limit limitExpression = new Limit(); limitExpression.setRowCount(new LongValue(maxLimit)); selectBody.setLimit(limitExpression); return selectBody; }
@Override public void visit( SetOperationList setOpList ) { List<SelectBody> selects; int index; for ( SetOperation ops : setOpList.getOperations() ) { if ( "union all".equalsIgnoreCase( ops.getASTNode().jjtGetValue().toString() ) ) { selects = setOpList.getSelects(); for ( index = ops.getASTNode().jjtGetNumChildren() - 1; index >= 0; index -= 1 ) { ( ( PlainSelect ) selects.get( index ) ).setUseBrackets( true ); } } } setOpList.setLimit( limit ); pagingSql = setOpList.toString(); logger.debug( "Build paging sql: {}", pagingSql ); PlainSelect plainSelect; for ( SelectBody select : setOpList.getSelects() ) { plainSelect = ( PlainSelect ) select; plainSelect.setLimit( null ); plainSelect.setUseBrackets( false ); plainSelect.getSelectItems().clear(); plainSelect.setSelectItems( createCountFunction() ); countingSql.add( plainSelect.toString() ); } logger.debug( "Build counting sql: {}", countingSql ); }
case K_OFFSET:{ limit = Limit(); plainSelect.setLimit(limit); break;
case K_OFFSET:{ limit = Limit(); plainSelect.setLimit(limit); break;
plainSelect.setLimit(limit); } else {