Skip to content

flake: test_table_create can cause table list test to fail #123

Closed
@tswast

Description

@tswast

https://source.cloud.google.com/results/invocations/a16ca408-bdaf-4a0d-9c02-d2d1c149f427/targets/cloud-devrel%2Fclient-libraries%2Fpython%2Fgoogleapis%2Fpython-bigquery-sqlalchemy%2Fpresubmit%2Fpresubmit/log

nox > Running session system-3.8
nox > Creating virtual environment (virtualenv) using python3.8 in .nox/system-3-8
nox > python -m pip install --pre grpcio
nox > python -m pip install mock pytest google-cloud-testutils -c /tmpfs/src/github/python-bigquery-sqlalchemy/testing/constraints-3.8.txt
nox > python -m pip install -e . -c /tmpfs/src/github/python-bigquery-sqlalchemy/testing/constraints-3.8.txt
nox > py.test --quiet --junitxml=system_3.8_sponge_log.xml tests/system
..............................F.............                             [100%]
=================================== FAILURES ===================================
__________________________ test_table_names_in_schema __________________________

inspector = <sqlalchemy.engine.reflection.Inspector object at 0x7f33fdaa8c70>
inspector_using_test_dataset = <sqlalchemy.engine.reflection.Inspector object at 0x7f33fdaa8eb0>

    def test_table_names_in_schema(inspector, inspector_using_test_dataset):
        tables = inspector.get_table_names("test_pybigquery")
        assert "test_pybigquery.sample" in tables
        assert "test_pybigquery.sample_one_row" in tables
        assert "test_pybigquery.sample_view" not in tables
        assert len(tables) == 2

        tables = inspector_using_test_dataset.get_table_names()
        assert "sample" in tables
        assert "sample_one_row" in tables
        assert "sample_view" not in tables
>       assert len(tables) == 2
E       AssertionError: assert 3 == 2
E        +  where 3 = len(['sample', 'sample_one_row', 'test_table_create'])

tests/system/test_sqlalchemy_bigquery.py:584: AssertionError

Metadata

Metadata

Assignees

Labels

api: bigqueryIssues related to the googleapis/python-bigquery-sqlalchemy API.type: processA process-related concern. May include testing, release, or the like.

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions