[TRAFODION-900] LP Bug: 1411541 - [DCS] query with long query text is missing from METRIC_QUERY_TABLE

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Component/s: connectivity-general
• External issue URL: https://bugs.launchpad.net/bugs/1411541
• Assignee: Rao Kakarlamudi
• Reporter: FengQiang
• Created: 22/Jul/15 21:18
• Updated: 06/Mar/18 19:14

Description

QUERY_TEXT is VARCHAR(50000 CHARS) in METRIC_QUERY_TABLE.
Set dcs.server.user.program.statistics.type to 'query' to publish every query.
When running a query with query text longer than 50000, it did not published to METRIC_QUERY_TABLE.
Should the query text be trimed to fit the datatype and got published?