Author: gbadner
Date: 2008-11-05 22:38:52 -0500 (Wed, 05 Nov 2008)
New Revision: 15525
Modified:
core/branches/Branch_3_2/test/org/hibernate/test/legacy/SQLFunctionsTest.java
Log:
HHH-3214 : Remove parens from sysdate() in HQL to fix oracle failure
Modified: core/branches/Branch_3_2/test/org/hibernate/test/legacy/SQLFunctionsTest.java
===================================================================
---
core/branches/Branch_3_2/test/org/hibernate/test/legacy/SQLFunctionsTest.java 2008-11-05
20:44:30 UTC (rev 15524)
+++
core/branches/Branch_3_2/test/org/hibernate/test/legacy/SQLFunctionsTest.java 2008-11-06
03:38:52 UTC (rev 15525)
@@ -81,7 +81,7 @@
if ( getDialect() instanceof Oracle9iDialect ) {
// Check Oracle Dialect mix of dialect functions - no args (no parenthesis and single
arg functions
- java.util.List rset = s.find("select s.name, sysdate(), trunc(s.pay),
round(s.pay) from Simple s");
+ java.util.List rset = s.find("select s.name, sysdate, trunc(s.pay), round(s.pay)
from Simple s");
assertNotNull("Name string should have been
returned",(((Object[])rset.get(0))[0]));
assertNotNull("Todays Date should have been
returned",(((Object[])rset.get(0))[1]));
assertEquals("trunc(45.8) result was incorrect ", new Float(45), (
(Object[]) rset.get(0) )[2] );
@@ -96,7 +96,7 @@
// Test a larger depth 3 function example - Not a useful combo other than for testing
assertTrue(
- s.find("select trunc(round(sysdate())) from Simple s").size() == 1
+ s.find("select trunc(round(sysdate)) from Simple s").size() == 1
);
// Test the oracle standard NVL funtion as a test of multi-param functions...
Show replies by thread