View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006944 | SymmetricDS | Bug | public | 2025-06-16 15:11 | 2025-06-16 16:00 |
| Reporter | elong | Assigned To | elong | ||
| Priority | normal | ||||
| Status | resolved | Resolution | fixed | ||
| Product Version | 3.16.0 | ||||
| Target Version | 3.16.4 | Fixed in Version | 3.16.4 | ||
| Summary | 0006944: Firebird query error when use of reserved word for column alias | ||||
| Description | Some services run queries with a column alias of row_count, which is a built-in context variable on Firebird that cannot be used as a column alias. A simple change to use rows_count works. ERROR [test] [MonitorJob] [test-job-3] Exception while executing job 'Monitor' StackTraceKey.init [SqlException:4037794585] org.jumpmind.db.sql.SqlException: Dynamic SQL Error; SQL error code = -104; Token unknown - line 1, column 20; row_count [SQLState:42000, ISC error code:335544634] at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:308) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:297) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:506) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForObject(JdbcSqlTemplate.java:172) at org.jumpmind.db.sql.AbstractSqlTemplate.queryForInt(AbstractSqlTemplate.java:59) at org.jumpmind.symmetric.service.impl.OutgoingBatchService.countUnsentBatchesByTargetNode(OutgoingBatchService.java:492) at com.jumpmind.symmetric.monitor.MonitorTypeBatchUnsent.check(MonitorTypeBatchUnsent.java:48) at com.jumpmind.symmetric.console.service.impl.MonitorService.updateMonitor(MonitorService.java:260) at com.jumpmind.symmetric.console.service.impl.MonitorService.update(MonitorService.java:217) at com.jumpmind.symmetric.job.MonitorJob.doJob(MonitorJob.java:67) at org.jumpmind.symmetric.job.AbstractJob.invoke(AbstractJob.java:202) at org.jumpmind.symmetric.job.AbstractJob.run(AbstractJob.java:268) | ||||
| Tags | dialect: firebird | ||||
|
SymmetricDS: 3.16 a468c03f 2025-06-16 15:14:13 Details Diff |
0006944: Firebird query error when use of reserved word for column alias |
Affected Issues 0006944 |
|
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/OutgoingBatchService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/OutgoingBatchServiceSqlMap.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/UpdateService.java | Diff File | ||
| mod - symmetric-core/src/main/java/org/jumpmind/symmetric/service/impl/UpdateServiceSqlMap.java | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2025-06-16 15:11 | elong | New Issue | |
| 2025-06-16 15:11 | elong | Status | new => assigned |
| 2025-06-16 15:11 | elong | Assigned To | => elong |
| 2025-06-16 15:11 | elong | Tag Attached: dialect: firebird | |
| 2025-06-16 15:14 | elong | Status | assigned => resolved |
| 2025-06-16 15:14 | elong | Resolution | open => fixed |
| 2025-06-16 15:14 | elong | Fixed in Version | => 3.16.4 |
| 2025-06-16 16:00 | admin | Changeset attached | => SymmetricDS 3.16 a468c03f |