my exam cloud mock 4, identification variable is case insensitive

[Himai Minh]

SELECT DISTINCT o FROM
Order o JOIN o.products p JOIN P.license l
WHERE l.type="corporate_license"

Which is true about the given query?
A. The query is valid.
B. The query is invalid.
C. Removing WHERE l.type="corporate_license" will enable this as a valid query.

Correct answer: B.
Explanation:
Identification variables are case insensitive....
Hense P.license is not legal. If we change this to p.license then the query is valid.

But the specification does say "Identification variables are case insensitive".
Why P.license is not the same as p.liscence ?

[Himai Minh]

To answer my own question, I try to run this JPQL from jpqlExample in the book,

SELECT DISTINCT p FROM Department d JOIN d.employees e JOIN E.projects p

and

SELECT DISTINCT p FROM Department d JOIN d.employees e JOIN e.projects p

Since identifiable variables are case insensitive, these JPQL statements return the same result.

[Frits Walraven]

Yes, you are correct again.

Are you not getting tired of all these mistakes?

[Himai Minh]

I enjoyed fixing those mistakes.
Actually , someone on the forum asked me to review the My Exam Cloud (previously known as EPracticeLab).
I may be the first one who volunteers to review those mock exams.

[Frits Walraven]

I enjoyed fixing those mistakes.

That definitely deserves a Cow!