3504244 - Database server crashes or returns assertion error 106900 for complex query - SQL Anywhere

Under rare circumstances, the database server may crash or return assertion error 106900 "Expression value unexpectedly NULL in read" for a complex query that uses Prefilter operators and outer joins. The problem happens if the query references a view that contains a type casting of a constant in its select list, for example "cast(41 as numeric(2)) Col2" in below view definition:

create or replace view V1 as
select  distinct 
        T1.b1 as Col1, 
        cast(41 as numeric(2)) Col2
from    T1 left outer join T2
           on T1.a1 = T2.a2

SAP SQL Anywhere 17

SQA, SQAny, SQLAnywhere, data type, column, QTS , KBA , BC-SYB-SQA-OTH , SQL Anywhere - other (install, docs, etc.) , Problem