Subject Re: [firebird-support] Any idea how to resolve this error: 335544758 sort_rec_size_err
Author Dmitry Yemanov
"johncr0181" <johnc@...> wrote:
> "Sort record size of <number> bytes is too big"

The entire record is processed by the sorter module, so if you select all
fields of many joined tables you'll obviously hit the record size limit.

> I'm not sure where to start looking to resolve this any ideas would
> be gratefully appreciated.

Make sure all fields/expressions inside your select list occupy less than
64K bytes.