[teiid-commits] teiid SVN: r4336 - trunk/engine/src/test/java/org/teiid/query/resolver.

Author: shawkins Date: 2012-08-16 13:50:14 -0400 (Thu, 16 Aug 2012) New Revision: 4336 Modified: trunk/engine/src/test/java/org/teiid/query/resolver/TestProcedureResolving.java Log: TEIID-2150 adding another test Modified: trunk/engine/src/test/java/org/teiid/query/resolver/TestProcedureResolving.java =================================================================== --- trunk/engine/src/test/java/org/teiid/query/resolver/TestProcedureResolving.java 2012-08-16 17:46:48 UTC (rev 4335) +++ trunk/engine/src/test/java/org/teiid/query/resolver/TestProcedureResolving.java 2012-08-16 17:50:14 UTC (rev 4336) @@ -1046,4 +1046,21 @@ assertEquals(new Constant("a", DataTypeManager.DefaultDataClasses.STRING), sp.getParameter(2).getExpression()); } + @Test public void testOptionalParams1() throws Exception { + VDBMetaData vdb = new VDBMetaData(); + MetadataStore store = new MetadataStore(); + String ddl = "create foreign procedure proc (x integer, y string NOT NULL, z integer);\n"; + TestMetadataValidator.buildModel("x", true, vdb, store, ddl); + TransformationMetadata tm = new TransformationMetadata(vdb, new CompositeMetadataStore(Arrays.asList(store)), null, RealMetadataFactory.SFM.getSystemFunctions(), null); + vdb.addAttchment(TransformationMetadata.class, tm); + vdb.addAttchment(QueryMetadataInterface.class, tm); + new MetadataValidator().validate(vdb, store); + + String sql = "call proc (1, 'a')"; //$NON-NLS-1$ + + StoredProcedure sp = (StoredProcedure) TestResolver.helpResolve(sql, tm); + + assertEquals(new Constant("a", DataTypeManager.DefaultDataClasses.STRING), sp.getParameter(2).getExpression()); + } + }