Revision 40877

View differences:

trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc/src/main/java/org/gvsig/fmap/dal/store/jdbc/JDBCStoreProvider.java
661 661
	}
662 662

  
663 663
	protected String compoundCountSelect(String filter) {
664
		if (this.directSQLMode) {
665
			return null;
666
		}
664

  
667 665
		// Select
668 666
		StringBuilder sql = new StringBuilder();
669 667
		sql.append("Select count(");
......
677 675
		sql.append(") ");
678 676

  
679 677
		sql.append("from ");
680

  
681
		sql.append(getJDBCParameters().tableID());
678
		if (this.directSQLMode) {
679
			sql.append("(");
680
			sql.append(getJDBCParameters().getSQL());
681
			sql.append(") as _subquery_alias_ ");
682
		} else {
683
			sql.append(getJDBCParameters().tableID());
684
		}
682 685
		sql.append(' ');
683 686

  
684 687
		appendWhere(sql, filter);

Also available in: Unified diff