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

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

Next Topic: Query Wizard Simple Filter Fails with Special Characters

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.