prompt: We are currently solving the following issue within our repository. Here is the issue text:
  --- BEGIN ISSUE ---
  fix bigquery version
  https://dev.azure.com/ibis-project/ibis/_build/results?buildId=3396&view=logs&j=8f09edc2-e3b7-52de-126a-0225c4f3efa1&t=78a72aec-b398-558e-7c0d-2d33604b9e53
  
  I think we need to limit the upper bound of bigquery library here.
  
  --- END ISSUE ---
  
  Below are some code segments, each from a relevant file. One or more of these files may contain bugs.
  --- BEGIN FILES ---
  Path: `setup.py`
  Content:
  ```
  1 #!/usr/bin/env python
  2 """Ibis setup module."""
  3 import pathlib
  4 import sys
  5 
  6 from setuptools import find_packages, setup
  7 
  8 import versioneer
  9 
  10 LONG_DESCRIPTION = """
  11 Ibis is a productivity-centric Python big data framework.
  12 
  13 See http://ibis-project.org
  14 """
  15 
  16 VERSION = sys.version_info.major, sys.version_info.minor
  17 
  18 impala_requires = ['hdfs>=2.0.16', 'sqlalchemy>=1.1,<1.3.7', 'requests']
  19 impala_requires.append('impyla[kerberos]>=0.15.0')
  20 
  21 sqlite_requires = ['sqlalchemy>=1.1,<1.3.7']
  22 postgres_requires = sqlite_requires + ['psycopg2']
  23 mysql_requires = sqlite_requires + ['pymysql']
  24 
  25 omniscidb_requires = ['pymapd>=0.12.0']
  26 kerberos_requires = ['requests-kerberos']
  27 visualization_requires = ['graphviz']
  28 clickhouse_requires = [
  29     'clickhouse-driver>=0.1.3',
  30     'clickhouse-cityhash',
  31 ]
  32 bigquery_requires = ['google-cloud-bigquery>=1.12.0', 'pydata-google-auth']
  33 hdf5_requires = ['tables>=3.0.0']
  34 
  35 parquet_requires = ['pyarrow>=0.12.0']
  36 spark_requires = ['pyspark>=2.4.3']
  37 
  38 geospatial_requires = ['geoalchemy2', 'geopandas', 'shapely']
  39 
  40 all_requires = (
  41     impala_requires
  42     + postgres_requires
  43     + omniscidb_requires
  44     + mysql_requires
  45     + kerberos_requires
  46     + visualization_requires
  47     + clickhouse_requires
  48     + bigquery_requires
  49     + hdf5_requires
  50     + parquet_requires
  51     + spark_requires
  52     + geospatial_requires
  53 )
  54 
  55 develop_requires = all_requires + [
  56     'black',
  57     'click',
  58     'pydocstyle==4.0.1',
  59     'flake8',
  60     'isort',
  61     'mypy',
  62     'pre-commit',
  63     'pygit2',
  64     'pytest>=4.5',
  65 ]
  66 
  67 install_requires = [
  68     line.strip()
  69     for line in pathlib.Path(__file__)
  70     .parent.joinpath('requirements.txt')
  71     .read_text()
  72     .splitlines()
  73 ]
  74 
  75 setup(
  76     name='ibis-framework',
  77     url='https://github.com/ibis-project/ibis',
  78     packages=find_packages(),
  79     version=versioneer.get_version(),
  80     cmdclass=versioneer.get_cmdclass(),
  81     install_requires=install_requires,
  82     python_requires='>=3.7',
  83     extras_require={
  84         'all': all_requires,
  85         'develop': develop_requires,
  86         'impala': impala_requires,
  87         'kerberos': kerberos_requires,
  88         'postgres': postgres_requires,
  89         'omniscidb': omniscidb_requires,
  90         'mysql': mysql_requires,
  91         'sqlite': sqlite_requires,
  92         'visualization': visualization_requires,
  93         'clickhouse': clickhouse_requires,
  94         'bigquery': bigquery_requires,
  95         'hdf5': hdf5_requires,
  96         'parquet': parquet_requires,
  97         'spark': spark_requires,
  98         'geospatial': geospatial_requires,
  99     },
  100     description="Productivity-centric Python Big Data Framework",
  101     long_description=LONG_DESCRIPTION,
  102     classifiers=[
  103         'Development Status :: 4 - Beta',
  104         'Operating System :: OS Independent',
  105         'Intended Audience :: Science/Research',
  106         'Programming Language :: Python',
  107         'Programming Language :: Python :: 3',
  108         'Topic :: Scientific/Engineering',
  109     ],
  110     license='Apache License, Version 2.0',
  111     maintainer="Phillip Cloud",
  112     maintainer_email="phillip.cloud@twosigma.com",
  113 )
  114
  ```
  --- END FILES ---
  
  Please first localize the bug based on the issue statement, and then generate a patch according to the `git diff` format fenced by three backticks.
  
  Here is an example:
  
  ```diff
  diff --git a/examples/server_async.py b/examples/server_async.py
  --- a/examples/server_async.py
  +++ b/examples/server_async.py
  @@ -313,4 +313,4 @@
   
   
   if __name__ == "__main__":
  -    asyncio.run(run_async_server("."), debug=True)
  +    asyncio.run(run_async_server(), debug=True)
  diff --git a/examples/server_sync.py b/examples/server_sync.py
  --- a/examples/server_sync.py
  +++ b/examples/server_sync.py
  @@ -313,5 +313,5 @@
   
   
   if __name__ == "__main__":
  -    server = run_sync_server(".")
  +    server = run_sync_server()
       server.shutdown()
  
  ```
  
