[teiid-commits] teiid SVN: r2648 - branches/7.1.x/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/oracle.
Author: shawkins
Date: 2010-10-14 10:29:39 -0400 (Thu, 14 Oct 2010)
New Revision: 2648
Modified:
branches/7.1.x/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/oracle/TestOracleConvertModifier.java
Log:
TEIID-1303 fix for sybase timestamp to string and full outer join handling. also updated
literal handling to work with JTDS
Modified:
branches/7.1.x/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/oracle/TestOracleConvertModifier.java
===================================================================
---
branches/7.1.x/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/oracle/TestOracleConvertModifier.java 2010-10-13
22:00:11 UTC (rev 2647)
+++
branches/7.1.x/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/oracle/TestOracleConvertModifier.java 2010-10-14
14:29:39 UTC (rev 2648)
@@ -487,11 +487,11 @@
// Source = TIME
@Test public void testTimeToString() throws Exception {
- helpTest(LANG_FACTORY.createLiteral(TimestampUtil.createTime(23, 59, 59),
java.sql.Time.class), "string", "to_char({ts '1970-01-01
23:59:59'}, 'HH24:MI:SS')"); //$NON-NLS-1$ //$NON-NLS-2$
+ helpTest(LANG_FACTORY.createLiteral(TimestampUtil.createTime(23, 59, 59),
java.sql.Time.class), "string", "to_char(to_date('1970-01-01
23:59:59', 'YYYY-MM-DD HH24:MI:SS'), 'HH24:MI:SS')");
//$NON-NLS-1$ //$NON-NLS-2$
}
@Test public void testTimeToTimestamp() throws Exception {
- helpTest(LANG_FACTORY.createLiteral(TimestampUtil.createTime(23, 59, 59),
java.sql.Time.class), "timestamp", "cast({ts '1970-01-01 23:59:59'}
AS timestamp)"); //$NON-NLS-1$ //$NON-NLS-2$
+ helpTest(LANG_FACTORY.createLiteral(TimestampUtil.createTime(23, 59, 59),
java.sql.Time.class), "timestamp", "cast(to_date('1970-01-01
23:59:59', 'YYYY-MM-DD HH24:MI:SS') AS timestamp)"); //$NON-NLS-1$
//$NON-NLS-2$
}
// Source = TIMESTAMP