3169218 - SAP ASE 16.0 SP04 PL01 Creating a view using a * column list within an ELSE clause may corrupt the view text in syscomments

Symptom

When creating a view using a * column list within an ELSE clause may corrupt the view text in syscomments. It triggers a signal 11 with the following functions:

traceassert
save_expanded_text
expand_ALL_nodes
colnames
colnames_recurse
colnames_driver
s_normquery
s__call_normquery

Assertion ('*' == expand_item->ptext_obuf->ob_chars [expand_item->obuf_offset-1]) failed in file /net/lsdub0042/data/build/ase160sp04pl01x/SMP/porttree/svr/sql/generic/source/sequencer/colnames.c line 8172

Environment

SAP Adaptive Server Enterprise : version 16.0 SP04 PL01

Product

SAP Adaptive Server Enterprise 16.0

Keywords

view, * column, list, ELSE clause, signal 11, traceassert, colnames, driver, recurse , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.