View Issue Details

IDProjectCategoryView StatusLast Update
0001500Database Workbench v5Generalpublic2017-05-31 13:02
ReporterMartijn Tonies Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version5.1.4 
Fixed in Version5.3.0 
Summary0001500: Execute Stored Procedure parameter history truncates large character-based input values
DescriptionExecute Stored Procedure parameter history truncates large character-based input values
Steps To ReproduceGreetings,

 

V5.1.4.30

 

I have a stored procedure opened in DBW. It has 5 parameters, one of which is defined as V_SQL_STATEMENT Varchar 1000

 

When I run it the first time and plug in my parameter values including my SQL statement into the V_SQL_STATEMENT parameter and execute, it runs fine.

 

The SQL I plug in is:

 

SELECT PPC.PMT_NO, PPC.ACCT_ID, PPC.CASE_ID, CLT.GOVERNMENT_CLIENT, DT.DEBT_TABLE_TYPE_CODE, CAST(PPC.ACCT_ID || '-' || PPC.CASE_ID AS VARCHAR(20)) AS ACCT_CASE, PPC.AMT_EARNED_CLT + PPC.AMT_EARNED_AGENCY_1 + PPC.AMT_EARNED_AGENCY_2 AS PMT_AMT, PP.KDRS_FEE, PPC.AMT_EARNED_AGENCY_1 + PPC.AMT_EARNED_AGENCY_2 - PP.KDRS_FEE AS AMT_EARNED_ENTITY, C.COUNTY_CODE FROM PAYMENT PP LEFT OUTER JOIN PMT_CASE PPC ON PPC.PMT_ID = PP.PMT_ID LEFT OUTER JOIN ACCT_CASE AC ON AC.ACCT_ID = PPC.ACCT_ID AND AC.CASE_ID = PPC.CASE_ID LEFT OUTER JOIN CLIENT CLT ON CLT.CLT_ID = AC.CLT_ID LEFT OUTER JOIN COUNTY C ON C.COUNTY_ID = AC.FILING_COUNTY_ID JOIN DEBT_TYPE DT ON DT.DEBT_TYPE_CODE = AC.DEBT_TYPE_CODE WHERE PP.PMT_ID = 629115

 

If I choose to run the stored procedure again and select from the history list, the SQL statement has been truncated as shown here:

 

SELECT PPC.PMT_NO, PPC.ACCT_ID, PPC.CASE_ID, CLT.GOVERNMENT_CLIENT, DT.DEBT_TABLE_TYPE_CODE, CAST(PPC.ACCT_ID || '-' || PPC.CASE_ID AS VARCHAR(20)) AS ACCT_CASE, PPC.AMT_EARNED_CLT + PPC.AMT_EARNED_AGENCY_1 + PPC.AMT_EARNED_AGENCY_2 AS PMT_AMT, PP.KDRS_F

 

Is there a remedy for this?

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2017-05-23 09:39 Martijn Tonies New Issue
2017-05-31 13:02 Martijn Tonies Status new => resolved
2017-05-31 13:02 Martijn Tonies Fixed in Version => 5.3.0
2017-05-31 13:02 Martijn Tonies Resolution open => fixed
2017-05-31 13:02 Martijn Tonies Assigned To => Martijn Tonies
2017-05-31 13:02 Martijn Tonies Status resolved => closed