View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000803 | Interbase/Firebird | General | public | 2015-04-02 17:34 | 2019-04-19 14:58 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | no change required | ||
| Fixed in Version | 7.0.0.1680 | ||||
| Summary | 0000803: The database comparer cannot parse the "rows 1" statement in triggers. | ||||
| Description | Master and target scripts are attached in the archive. Problem report: a trigger containing an Update Tablename Rows 1 statement would fail with the following errormessage: Trigger TESTTABLE_BI: Invalid statement (? assignment) Script: Line:8 Pos:13 Problem highlight: following update statement will cause error because of the ROWS clause used: update testtable set testtable.idfield = 0 where testtable.idfield < 0 rows 1; | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-04-02 17:34 | shirokov | New Issue | |
| 2015-04-02 17:34 | shirokov | File Added: dbcomparer_row_parse_error.zip | |
| 2015-04-02 17:37 | shirokov | Note Added: 0001974 | |
| 2019-04-19 14:52 | barry | Project | PostgreSQL => Interbase/Firebird |
| 2019-04-19 14:58 | barry | Assigned To | => barry |
| 2019-04-19 14:58 | barry | Status | new => closed |
| 2019-04-19 14:58 | barry | Resolution | open => no change required |
| 2019-04-19 14:58 | barry | Fixed in Version | => 7.0.0.1680 |
| 2019-04-19 14:58 | barry | Note Added: 0004079 |
