[teiid-issues] [JBoss JIRA] (TEIID-3331) Problem with dynamic vdb column metadata - for salesforce source w/import property

Problem with dynamic vdb column metadata - for salesforce source w/import property ---------------------------------------------------------------------------------- Key: TEIID-3331 URL: https://issues.jboss.org/browse/TEIID-3331 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 8.7 Reporter: Mark Drilling Assignee: Ramesh Reddy Labels: CR2 Fix For: 8.10 Attachments: SFVdb-vdb.xml There seems to be a problem with the column metadata for dynamic vdb with salesforce source. Here is my scenario. 1) Deploy dynamic vdb w/SF source (attached sample). The VDB sets the 'importer.ModelAuditFields' property to 'true'. 2) expose the vdb as a jdbc source, then connect to it. 3) get the column metadata for a table using connection.getMetaData().getColumns(null, null, fullTableName, null) When the vdb has 'importer.ModelAuditFields' = true, some of the columns are missing. Here is a comparison for one of the SF tables AccountFeed, (importer.modelAuditFields=false) -------------- Id, ParentId, Type, IsDeleted, CommentCount, LikeCount AccountFeed, (importer.modelAuditFields=true) -------------- Id, ParentId, Type, CreatedById, CreatedDate, IsDeleted with modelAuditFields=true, the audit fields (CreatedById, CreatedDate) are added, but CommentCount and LikeCount are missing. It seems to clip to the same number of cols as the modelAuditFields=false case. Second issue (minor) ----------------- The display name for the property is slightly wrong. line 75 of SalesForceExecutionFactory is 'Audit Model Fields' - it should be 'Model Audit Fields'. line 362 of SalesForceMetadataProcessor - same thing. also suggest changing the description to something like 'Determines if the salesforce audit fields are modeled'