Author: shawkins
Date: 2010-01-24 23:30:54 -0500 (Sun, 24 Jan 2010)
New Revision: 1778
Modified:
trunk/connectors/connector-jdbc/src/main/java/org/teiid/connector/jdbc/mysql/MySQLTranslator.java
trunk/connectors/connector-jdbc/src/test/java/org/teiid/connector/jdbc/mysql/TestMySQLTranslator.java
Log:
TEIID-934 boolean is not a valid type conversion, changing to signed.
Modified:
trunk/connectors/connector-jdbc/src/main/java/org/teiid/connector/jdbc/mysql/MySQLTranslator.java
===================================================================
---
trunk/connectors/connector-jdbc/src/main/java/org/teiid/connector/jdbc/mysql/MySQLTranslator.java 2010-01-25
03:26:22 UTC (rev 1777)
+++
trunk/connectors/connector-jdbc/src/main/java/org/teiid/connector/jdbc/mysql/MySQLTranslator.java 2010-01-25
04:30:54 UTC (rev 1778)
@@ -72,7 +72,7 @@
registerFunctionModifier(SourceSystemFunctions.RPAD, new PadFunctionModifier());
//add in type conversion
ConvertModifier convertModifier = new ConvertModifier();
- convertModifier.addTypeMapping("signed", FunctionModifier.BYTE,
FunctionModifier.SHORT, FunctionModifier.INTEGER, FunctionModifier.LONG); //$NON-NLS-1$
+ convertModifier.addTypeMapping("signed", FunctionModifier.BOOLEAN,
FunctionModifier.BYTE, FunctionModifier.SHORT, FunctionModifier.INTEGER,
FunctionModifier.LONG); //$NON-NLS-1$
//char(n) assume 4.1 or later
convertModifier.addTypeMapping("char(1)", FunctionModifier.CHAR);
//$NON-NLS-1$
convertModifier.addTypeMapping("char", FunctionModifier.STRING);
//$NON-NLS-1$
Modified:
trunk/connectors/connector-jdbc/src/test/java/org/teiid/connector/jdbc/mysql/TestMySQLTranslator.java
===================================================================
---
trunk/connectors/connector-jdbc/src/test/java/org/teiid/connector/jdbc/mysql/TestMySQLTranslator.java 2010-01-25
03:26:22 UTC (rev 1777)
+++
trunk/connectors/connector-jdbc/src/test/java/org/teiid/connector/jdbc/mysql/TestMySQLTranslator.java 2010-01-25
04:30:54 UTC (rev 1778)
@@ -333,4 +333,13 @@
output, TRANSLATOR);
}
+ @Test public void testBooleanToString() throws Exception {
+ String input = "SELECT convert(INTKEY, boolean) FROM BQT1.SmallA ORDER BY
INTKEY"; //$NON-NLS-1$
+ String output = "SELECT CASE WHEN SmallA.IntKey = 0 THEN 0 WHEN
SmallA.IntKey IS NOT NULL THEN 1 END FROM SmallA ORDER BY INTKEY"; //$NON-NLS-1$
+
+ TranslationHelper.helpTestVisitor(TranslationHelper.BQT_VDB,
+ input,
+ output, TRANSLATOR);
+ }
+
}
Show replies by date