Details
-
Bug
-
Resolution: Done
-
Major
-
8.12.13.6_4
-
None
Description
When using automatic procedure import from SQL Server (I used 2016) with a model like this:
<model name="mymodel">
<property name="importer.useFullSchemaName" value="false"/>
<property name="importer.UseQualifiedName" value="false" />
<property name="importer.procedureNamePattern" value="echo%"/>
<property name="importer.importProcedures" value="true" />
<source connection-jndi-name="java:/mssql2016"
name="mySource" translator-name="sqlserver" />
</model>
There is a procedure named echo in SQL server. It is imported into the VDB as "mymodel"."echo;1" (not sure why the ;1). When I afterwards try to execute it using
EXEC "mymodel"."echo;1"();
, I will get this exception from SQL server which suggests that Teiid mapped the procedure to the wrong name in the source database:
com.microsoft.sqlserver.jdbc.SQLServerException: Could not find stored procedure 'echo;1'.
