DB2 10.1 SQL0418N Error

[emphasis]

Hello,

I try to run the following query in DB2 10.1 with devart for DB2 1.8.636 and EF 6.1.40302.0 but an SQL0418N error is returned.

Code: Select all

SELECT 
Project2.roiRoadIncidentID,
Project2.rocRoadContractID,
Project2.C1,
Project2.roaRoadAssignmentID
FROM ( SELECT 
	Limit1.roiRoadIncidentID,
	Limit1.rocRoadContractID,
	Extent3.roaRoadAssignmentID
	CASE WHEN Extent3.roaRoadAssignmentID IS NULL THEN CAST(NULL AS INTEGER) ELSE 1 END AS C1
	FROM   (SELECT 
	       @p__linq__1 AS p__linq__1,
		Extent1.roiRoadIncidentID,
		Extent2.rocRoadContractID
		FROM  Administrator.Interamerican_RoadIncident Extent1
		INNER JOIN Administrator.Interamerican_RoadContract Extent2 ON Extent1.roiRoadContractID = Extent2.rocRoadContractID
		WHERE Extent1.roiRoadIncidentID = @p__linq__0
		FETCH FIRST 1 ROWS ONLY ) Limit1
	LEFT OUTER JOIN Administrator.Interamerican_RoadAssignment Extent3 ON (Extent3.roaRoadIncidentID = Limit1.roiRoadIncidentID) AND (Extent3.roaRoadAssignmentID = @p__linq__1)
)  Project2
ORDER BY Project2.roiRoadIncidentID ASC, Project2.rocRoadContractID ASC, Project2.C1 ASC

The problem is in line 12:

Code: Select all

@p__linq__1 AS p__linq__1,

As it seems, EF Provider does not cast the p__linq__1 parameter. If I manually cast it, then the query runs correctly!

Code: Select all

CAST(@p__linq__1 AS INTEGER) AS p__linq__1,

Any ideas on how to resolve the problem?

[Shalex]

Please send us a small test project with the corresponding DDL/DML script for reproducing.