SAP Knowledge Base Article - Preview

2222064 - the str_replace function returns longer output than in previous versions - SAP ASE

Symptom

  • In ASE 15.7 SP130 and above, the str_replace function produces much wider output than in previous versions.

  • This behavior can be seen in a view, but it is not limited to views:

1> sp_help mytest_view
2> go
 
Name                 Owner  Object_type  Object_status    Create_date
 ------------------- -------- -------------  ----------------- -------------------
 mytest_view         dbo          view         -- none --         Sep 24 2015  8:36AM

 Column_name         Type       Length Prec  Scale   Nulls   Not_compressed  Default_name    Rule_name  Access_Rule_name   Computed_Column_object   Identity
 --------------------     --------   ------- -----  ------- ------- -------------------  ------------------ -------------- ---------------------- -----------------------------   ---------
 SOURCE_DATABASE varchar   1024   NULL  NULL     1           0                   NULL                NULL               NULL                      NULL                                 0
 No defined keys for this object.    

  • In previous versions, the varchar would be expected to be varchar(10), instead of varchar (1024).


Read more...

Environment

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

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

pattern string, replacement strings , 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.