Filtering with exists in BigQuery

admin

3 years ago

I’m running the following query in bigQuery and I don’t have the expected output. Isn’t that only the row with Alpha should be returned?

SELECT * FROM UNNEST([
  STRUCT(NULL AS a, '' AS b),
  (1, 'Alpha'),
  (2, 'Bravo'),
  (3, 'Charlie'),
  (4, 'Delta')
])
WHERE EXISTS (SELECT * FROM UNNEST([
  STRUCT(NULL AS a, '' AS b),
  (1, 'Alpha')
]))