DB2 10.1 SQL0418N Error

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for DB2
Post Reply
emphasis
Posts: 3
Joined: Thu 19 Nov 2015 09:19

DB2 10.1 SQL0418N Error

Post by emphasis » Wed 25 May 2016 15:18

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
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: DB2 10.1 SQL0418N Error

Post by Shalex » Thu 26 May 2016 07:38

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

Post Reply