title: SELECT ... LIMIT 1 query results in more than one row?
body: <p>I noticed that LIMIT queries will return more than the expected number of rows when they are executed against tables that contain nested or repeated data. For example, the following query run against the <a href="https://developers.google.com/bigquery/docs/personsData.json" rel="nofollow">persons</a> sample data set from the developer guide produces the following results:</p>
  
  <pre><code>% bq query 'SELECT fullName, children.name FROM [persons.person] LIMIT 1'   
  +----------+---------------+
  | fullName | children_name |
  +----------+---------------+
  | John Doe | Jane          |
  | John Doe | John          |
  +----------+---------------+
  </code></pre>
  
  <p>It looks like BQL is applying the LIMIT operator before flattening the results as opposed to the other way around (which I think would make more sense).</p>
  
  <p>Is this a bug in the BQL implementation or is this the expected behavior? If this is the expected behavior can someone please provide an explanation for why this makes sense?</p>