BUG: Declare Cursor May Fail with Memory Error 702

MORE INFORMATION

The scenario tested in this case had 26 coalesce statements involving the aggregate function sum, as in the following:

   coalesce(sum(x),0)
				

The select list also included two more columns; however, the total length of all columns did not exceed 1,962 bytes. The where clause had four conditions anded together, and there was a group by.

When run outside of the declare cursor, the select statement ran to completion.

Testing showed that the type of cursor does not matter, nor does replacing coalesce with searched case. However, the error did not happen if one of the following was done:

• One of the columns in the select clause was removed.
• The group by was removed.
• All coalesce statements were removed from all columns.
• One condition in the where clause was sacrificed.