ORA-00918 with Oracle 12 & EfCore 2
Posted: Wed 28 Feb 2018 07:54
Hi,
dotConnect throws an error on an Query like this (Oracle 12):
Error:
'ORA-00918: column ambiguously defined'
Generated SQL:
Democode can be downloaded here.
dotConnect throws an error on an Query like this (Oracle 12):
Code: Select all
dbContext.Class1.Include(o => o.OtherClass).FirstOrDefault(o => !o.IsDeleted)'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