1934015 - Error: INSERT ON EXISTING UPDATE with CASCADE in blank-padded database could fail with "SQLCODE -198 : Primary key for row in table 'parent_table' is referenced by foreign key 'child_table_fk'"

Using a build of SQL Anywhere lower than 11.0.1.2569, 12.0.0.2652 and 12.0.1.3297
Using a blank-padded database ("dbinit -b")
Using an INSERT ON EXISTING UPDATE statement on a table with CASCADE foreign key references and the insertion value that is similar to an existing entry in the table without padded spaces

SAP Sybase SQL Anywhere 12.0 ; Sybase SQL Anywhere 11.0

11655814 , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

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

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