When packaging agate-sql for openSUSE, the test suite fails with this failure (using Python 3.6):
[ 25s] + pytest-3.6 --ignore=_build.python36 --ignore=_build.python38 -v
[ 25s] ============================= test session starts ==============================
[ 25s] platform linux -- Python 3.6.12, pytest-6.2.2, py-1.9.0, pluggy-0.13.1 -- /usr/bin/python3.6
[ 25s] cachedir: .pytest_cache
[ 25s] rootdir: /home/abuild/rpmbuild/BUILD/agate-sql-0.5.5
[ 25s] collecting ... collected 18 items
[ 25s]
[ 26s] tests/test_agatesql.py::TestSQL::test_back_and_forth PASSED [ 5%]
[ 26s] tests/test_agatesql.py::TestSQL::test_chunk_size PASSED [ 11%]
[ 26s] tests/test_agatesql.py::TestSQL::test_create_if_not_exists PASSED [ 16%]
[ 26s] tests/test_agatesql.py::TestSQL::test_make_sql_table_col_len_multiplier PASSED [ 22%]
[ 26s] tests/test_agatesql.py::TestSQL::test_make_sql_table_min_col_len PASSED [ 27%]
[ 26s] tests/test_agatesql.py::TestSQL::test_prefixes PASSED [ 33%]
[ 26s] tests/test_agatesql.py::TestSQL::test_sql_query_aggregate PASSED [ 38%]
[ 26s] tests/test_agatesql.py::TestSQL::test_sql_query_limit PASSED [ 44%]
[ 26s] tests/test_agatesql.py::TestSQL::test_sql_query_select PASSED [ 50%]
[ 26s] tests/test_agatesql.py::TestSQL::test_sql_query_simple PASSED [ 55%]
[ 26s] tests/test_agatesql.py::TestSQL::test_to_sql_create_statement PASSED [ 61%]
[ 26s] tests/test_agatesql.py::TestSQL::test_to_sql_create_statement_no_constraints PASSED [ 66%]
[ 26s] tests/test_agatesql.py::TestSQL::test_to_sql_create_statement_unique_constraint PASSED [ 72%]
[ 26s] tests/test_agatesql.py::TestSQL::test_to_sql_create_statement_wide_width PASSED [ 77%]
[ 26s] tests/test_agatesql.py::TestSQL::test_to_sql_create_statement_with_dialects PASSED [ 83%]
[ 26s] tests/test_agatesql.py::TestSQL::test_to_sql_create_statement_with_schema FAILED [ 88%]
[ 26s] tests/test_agatesql.py::TestSQL::test_to_sql_create_statement_zero_width PASSED [ 94%]
[ 26s] tests/test_agatesql.py::TestSQL::test_unique_constraint PASSED [100%]
[ 26s]
[ 26s] =================================== FAILURES ===================================
[ 26s] _______________ TestSQL.test_to_sql_create_statement_with_schema _______________
[ 26s]
[ 26s] self = <tests.test_agatesql.TestSQL testMethod=test_to_sql_create_statement_with_schema>
[ 26s]
[ 26s] def test_to_sql_create_statement_with_schema(self):
[ 26s] statement = self.table.to_sql_create_statement('test_table', db_schema='test_schema', dialect='mysql')
[ 26s]
[ 26s] self.assertEqual(statement.replace('\t', ' '), '''CREATE TABLE test_schema.test_table (
[ 26s] number DECIMAL(38, 3),
[ 26s] text VARCHAR(1) NOT NULL,
[ 26s] boolean BOOL,
[ 26s] date DATE,
[ 26s] datetime TIMESTAMP NULL,
[ 26s] CHECK (boolean IN (0, 1))
[ 26s] > );''') # noqa
[ 26s] E AssertionError: 'CREA[59 chars] \n `text` VARCHAR(1) NOT NULL, \n boolean B[78 chars]\n);' != 'CREA[59 chars] \n text VARCHAR(1) NOT NULL, \n boolean BOO[76 chars]\n);
'
[ 26s] E CREATE TABLE test_schema.test_table (
[ 26s] E number DECIMAL(38, 3),
[ 26s] E - `text` VARCHAR(1) NOT NULL,
[ 26s] E ? - -
[ 26s] E + text VARCHAR(1) NOT NULL,
[ 26s] E boolean BOOL,
[ 26s] E date DATE,
[ 26s] E datetime TIMESTAMP NULL,
[ 26s] E CHECK (boolean IN (0, 1))
[ 26s] E );
[ 26s]
[ 26s] tests/test_agatesql.py:149: AssertionError
[ 26s] =============================== warnings summary ===============================
[ 26s] tests/test_agatesql.py::TestSQL::test_make_sql_table_col_len_multiplier
[ 26s] /home/abuild/rpmbuild/BUILD/agate-sql-0.5.5/tests/test_agatesql.py:191: DeprecationWarning: Please use assertEqual instead.
[ 26s]
[ 26s] tests/test_agatesql.py::TestSQL::test_make_sql_table_min_col_len
[ 26s] /home/abuild/rpmbuild/BUILD/agate-sql-0.5.5/tests/test_agatesql.py:203: DeprecationWarning: Please use assertEqual instead.
[ 26s]
[ 26s] -- Docs: https://docs.pytest.org/en/stable/warnings.html
[ 26s] =========================== short test summary info ============================
[ 26s] FAILED tests/test_agatesql.py::TestSQL::test_to_sql_create_statement_with_schema
[ 26s] =================== 1 failed, 17 passed, 2 warnings in 0.54s ===================