ORA-00918 with Oracle 12 & EfCore 2

[seb1487]

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]

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

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

[seb1487]

Hi Shalex,
the Oracle Version is: 12.1.0.2.0

[Shalex]

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

[Shalex]

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.