Author: stliu Date: 2010-09-26 11:39:58 -0400 (Sun, 26 Sep 2010) New Revision: 20710 Modified: core/trunk/core/src/main/java/org/hibernate/dialect/AbstractTransactSQLDialect.java core/trunk/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java Log: HHH-5598 sybase ASE cannot handle select count(distinct c1, c2, c3) from t1. Modified: core/trunk/core/src/main/java/org/hibernate/dialect/AbstractTransactSQLDialect.java =================================================================== --- core/trunk/core/src/main/java/org/hibernate/dialect/AbstractTransactSQLDialect.java 2010-09-26 15:32:06 UTC (rev 20709) +++ core/trunk/core/src/main/java/org/hibernate/dialect/AbstractTransactSQLDialect.java 2010-09-26 15:39:58 UTC (rev 20710) @@ -265,4 +265,7 @@ public boolean doesRepeatableReadCauseReadersToBlockWriters() { return true; } + public boolean supportsTupleDistinctCounts() { + return false; + } } Modified: core/trunk/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java =================================================================== --- core/trunk/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java 2010-09-26 15:32:06 UTC (rev 20709) +++ core/trunk/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java 2010-09-26 15:39:58 UTC (rev 20710) @@ -160,7 +160,4 @@ return false; // here assume SQLServer2005 using snapshot isolation, which does not have this problem } - public boolean supportsTupleDistinctCounts() { - return false; - } }