Author: rareddy
Date: 2011-05-03 20:01:35 -0400 (Tue, 03 May 2011)
New Revision: 3144
Modified:
trunk/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/teradata/TeradataExecutionFactory.java
trunk/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/teradata/TestTeradataTranslator.java
Log:
TEIID-1495
Modified:
trunk/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/teradata/TeradataExecutionFactory.java
===================================================================
---
trunk/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/teradata/TeradataExecutionFactory.java 2011-05-03
21:08:27 UTC (rev 3143)
+++
trunk/connectors/translator-jdbc/src/main/java/org/teiid/translator/jdbc/teradata/TeradataExecutionFactory.java 2011-05-04
00:01:35 UTC (rev 3144)
@@ -291,12 +291,18 @@
public static class NumericToStringModifier extends FunctionModifier {
private int charSize;
+ private String formatCode;
public NumericToStringModifier(int size) {
this.charSize = size;
+ StringBuilder sb = new StringBuilder();
+ for(int i = 0; i < size; i++) {
+ sb.append('Z');
+ }
+ this.formatCode = sb.toString();
}
@Override
public List<?> translate(Function function) {
- return Arrays.asList("TRIM(BOTH FROM ",function.getParameters().get(0),
" (FORMAT 'Z')(CHAR("+this.charSize+")))"); //$NON-NLS-1$
//$NON-NLS-2$ //$NON-NLS-3$
+ return Arrays.asList("TRIM(BOTH FROM ",function.getParameters().get(0),
" (FORMAT
'"+this.formatCode+"')(CHAR("+this.charSize+")))");
//$NON-NLS-1$ //$NON-NLS-2$ //$NON-NLS-3$ //$NON-NLS-4$
}
}
}
Modified:
trunk/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/teradata/TestTeradataTranslator.java
===================================================================
---
trunk/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/teradata/TestTeradataTranslator.java 2011-05-03
21:08:27 UTC (rev 3143)
+++
trunk/connectors/translator-jdbc/src/test/java/org/teiid/translator/jdbc/teradata/TestTeradataTranslator.java 2011-05-04
00:01:35 UTC (rev 3144)
@@ -75,11 +75,11 @@
}
@Test public void testByteToString() throws Exception {
- helpTest(LANG_FACTORY.createLiteral(new Byte((byte)1), Byte.class),
"string", "TRIM(BOTH FROM 1 (FORMAT 'Z')(CHAR(4)))");
+ helpTest(LANG_FACTORY.createLiteral(new Byte((byte)1), Byte.class),
"string", "TRIM(BOTH FROM 1 (FORMAT 'ZZZZ')(CHAR(4)))");
}
@Test public void testDoubleToString() throws Exception {
- helpTest(LANG_FACTORY.createLiteral(new Double(1.0), Double.class),
"string", "TRIM(BOTH FROM 1.0 (FORMAT 'Z')(CHAR(25)))");
+ helpTest(LANG_FACTORY.createLiteral(new Double(1.0), Double.class),
"string", "TRIM(BOTH FROM 1.0 (FORMAT
'ZZZZZZZZZZZZZZZZZZZZZZZZZ')(CHAR(25)))");
}
@Test public void testInDecompose() throws Exception {
Show replies by date