ORA-00918 with Oracle 12 & EfCore 2

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
seb1487
Posts: 22
Joined: Fri 24 Jun 2016 10:27

ORA-00918 with Oracle 12 & EfCore 2

Post by seb1487 » Wed 28 Feb 2018 07:54

Hi,
dotConnect throws an error on an Query like this (Oracle 12):

Code: Select all

dbContext.Class1.Include(o => o.OtherClass).FirstOrDefault(o => !o.IsDeleted)
Error:
'ORA-00918: column ambiguously defined'

Generated SQL:

Code: Select all

SELECT "o"."Id", "o"."IsDeleted", "o"."OtherClassId", "o.OtherClass"."Id", "o.OtherClass"."IsDeleted", "o.OtherClass"."Test"
FROM "Class1" "o"
LEFT JOIN "Class2" "o.OtherClass" ON "o"."OtherClassId" = "o.OtherClass"."Id"
WHERE "o"."IsDeleted" = 0
FETCH FIRST 1 ROWS ONLY
Democode can be downloaded here.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: ORA-00918 with Oracle 12 & EfCore 2

Post by Shalex » Sat 03 Mar 2018 18:05

Thank you for your report. We are investigating the issue.

Your Oracle Server is 12.1 (not 12.2), isn't it?

seb1487
Posts: 22
Joined: Fri 24 Jun 2016 10:27

Re: ORA-00918 with Oracle 12 & EfCore 2

Post by seb1487 » Mon 05 Mar 2018 06:54

Hi Shalex,
the Oracle Version is: 12.1.0.2.0

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: ORA-00918 with Oracle 12 & EfCore 2

Post by Shalex » Fri 16 Mar 2018 15:25

Please download the build with the fix from https://www.devart.com/pub/nuget_oracle_9_5_472.zip.

Shalex
Site Admin
Posts: 8245
Joined: Thu 14 Aug 2008 12:44

Re: ORA-00918 with Oracle 12 & EfCore 2

Post by Shalex » Fri 30 Mar 2018 17:31

The bug with missing aliases in SQL generated by EF Core 2 engine for Oracle 12.1 is fixed: viewtopic.php?f=1&t=36966.

Post Reply