View Issue Details

IDProjectCategoryView StatusLast Update
0001529Database Comparer VCL[All Projects] Generalpublic2019-06-27 17:20
ReportershirokovAssigned Tobarry 
PrioritynormalSeveritymajorReproducibilityalways
Status assignedResolutionopen 
Product Version[Database Comparer] 7.1.0.1681 
Target Version[Database Comparer] 7.1.0.1681Fixed in Version 
Summary0001529: IB Parser does not accept the use of aliases to feed variables, FB3
Description1. 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.
TagsNo tags attached.

Activities

shirokov

2019-06-27 17:20

administrator  

TESTE CLEVER.rar (120,015 bytes)

Issue History

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