-
1. Re: Custom properties not getting picked up in Teiid 8.3 Beta1
rareddy Feb 26, 2013 9:31 AM (in response to onkar.dhuri)Onkur,
Log bug in JIRA with a sample VDB (Dynamic VDB) and query you are using.
Ramesh..
-
2. Re: Custom properties not getting picked up in Teiid 8.3 Beta1
shawkins Feb 26, 2013 9:51 AM (in response to rareddy)1 of 1 people found this helpfulThe vdb will likely not be useful if it references sources. Just the ddl and system query would be sufficient - can you do an export of the relevant schema(s)?. I can see from our unit tests that a SELECT * FROM SYS.PROPERTIES will return all properties, multiple values on columns etc. So it's not clear what you are seeing.
-
3. Re: Custom properties not getting picked up in Teiid 8.3 Beta1
onkar.dhuri Feb 26, 2013 12:43 PM (in response to shawkins)Yes, even I can see those properties when I do "Select * from SYS.Properties"
However, there is an existing join query which selects data from sys.columns and sys.properties, which works with Teiid 8.1
"select c.TableName,c.Name ,c.SupportsUpdates, p.Name as PropertyName, p.Value as PropertyValue from sys.Columns c LEFT OUTER JOIN sys.Properties p ON p.UID=c.UID where c.SchemaName = '5000_10"where '5000_10' is the model name.
But when I try to execute same query against Teiid 8.3, it gives out just one property per column.
I tried to modify the query but it was giving unexpected results with each combination I tried.
To my surprise, the query works fine for single table and with Like clause -
"select c.TableName, c.Name, c.SupportsUpdates, p.Name as PropertyName, p.Value as PropertyValue from sys.Columns c LEFT OUTER JOIN sys.Properties p ON p.UID=c.UID where c.TableName = 'Activity' and p.name like '5000_10%'but fails for all tables with where clause = "where p.name like '5000_10%'" giving only one property per column.
Can you please let me know why the original query fails in case Teiid 8.3 ?
-
4. Re: Custom properties not getting picked up in Teiid 8.3 Beta1
shawkins Feb 26, 2013 1:24 PM (in response to onkar.dhuri)This is a regression with https://issues.jboss.org/browse/TEIID-2334 The properties table uid is being marked as unique, which is not correct.
Steve
-
5. Re: Custom properties not getting picked up in Teiid 8.3 Beta1
shawkins Feb 26, 2013 2:21 PM (in response to shawkins)The fix will also be in CR1.