Hibernate SVN: r15711 - core/branches/Branch_3_2/test/org/hibernate/test/hql.
by hibernate-commits@lists.jboss.org
Author: gbadner
Date: 2008-12-19 15:55:04 -0500 (Fri, 19 Dec 2008)
New Revision: 15711
Modified:
core/branches/Branch_3_2/test/org/hibernate/test/hql/ASTParserLoadingTest.java
Log:
HHH-3670 - Invalid test for str() for SQL Server and Sybase
Modified: core/branches/Branch_3_2/test/org/hibernate/test/hql/ASTParserLoadingTest.java
===================================================================
--- core/branches/Branch_3_2/test/org/hibernate/test/hql/ASTParserLoadingTest.java 2008-12-19 20:54:13 UTC (rev 15710)
+++ core/branches/Branch_3_2/test/org/hibernate/test/hql/ASTParserLoadingTest.java 2008-12-19 20:55:04 UTC (rev 15711)
@@ -1191,13 +1191,18 @@
Animal an = new Animal();
an.setBodyWeight(123.45f);
session.persist(an);
- String str = (String) session.createQuery("select str(an.bodyWeight) from Animal an where str(an.bodyWeight) like '123%' or str(an.bodyWeight) like '1.23%'").uniqueResult();
+ String str = (String) session.createQuery("select str(an.bodyWeight) from Animal an where str(an.bodyWeight) like '%1%'").uniqueResult();
if ( getDialect() instanceof DB2Dialect ) {
assertTrue( str.startsWith("1.234") );
}
- else if ( getDialect() instanceof SQLServerDialect ) {
- // no assertion as SQLServer always returns nulls here; even trying directly against the
- // database, it seems to have problems with str() in the where clause...
+ else if ( getDialect() instanceof SybaseDialect ) {
+ // str(val) on sybase assumes a default of 10 characters with no decimal point or decimal values
+ // str(val) on sybase result is right-justified
+ assertEquals( str.length(), 10 );
+ assertTrue( str.endsWith("123") );
+ str = (String) session.createQuery("select str(an.bodyWeight, 8, 3) from Animal an where str(an.bodyWeight, 8, 3) like '%1%'").uniqueResult();
+ assertEquals( str.length(), 8 );
+ assertTrue( str.endsWith( "123.450" ) );
}
else {
assertTrue( str.startsWith("123.4") );
17 years, 4 months
Hibernate SVN: r15710 - core/branches/Branch_3_2_4_SP1_CP/test/org/hibernate/test/hql.
by hibernate-commits@lists.jboss.org
Author: gbadner
Date: 2008-12-19 15:54:13 -0500 (Fri, 19 Dec 2008)
New Revision: 15710
Modified:
core/branches/Branch_3_2_4_SP1_CP/test/org/hibernate/test/hql/ASTParserLoadingTest.java
Log:
JBPAPP-1523 HHH-3670 - Invalid test for str() for SQL Server and Sybase
Modified: core/branches/Branch_3_2_4_SP1_CP/test/org/hibernate/test/hql/ASTParserLoadingTest.java
===================================================================
--- core/branches/Branch_3_2_4_SP1_CP/test/org/hibernate/test/hql/ASTParserLoadingTest.java 2008-12-19 19:05:29 UTC (rev 15709)
+++ core/branches/Branch_3_2_4_SP1_CP/test/org/hibernate/test/hql/ASTParserLoadingTest.java 2008-12-19 20:54:13 UTC (rev 15710)
@@ -1152,13 +1152,18 @@
Animal an = new Animal();
an.setBodyWeight(123.45f);
session.persist(an);
- String str = (String) session.createQuery("select str(an.bodyWeight) from Animal an where str(an.bodyWeight) like '123%' or str(an.bodyWeight) like '1.23%'").uniqueResult();
+ String str = (String) session.createQuery("select str(an.bodyWeight) from Animal an where str(an.bodyWeight) like '%1%'").uniqueResult();
if ( getDialect() instanceof DB2Dialect ) {
assertTrue( str.startsWith("1.234") );
}
- else if ( getDialect() instanceof SQLServerDialect ) {
- // no assertion as SQLServer always returns nulls here; even trying directly against the
- // database, it seems to have problems with str() in the where clause...
+ else if ( getDialect() instanceof SybaseDialect ) {
+ // str(val) on sybase assumes a default of 10 characters with no decimal point or decimal values
+ // str(val) on sybase result is right-justified
+ assertEquals( str.length(), 10 );
+ assertTrue( str.endsWith("123") );
+ str = (String) session.createQuery("select str(an.bodyWeight, 8, 3) from Animal an where str(an.bodyWeight, 8, 3) like '%1%'").uniqueResult();
+ assertEquals( str.length(), 8 );
+ assertTrue( str.endsWith( "123.450" ) );
}
else {
assertTrue( str.startsWith("123.4") );
17 years, 4 months
Hibernate SVN: r15709 - core/trunk/core/src/main/java/org/hibernate/dialect.
by hibernate-commits@lists.jboss.org
Author: gbadner
Date: 2008-12-19 14:05:29 -0500 (Fri, 19 Dec 2008)
New Revision: 15709
Modified:
core/trunk/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java
core/trunk/core/src/main/java/org/hibernate/dialect/SybaseDialect.java
Log:
HHH-3508 - SybaseDialect overrides supportsCascadeDelete to return "false"; SQLServerDialect returns "true"
Modified: core/trunk/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java
===================================================================
--- core/trunk/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java 2008-12-19 19:04:41 UTC (rev 15708)
+++ core/trunk/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java 2008-12-19 19:05:29 UTC (rev 15709)
@@ -138,6 +138,10 @@
return false;
}
+ public boolean supportsCascadeDelete() {
+ return true;
+ }
+
public boolean supportsCircularCascadeDeleteConstraints() {
// SQL Server (at least up through 2005) does not support defining
// cascade delete constraints which can circel back to the mutating
Modified: core/trunk/core/src/main/java/org/hibernate/dialect/SybaseDialect.java
===================================================================
--- core/trunk/core/src/main/java/org/hibernate/dialect/SybaseDialect.java 2008-12-19 19:04:41 UTC (rev 15708)
+++ core/trunk/core/src/main/java/org/hibernate/dialect/SybaseDialect.java 2008-12-19 19:05:29 UTC (rev 15709)
@@ -243,6 +243,10 @@
// Overridden informational metadata ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ public boolean supportsCascadeDelete() {
+ return false;
+ }
+
public boolean supportsEmptyInList() {
return false;
}
17 years, 4 months
Hibernate SVN: r15708 - core/branches/Branch_3_3/core/src/main/java/org/hibernate/dialect.
by hibernate-commits@lists.jboss.org
Author: gbadner
Date: 2008-12-19 14:04:41 -0500 (Fri, 19 Dec 2008)
New Revision: 15708
Modified:
core/branches/Branch_3_3/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java
core/branches/Branch_3_3/core/src/main/java/org/hibernate/dialect/SybaseDialect.java
Log:
HHH-3508 - SybaseDialect overrides supportsCascadeDelete to return "false"; SQLServerDialect returns "true"
Modified: core/branches/Branch_3_3/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java
===================================================================
--- core/branches/Branch_3_3/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java 2008-12-19 19:04:01 UTC (rev 15707)
+++ core/branches/Branch_3_3/core/src/main/java/org/hibernate/dialect/SQLServerDialect.java 2008-12-19 19:04:41 UTC (rev 15708)
@@ -138,6 +138,10 @@
return false;
}
+ public boolean supportsCascadeDelete() {
+ return true;
+ }
+
public boolean supportsCircularCascadeDeleteConstraints() {
// SQL Server (at least up through 2005) does not support defining
// cascade delete constraints which can circel back to the mutating
Modified: core/branches/Branch_3_3/core/src/main/java/org/hibernate/dialect/SybaseDialect.java
===================================================================
--- core/branches/Branch_3_3/core/src/main/java/org/hibernate/dialect/SybaseDialect.java 2008-12-19 19:04:01 UTC (rev 15707)
+++ core/branches/Branch_3_3/core/src/main/java/org/hibernate/dialect/SybaseDialect.java 2008-12-19 19:04:41 UTC (rev 15708)
@@ -243,6 +243,10 @@
// Overridden informational metadata ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ public boolean supportsCascadeDelete() {
+ return false;
+ }
+
public boolean supportsEmptyInList() {
return false;
}
17 years, 4 months
Hibernate SVN: r15707 - core/branches/Branch_3_2/src/org/hibernate/dialect.
by hibernate-commits@lists.jboss.org
Author: gbadner
Date: 2008-12-19 14:04:01 -0500 (Fri, 19 Dec 2008)
New Revision: 15707
Modified:
core/branches/Branch_3_2/src/org/hibernate/dialect/SQLServerDialect.java
core/branches/Branch_3_2/src/org/hibernate/dialect/SybaseDialect.java
Log:
HHH-3508 - SybaseDialect overrides supportsCascadeDelete to return "false"; SQLServerDialect returns "true"
Modified: core/branches/Branch_3_2/src/org/hibernate/dialect/SQLServerDialect.java
===================================================================
--- core/branches/Branch_3_2/src/org/hibernate/dialect/SQLServerDialect.java 2008-12-19 19:02:43 UTC (rev 15706)
+++ core/branches/Branch_3_2/src/org/hibernate/dialect/SQLServerDialect.java 2008-12-19 19:04:01 UTC (rev 15707)
@@ -116,6 +116,10 @@
return false;
}
+ public boolean supportsCascadeDelete() {
+ return true;
+ }
+
public boolean supportsCircularCascadeDeleteConstraints() {
// SQL Server (at least up through 2005) does not support defining
// cascade delete constraints which can circel back to the mutating
Modified: core/branches/Branch_3_2/src/org/hibernate/dialect/SybaseDialect.java
===================================================================
--- core/branches/Branch_3_2/src/org/hibernate/dialect/SybaseDialect.java 2008-12-19 19:02:43 UTC (rev 15706)
+++ core/branches/Branch_3_2/src/org/hibernate/dialect/SybaseDialect.java 2008-12-19 19:04:01 UTC (rev 15707)
@@ -220,6 +220,10 @@
// Overridden informational metadata ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ public boolean supportsCascadeDelete() {
+ return false;
+ }
+
public boolean supportsEmptyInList() {
return false;
}
17 years, 4 months
Hibernate SVN: r15706 - core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect.
by hibernate-commits@lists.jboss.org
Author: gbadner
Date: 2008-12-19 14:02:43 -0500 (Fri, 19 Dec 2008)
New Revision: 15706
Modified:
core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SQLServerDialect.java
core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SybaseDialect.java
Log:
JBPAPP-1519 HHH-3508 - SybaseDialect overrides supportsCascadeDelete to return "false"; SQLServerDialect returns "true"
Modified: core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SQLServerDialect.java
===================================================================
--- core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SQLServerDialect.java 2008-12-18 16:21:24 UTC (rev 15705)
+++ core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SQLServerDialect.java 2008-12-19 19:02:43 UTC (rev 15706)
@@ -116,6 +116,10 @@
return false;
}
+ public boolean supportsCascadeDelete() {
+ return true;
+ }
+
public boolean supportsCircularCascadeDeleteConstraints() {
// SQL Server (at least up through 2005) does not support defining
// cascade delete constraints which can circel back to the mutating
Modified: core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SybaseDialect.java
===================================================================
--- core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SybaseDialect.java 2008-12-18 16:21:24 UTC (rev 15705)
+++ core/branches/Branch_3_2_4_SP1_CP/src/org/hibernate/dialect/SybaseDialect.java 2008-12-19 19:02:43 UTC (rev 15706)
@@ -220,6 +220,10 @@
// Overridden informational metadata ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ public boolean supportsCascadeDelete() {
+ return false;
+ }
+
public boolean supportsEmptyInList() {
return false;
}
17 years, 4 months