View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000172 | SymmetricDS | Bug | public | 2010-01-13 18:23 | 2010-01-29 14:19 |
| Reporter | Assigned To | elong | |||
| Priority | high | ||||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.7.7 | ||||
| Target Version | 1.7.8 | Fixed in Version | 1.7.8 | ||
| Summary | 0000172: Statement too complex error with large number of columns on a table | ||||
| Description | Using Apache Derby 10.5.3.0 and Symmetric-ds 1.7.7, a table with a large number of columns (around 100) gets an error while creating the trigger: Caused by: org.apache.derby.client.am.SqlException: Statement too complex. Try rewriting the query to remove complexity. Eliminating many duplicate expressions or breaking up the query and storing interim results in a temporary table can often help resolve this error. | ||||
| Tags | No tags attached. | ||||