View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001329 | Database Comparer VCL | General | public | 2018-04-10 15:29 | 2019-04-18 19:46 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 7.0.0.1670 | ||||
| Summary | 0001329: Firebird 3.0, cannot parse DATEADD, DATEDIFF, OVERLAY functions | ||||
| Description | DATEADD(-12 MONTH TO :ADATA_STOP); DATEDIFF(DAY FROM :VDATALOT TO :ALADATA); The error message is: Missing: <)> (TO) or Missing: <)> (FROM) UPDATE DOCTRF D SET D.CODBUGETS = OVERLAY(D.CODBUGETS PLACING :ANEW_VALUE FROM :VPOZSTART FOR :VLEN) WHERE D.DATADOC BETWEEN :VDATASTART AND :VDATASTOP AND D.CODBUGETS <> '.' AND D.CODBUGETS <> '' AND SUBSTRING(D.CODBUGETS FROM :VPOZSTART FOR :VLEN) = :AOLD_VALUE; The error message is Missing: <)> (<:>) | ||||
| Steps To Reproduce | It's necessary to update the IBExParser code: add st_FireBird_30 to conditions. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-04-10 15:29 | shirokov | New Issue | |
| 2018-04-10 15:29 | shirokov | Status | new => assigned |
| 2018-04-10 15:29 | shirokov | Assigned To | => barry |
| 2018-04-25 19:04 | barry | Status | assigned => resolved |
| 2018-04-25 19:04 | barry | Resolution | open => fixed |
| 2018-04-25 19:07 | barry | Fixed in Version | => 7.0.0.1670 |
| 2019-04-18 19:46 | barry | Status | resolved => closed |