5

I'm studying the Google Cloud Datastore GQL grammar - specifically the HAS ANCESTOR and HAS DESCENDANT comparison operators.

Giving the following Person entities:

  • Amy
  • Fred, parent = Amy
  • Laura, parent = Amy
  • Paul
  • Agnes ...

Would the GQL queries below produce the same output?

SELECT * FROM Person WHERE key_name='Fred' HAS ANCESTOR KEY('Person', 'Amy')

SELECT * FROM Person WHERE KEY('Person', 'Amy') HAS DESCENDANT key_name='Fred'

If so, I don't understand the existence of HAS DESCENDANT clause.

Thanks in advance!

Lee
  • 922
  • 2
  • 11
  • 19
lorenagmad
  • 89
  • 1
  • 4

1 Answers1

5

These two GQL queries should produce identical results:

SELECT * FROM Person WHERE __key__ HAS ANCESTOR KEY('Person', 'Amy')
SELECT * FROM Person WHERE KEY('Person', 'Amy') HAS DESCENDANT __key__
Ed Davisson
  • 2,927
  • 11
  • 11
Alfred Fuller
  • 773
  • 3
  • 5