-
1. Re: Duplicate a view
shawkins May 5, 2015 4:10 PM (in response to jkhoury)It is fine to have the same view name in two different schemas. However the sql shown above is a scalar subquery which can return at most one row. So by effectively only specifying the name there is an exception. When/where is this subquery running?
-
2. Re: Duplicate a view
jkhoury May 6, 2015 1:28 AM (in response to shawkins)I am getting this error when i try to laod the view
PreparedStatement prepareStatement = teiidServer.getConnection().prepareStatement("execute SYSADMIN.loadMatView('" + viewModelName + "','" + imView.getName() + "' ) ");
ApplicationBeanUtils.getDataBoxService().dropViewIndices(imView, webAppCache.getDomainDataDb());
prepareStatement.executeUpdate();
-
3. Re: Duplicate a view
shawkins May 6, 2015 8:23 AM (in response to jkhoury)I don't see where that sql would be in the system procedure, what version of Teiid are you using?
-
-
5. Re: Duplicate a view
shawkins May 6, 2015 9:28 AM (in response to jkhoury)I see, yes there is bug in the procedure definition. It has the predicate schemaName = schemaName, which the rewriter is converting to schemaName is not null. It should be schemaName = VARIABLES.schemaName
-
6. Re: Duplicate a view
shawkins May 6, 2015 12:34 PM (in response to shawkins)Logged as [TEIID-3468] Exception with same table name in materialization procedures - JBoss Issue Tracker which will be 8.11 Beta2.
-
7. Re: Duplicate a view
jkhoury May 7, 2015 2:26 AM (in response to shawkins)I tried the fix and it worked..
Thanks