You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This sql code can be run with 2.5.8 and cannot be run with 3.0.4, I could not find any changes to this
SELECT A.importe_cargo , F.clave_prov, F.nombre_proveedor, F.nombre_tipo
FROM orsp_lista_proveedores('S') F, cargos_prov(F.proveedor_id, :F_Fecha_Corte, :F_Fecha_Corte, 'N') A
LEFT JOIN DOCTOS_CP B
ON A.DOCTO_CP_ID = B.DOCTO_CP_ID
The text was updated successfully, but these errors were encountered:
This query is just a trove of bad practices....
1) mixing implicit SQL-89 and explicit SQL-92 joins
2) implicitly joining two stored procedures ( should it even work??? ) - Select f(x), g(f(x),y) ....
3) outer-joining of SP (actually, cross-join of two SPs) and a table(or view), where table is subordinate, not primary source.
Submitted by: Mauricio Martinez O (mauriciomtzo)
This sql code can be run with 2.5.8 and cannot be run with 3.0.4, I could not find any changes to this
SELECT A.importe_cargo , F.clave_prov, F.nombre_proveedor, F.nombre_tipo
FROM orsp_lista_proveedores('S') F, cargos_prov(F.proveedor_id, :F_Fecha_Corte, :F_Fecha_Corte, 'N') A
LEFT JOIN DOCTOS_CP B
ON A.DOCTO_CP_ID = B.DOCTO_CP_ID
The text was updated successfully, but these errors were encountered: