title: BigQuery github dataset returns wrong results
body: <p>So, I'm trying to do some queries using <code>bigquery-public-data:github_repos.files</code>, which was updated on <code>May 25, 2018, 2:07:03 AM</code>, in theory, it contains all files data from github - as it says in the description of the table:</p>
  
  <blockquote>
    <p>File metadata for all files at HEAD.</p>
    
    <p>Join with [bigquery-public-data:github_repos.contents] on id columns
    to search text.</p>
  </blockquote>
  
  <p>So, I have this tool called goreleaser, to use it, users create a file named .goreleaser.yaml. To have an idea of how many repositories are using it, I was using the github search, something like this a search for <code>filename:goreleaser extension:yaml extension:yml path:/</code>, you can see the results on this link.</p>
  
  <p>This shows 1k+ results, and gets results for all these possible names:</p>
  
  <ul>
  <li><code>goreleaser.yml</code></li>
  <li><code>goreleaser.yaml</code></li>
  <li><code>.goreleaser.yml</code></li>
  <li><code>.goreleaser.yaml</code></li>
  </ul>
  
  <p>The problem is, github shows the 1k result count, but you can only paginate until 1k or so. I wrote some code in Go using the API and etc, you see it here.</p>
  
  <p>Anyway, I tried to do something similar with bigquery, here is my foolish attempt:</p>
  
  <pre><code>SELECT repo_name, path
  FROM [bigquery-public-data:github_repos.files]
  WHERE REGEXP_MATCH(path, r'\.?goreleaser.ya?ml')
  </code></pre>
  
  <p>This will include the vendored tools, which is not ok, but that's not the problem. The problem is that even with the vendored tools, it only shows ~500 results, not 1k.</p>
  
  <p>PS: I also tried the simplified version matching <code>path</code> with <code>LIKE</code> and etc, same results.</p>
  
  <p>So, either I'm doing something horribly wrong, this table does not include all data as it says it does or github search is lying to me.</p>
  
  <p>Any advice?</p>
  
  <p>Thanks!</p>