1 Reply Latest reply on Jun 18, 2020 3:41 PM by Alex Keh - Product Manager-Oracle

    EF Core 3.1 - ORA-00918 - Oracle 11g using Projections

    Jochen Jonckheere

      Hi,

       

      I encountered and ORA-00918 and quickly found in the readme that there is an issue when using row limiting and querying 2 columns with the same name, but only on Oracle 12.1.

       

      The database I'm using is Oracle 11.2.0.4.0 and I also have this issues. In my case I'm using an projection and having properties that are named the same in parent object and child object.

      Below a snippet of the projection, just before that, a Join is used to fetch the matching child.

       

          ....Select(p => new Parent

          {

              Id = p.parent.id

              Name = p.parent.Name

              Child = new Child {

                  Id = p.child.Id

                  Name = p.cheild.Name

              }

          }

       

      Maybe it is a new issue because I don't see it being related to bug 29199665 and or 29686264?

       

      As a workaround, I had to rename the properties in the child object.

       

      Kind regards,

       

      Jochen Jonckheere