golden_diff: diff --git a/setup.py b/setup.py
  --- a/setup.py
  +++ b/setup.py
  @@ -29,7 +29,10 @@
       'clickhouse-driver>=0.1.3',
       'clickhouse-cityhash',
   ]
  -bigquery_requires = ['google-cloud-bigquery>=1.12.0', 'pydata-google-auth']
  +bigquery_requires = [
  +    'google-cloud-bigquery[bqstorage,pandas]>=1.12.0,<2.0.0dev',
  +    'pydata-google-auth',
  +]
   hdf5_requires = ['tables>=3.0.0']
   
   parquet_requires = ['pyarrow>=0.12.0']
  
verification_info: {"golden_diff": "diff --git a/setup.py b/setup.py\n--- a/setup.py\n+++ b/setup.py\n@@ -29,7 +29,10 @@\n     'clickhouse-driver>=0.1.3',\n     'clickhouse-cityhash',\n ]\n-bigquery_requires = ['google-cloud-bigquery>=1.12.0', 'pydata-google-auth']\n+bigquery_requires = [\n+    'google-cloud-bigquery[bqstorage,pandas]>=1.12.0,<2.0.0dev',\n+    'pydata-google-auth',\n+]\n hdf5_requires = ['tables>=3.0.0']\n \n parquet_requires = ['pyarrow>=0.12.0']\n", "issue": "fix bigquery version\nhttps://dev.azure.com/ibis-project/ibis/_build/results?buildId=3396&view=logs&j=8f09edc2-e3b7-52de-126a-0225c4f3efa1&t=78a72aec-b398-558e-7c0d-2d33604b9e53\r\n\r\nI think we need to limit the upper bound of bigquery library here.\n", "before_files": [{"content": "#!/usr/bin/env python\n\"\"\"Ibis setup module.\"\"\"\nimport pathlib\nimport sys\n\nfrom setuptools import find_packages, setup\n\nimport versioneer\n\nLONG_DESCRIPTION = \"\"\"\nIbis is a productivity-centric Python big data framework.\n\nSee http://ibis-project.org\n\"\"\"\n\nVERSION = sys.version_info.major, sys.version_info.minor\n\nimpala_requires = ['hdfs>=2.0.16', 'sqlalchemy>=1.1,<1.3.7', 'requests']\nimpala_requires.append('impyla[kerberos]>=0.15.0')\n\nsqlite_requires = ['sqlalchemy>=1.1,<1.3.7']\npostgres_requires = sqlite_requires + ['psycopg2']\nmysql_requires = sqlite_requires + ['pymysql']\n\nomniscidb_requires = ['pymapd>=0.12.0']\nkerberos_requires = ['requests-kerberos']\nvisualization_requires = ['graphviz']\nclickhouse_requires = [\n    'clickhouse-driver>=0.1.3',\n    'clickhouse-cityhash',\n]\nbigquery_requires = ['google-cloud-bigquery>=1.12.0', 'pydata-google-auth']\nhdf5_requires = ['tables>=3.0.0']\n\nparquet_requires = ['pyarrow>=0.12.0']\nspark_requires = ['pyspark>=2.4.3']\n\ngeospatial_requires = ['geoalchemy2', 'geopandas', 'shapely']\n\nall_requires = (\n    impala_requires\n    + postgres_requires\n    + omniscidb_requires\n    + mysql_requires\n    + kerberos_requires\n    + visualization_requires\n    + clickhouse_requires\n    + bigquery_requires\n    + hdf5_requires\n    + parquet_requires\n    + spark_requires\n    + geospatial_requires\n)\n\ndevelop_requires = all_requires + [\n    'black',\n    'click',\n    'pydocstyle==4.0.1',\n    'flake8',\n    'isort',\n    'mypy',\n    'pre-commit',\n    'pygit2',\n    'pytest>=4.5',\n]\n\ninstall_requires = [\n    line.strip()\n    for line in pathlib.Path(__file__)\n    .parent.joinpath('requirements.txt')\n    .read_text()\n    .splitlines()\n]\n\nsetup(\n    name='ibis-framework',\n    url='https://github.com/ibis-project/ibis',\n    packages=find_packages(),\n    version=versioneer.get_version(),\n    cmdclass=versioneer.get_cmdclass(),\n    install_requires=install_requires,\n    python_requires='>=3.7',\n    extras_require={\n        'all': all_requires,\n        'develop': develop_requires,\n        'impala': impala_requires,\n        'kerberos': kerberos_requires,\n        'postgres': postgres_requires,\n        'omniscidb': omniscidb_requires,\n        'mysql': mysql_requires,\n        'sqlite': sqlite_requires,\n        'visualization': visualization_requires,\n        'clickhouse': clickhouse_requires,\n        'bigquery': bigquery_requires,\n        'hdf5': hdf5_requires,\n        'parquet': parquet_requires,\n        'spark': spark_requires,\n        'geospatial': geospatial_requires,\n    },\n    description=\"Productivity-centric Python Big Data Framework\",\n    long_description=LONG_DESCRIPTION,\n    classifiers=[\n        'Development Status :: 4 - Beta',\n        'Operating System :: OS Independent',\n        'Intended Audience :: Science/Research',\n        'Programming Language :: Python',\n        'Programming Language :: Python :: 3',\n        'Topic :: Scientific/Engineering',\n    ],\n    license='Apache License, Version 2.0',\n    maintainer=\"Phillip Cloud\",\n    maintainer_email=\"phillip.cloud@twosigma.com\",\n)\n", "path": "setup.py"}], "after_files": [{"content": "#!/usr/bin/env python\n\"\"\"Ibis setup module.\"\"\"\nimport pathlib\nimport sys\n\nfrom setuptools import find_packages, setup\n\nimport versioneer\n\nLONG_DESCRIPTION = \"\"\"\nIbis is a productivity-centric Python big data framework.\n\nSee http://ibis-project.org\n\"\"\"\n\nVERSION = sys.version_info.major, sys.version_info.minor\n\nimpala_requires = ['hdfs>=2.0.16', 'sqlalchemy>=1.1,<1.3.7', 'requests']\nimpala_requires.append('impyla[kerberos]>=0.15.0')\n\nsqlite_requires = ['sqlalchemy>=1.1,<1.3.7']\npostgres_requires = sqlite_requires + ['psycopg2']\nmysql_requires = sqlite_requires + ['pymysql']\n\nomniscidb_requires = ['pymapd>=0.12.0']\nkerberos_requires = ['requests-kerberos']\nvisualization_requires = ['graphviz']\nclickhouse_requires = [\n    'clickhouse-driver>=0.1.3',\n    'clickhouse-cityhash',\n]\nbigquery_requires = [\n    'google-cloud-bigquery[bqstorage,pandas]>=1.12.0,<2.0.0dev',\n    'pydata-google-auth',\n]\nhdf5_requires = ['tables>=3.0.0']\n\nparquet_requires = ['pyarrow>=0.12.0']\nspark_requires = ['pyspark>=2.4.3']\n\ngeospatial_requires = ['geoalchemy2', 'geopandas', 'shapely']\n\nall_requires = (\n    impala_requires\n    + postgres_requires\n    + omniscidb_requires\n    + mysql_requires\n    + kerberos_requires\n    + visualization_requires\n    + clickhouse_requires\n    + bigquery_requires\n    + hdf5_requires\n    + parquet_requires\n    + spark_requires\n    + geospatial_requires\n)\n\ndevelop_requires = all_requires + [\n    'black',\n    'click',\n    'pydocstyle==4.0.1',\n    'flake8',\n    'isort',\n    'mypy',\n    'pre-commit',\n    'pygit2',\n    'pytest>=4.5',\n]\n\ninstall_requires = [\n    line.strip()\n    for line in pathlib.Path(__file__)\n    .parent.joinpath('requirements.txt')\n    .read_text()\n    .splitlines()\n]\n\nsetup(\n    name='ibis-framework',\n    url='https://github.com/ibis-project/ibis',\n    packages=find_packages(),\n    version=versioneer.get_version(),\n    cmdclass=versioneer.get_cmdclass(),\n    install_requires=install_requires,\n    python_requires='>=3.7',\n    extras_require={\n        'all': all_requires,\n        'develop': develop_requires,\n        'impala': impala_requires,\n        'kerberos': kerberos_requires,\n        'postgres': postgres_requires,\n        'omniscidb': omniscidb_requires,\n        'mysql': mysql_requires,\n        'sqlite': sqlite_requires,\n        'visualization': visualization_requires,\n        'clickhouse': clickhouse_requires,\n        'bigquery': bigquery_requires,\n        'hdf5': hdf5_requires,\n        'parquet': parquet_requires,\n        'spark': spark_requires,\n        'geospatial': geospatial_requires,\n    },\n    description=\"Productivity-centric Python Big Data Framework\",\n    long_description=LONG_DESCRIPTION,\n    classifiers=[\n        'Development Status :: 4 - Beta',\n        'Operating System :: OS Independent',\n        'Intended Audience :: Science/Research',\n        'Programming Language :: Python',\n        'Programming Language :: Python :: 3',\n        'Topic :: Scientific/Engineering',\n    ],\n    license='Apache License, Version 2.0',\n    maintainer=\"Phillip Cloud\",\n    maintainer_email=\"phillip.cloud@twosigma.com\",\n)\n", "path": "setup.py"}]}