View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001529 | Database Comparer VCL | General | public | 2019-06-27 17:20 | 2020-02-23 08:00 |
| Reporter | shirokov | Assigned To | barry | ||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Product Version | 7.1.0.1681 | ||||
| Target Version | 7.1.0.1681 | Fixed in Version | 8.0.0.1693.Beta | ||
| Summary | 0001529: IB Parser does not accept the use of aliases to feed variables, FB3 | ||||
| Description | 1. Error: Invalid statement (? assignment) PSQL: execute statement (:s) (table_name := table_name, operation := :operation, currentuser := (select id_usuario from vi_usuario_ativo), clientaddress := rdb$get_context('SYSTEM', 'CLIENT_ADDRESS'), protocol := rdb$get_context('SYSTEM', 'NETWORK_PROTOCOL'), PK1 := :PK1, PK2 := :PK2, PK3 := :PK3, PK4 := :PK4, PK5 := :PK5, PK6 := :PK6, PK7 := :PK7, PK8 := :PK8) 2. Doesn't allow the use of USING: Error: Missing: INTO (<Ident>: USING) PSQL: select (...) from docto_item i left join docto_item_icms icms using (id_filial, id_docto, id_item) (...) where i.id_filial = :in_id_filial and i.id_docto = :in_id_docto into (...); 3. Doesn't recognize the extract(millisecond ...). Error: Invalid <part> in EXTRACT(part FROM value) function PSQL: extract(millisecond from new.alteracao_local) See the attached databases. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-06-27 17:20 | shirokov | New Issue | |
| 2019-06-27 17:20 | shirokov | Status | new => assigned |
| 2019-06-27 17:20 | shirokov | Assigned To | => barry |
| 2019-06-27 17:20 | shirokov | File Added: TESTE CLEVER.rar | |
| 2019-12-12 23:30 | barry | Status | assigned => acknowledged |
| 2019-12-12 23:36 | barry | Status | acknowledged => confirmed |
| 2019-12-13 09:35 | barry | Status | confirmed => resolved |
| 2019-12-13 09:35 | barry | Resolution | open => fixed |
| 2019-12-13 09:35 | barry | Fixed in Version | => 8.0.0.1693.Beta |
| 2020-02-23 08:00 | barry | Status | resolved => closed |
