Only the aggregate function COUNT (*) is supported for LONG BINARY and LONG VARCHAR columns. The COUNT DISTINCT parameter is not supported. An error is returned if a LONG BINARY or LONG VARCHAR column is used with the MIN, MAX, AVG, or SUM aggregate functions.
