Release Notes › Known Issues › Queries and Reports › Query Result Contains Garbage Values

Previous Topic: Unable to Delete Tags that Contain Special Characters

Next Topic: Query and Reports Pages Are Displaying Error Messages When the UI is Loading

Query Result Contains Garbage Values

Symptom:

When you select a SQL Function except TRIM, TOLOWER, TOUPPER or a Group Order setting for a column, and do not select the same setting for other columns, the query result contains garbage values.

Solution:

If you select a SQL Function except TRIM, TOLOWER, TOUPPER or a Group Order setting for a column, you must select the same setting for other columns too.