View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001500 | Database Workbench v5 | General | public | 2017-05-23 09:39 | 2017-05-31 13:02 |
| Reporter | Martijn Tonies | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Product Version | 5.1.4 | ||||
| Fixed in Version | 5.3.0 | ||||
| Summary | 0001500: Execute Stored Procedure parameter history truncates large character-based input values | ||||
| Description | Execute Stored Procedure parameter history truncates large character-based input values | ||||
| Steps To Reproduce | Greetings, 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? | ||||
| Tags | No tags attached. | ||||
| 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 |
