2218272 - Error 213: Insert error: column name or number of supplied values does not match table definition after upgrade - SAP ASE

• After the patch SP134 was applied to a production ASE 15.7 SP110
• Application started receiving the following error from a trigger execution:

Error 213: Insert error: column name or number of supplied values does not match table definition.

• SQL code used by the trigger is as follows:

CREATE TRIGGER upd_mytable
on mytable
for update
as
begin
    DECLARE @c          int
    
    SELECT  @c = @@rowcount

    IF  (@c = 0)   -- nothing to do
        RETURN         
     
 if ( @c > 1 )
    begin
   
        insert into mytable_copy
        select *,getDate(),user from inserted i1     
       
 end
 else
    begin
   
        insert into mytable_copy
        select *,getDate(),user from inserted i1     
       
    end  
  
END

• It used to work fine before the patch SP134 was applied
• The issue was resolved by modifying the trigger to explicitly list columns during INSERT

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0

Trace flag, traceflag, 7798, procedure, deferred, compilation, re-resolution, CR756648, CR#756648, 756648 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement