I found a strange limitation on record length in a select query which I
like to understand. I know there is a row limitation of 8088 bytes, but
I thought that was on storage, not on retrieval.

SAPDB might create a temporary table and the result within that table. therefor the rows of a result are also limited to the 8KB row-limit.
That sucks, especially because SAPDB also puts other implicit columns into the result-set. for example an "ORDER BY test" causes the column "test" to be included in the result-set, even if it was not selected.
You may be the victom of such implicit/hidden columns.




--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to