View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006280 | SymmetricDS | Bug | public | 2024-03-11 11:53 | 2024-03-11 11:54 |
| Reporter | emiller | Assigned To | |||
| Priority | normal | ||||
| Status | new | Resolution | open | ||
| Product Version | 3.14.6 | ||||
| Summary | 0006280: Trigger creation fails when Progress OpenEdge table has hundreds of columns | ||||
| Description | When a Progress OpenEdge table has a very high number of columns, trigger creation fails with a message like this one: java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Error from Java compiler. Compiler messages follow.(10727) C:\OpenEdge\WRK\SQL_11992_1192\EVANC_SYM_ON_I_FOR_TST_345_CLMNS_CLNT_TP.java:85: error: unclosed string literal "case when ? is null threturn 0; ^ C:\OpenEdge\WRK\SQL_1 It appears that there is a length limit for the Java code contained within a Progress OpenEdge trigger. It may be possible to work around this issue by enabling Stream Row for the trigger. | ||||
| Steps To Reproduce | I was able to reproduce it by configuring a trigger for a Progress OpenEdge table with 345 columns. | ||||
| Tags | trigger | ||||
| related to | 0006281 | new | Trigger creation fails when Progress OpenEdge table has hundreds of columns |