Author: shawkins Date: 2010-03-03 20:31:04 -0500 (Wed, 03 Mar 2010) New Revision: 1895 Modified: trunk/test-integration/common/src/test/java/com/metamatrix/connector/jdbc/extension/TestSQLConversionVisitor.java Log: TEIID-989 adding an unrelated order by test Modified: trunk/test-integration/common/src/test/java/com/metamatrix/connector/jdbc/extension/TestSQLConversionVisitor.java =================================================================== --- trunk/test-integration/common/src/test/java/com/metamatrix/connector/jdbc/extension/TestSQLConversionVisitor.java 2010-03-03 23:08:18 UTC (rev 1894) +++ trunk/test-integration/common/src/test/java/com/metamatrix/connector/jdbc/extension/TestSQLConversionVisitor.java 2010-03-04 01:31:04 UTC (rev 1895) @@ -441,5 +441,14 @@ input, output, TRANSLATOR); } + + @Test public void testOrderByUnrelated() throws Exception { + String input = "select part_id id FROM parts order by part_name"; //$NON-NLS-1$ + String output = "SELECT rtrim(PARTS.PART_ID) AS id FROM PARTS ORDER BY PARTS.PART_NAME"; //$NON-NLS-1$ + + TranslationHelper.helpTestVisitor(TranslationHelper.PARTS_VDB, + input, + output, TRANSLATOR); + } }