Icon View Incident Report

Serious Serious
Reported By: Fernando Dias
Reported On: 11/14/2004
For: Version 4.14 Build 1
# 1902 SQL Joins on any Expressions or Columns Whose Data Types Do Not Match Causes Incorrect Results

The following query causes incorrect results.

selectDataPedido, TipoCom, CodCom, NumPedido, Ref, Qt
from PedidosD D left outer join Pedidos P on 
D.TipoCom=P.TipoCom and D.CodCom=P.CodCom and D.NumPedido=P.NumPedido



Comments Comments
The D.NumPedido column was a float column while the P.NumPedido column was an integer.


Resolution Resolution
Fixed Problem on 11/15/2004 in version 4.15 build 1
Image