• Type: Enhancement
• Resolution: Done
• Priority: Minor
• Fix Version/s: 10.0
• Affects Version/s: None
• Component/s: Query Engine
• Labels:

  None

[TEIID-5012] Add the VDB description and creation timestamp information to the Sys.Virtualdatabases table as new columns (Database Description, Database Creation timestamp)

Collapse comment: Steven Hawkins added a comment - 2017/10/05 5:10 PM

Steven Hawkins added a comment - 2017/10/05 5:10 PM

Marking as partially resolved as the description column was added. Since we use the vdb properties for potentially non-public information such as the security-domain we may not want to expose all of them via a sys table.

Expand comment: Steven Hawkins added a comment - 2017/10/05 5:10 PM

Steven Hawkins added a comment - 2017/10/05 5:10 PM Marking as partially resolved as the description column was added. Since we use the vdb properties for potentially non-public information such as the security-domain we may not want to expose all of them via a sys table.

Collapse comment: Steven Hawkins added a comment - 2017/09/27 3:05 PM

Steven Hawkins added a comment - 2017/09/27 3:05 PM

> that could instead be looked up in the properties

Actually it cannot. We don't add the properties to that table, nor is there a uid assigned to a vdb. I'll have to see if something else makes sense.

Expand comment: Steven Hawkins added a comment - 2017/09/27 3:05 PM

Steven Hawkins added a comment - 2017/09/27 3:05 PM > that could instead be looked up in the properties Actually it cannot. We don't add the properties to that table, nor is there a uid assigned to a vdb. I'll have to see if something else makes sense.

Collapse comment: Steven Hawkins added a comment - 2017/08/08 9:32 AM

Steven Hawkins added a comment - 2017/08/08 9:32 AM

Creation timestamp isn't defined as a formal property of the vdb metadata, that could instead be looked up in the properties. The description is possible to add though.

Expand comment: Steven Hawkins added a comment - 2017/08/08 9:32 AM

Steven Hawkins added a comment - 2017/08/08 9:32 AM Creation timestamp isn't defined as a formal property of the vdb metadata, that could instead be looked up in the properties. The description is possible to add though.