Bug#1000552: openpyxl breaks python-agate-excel autopkgtest

[Paul Gevers]

Source: openpyxl, python-agate-excel
Control: found -1 openpyxl/3.0.9-1
Control: found -1 python-agate-excel/0.2.3-1
Severity: serious
Tags: sid bookworm
X-Debbugs-CC: debian-ci at lists.debian.org
User: debian-ci at lists.debian.org
Usertags: breaks needs-update

Dear maintainer(s),

With a recent upload of openpyxl the autopkgtest of python-agate-excel 
fails in testing when that autopkgtest is run with the binary packages 
of openpyxl from unstable. It passes when run with only packages from 
testing. In tabular form:

                        pass            fail
openpyxl               from testing    3.0.9-1
python-agate-excel     from testing    0.2.3-1
all others             from testing    from testing

I copied some of the output at the bottom of this report.

Currently this regression is blocking the migration of openpyxl to 
testing [1]. Due to the nature of this issue, I filed this bug report 
against both packages. Can you please investigate the situation and 
reassign the bug to the right package?

More information about this bug and the reason for filing it can be found on
https://wiki.debian.org/ContinuousIntegration/RegressionEmailInformation

Paul

[1] https://qa.debian.org/excuses.php?package=openpyxl

https://ci.debian.net/data/autopkgtest/testing/amd64/p/python-agate-excel/16944816/log.gz

=================================== FAILURES 
===================================
_________________________ TestXLSX.test_ambiguous_date 
_________________________

self = <tests.test_table_xlsx.TestXLSX testMethod=test_ambiguous_date>

     def test_ambiguous_date(self):
         table = agate.Table.from_xlsx('examples/test_ambiguous_date.xlsx')
             self.assertColumnNames(table, ['s'])
         self.assertColumnTypes(table, [agate.Date])
>       self.assertRows(table, [
             [datetime.date(1899, 12, 31)],
         ])

tests/test_table_xlsx.py:108: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ 
/usr/lib/python3/dist-packages/agate/testcase.py:53: in assertRows
     self.assertSequenceEqual(table.rows[i], row)
E   AssertionError: Sequences differ: <agate.Row: (datetime.date(1900, 
1, 1))> != [datetime.date(1899, 12, 31)]
E   E   First differing element 0:
E   datetime.date(1900, 1, 1)
E   datetime.date(1899, 12, 31)
E   E   - <agate.Row: (datetime.date(1900, 1, 1))>
E   + [datetime.date(1899, 12, 31)]
=============================== warnings summary 
===============================
tests/test_table_xls.py::TestXLS::test_header
tests/test_table_xlsx.py::TestXLSX::test_header
   /usr/lib/python3/dist-packages/agateexcel/table_xls.py:91: 
RuntimeWarning: Column names not specified. "('a', 'b', 'c')" will be 
used as names.

tests/test_table_xls.py::TestXLS::test_numeric_column_name
tests/test_table_xlsx.py::TestXLSX::test_numeric_column_name
   /usr/lib/python3/dist-packages/agate/utils.py:285: 
UnnamedColumnWarning: Column 2 has no name. Using "c".

tests/test_table_xlsx.py::TestXLSX::test_file_like
tests/test_table_xlsx.py::TestXLSX::test_from_xlsx
tests/test_table_xlsx.py::TestXLSX::test_from_xlsx_with_column_names
tests/test_table_xlsx.py::TestXLSX::test_sheet_index
tests/test_table_xlsx.py::TestXLSX::test_sheet_multiple
tests/test_table_xlsx.py::TestXLSX::test_sheet_multiple
tests/test_table_xlsx.py::TestXLSX::test_sheet_name
   /usr/lib/python3/dist-packages/openpyxl/worksheet/_reader.py:312: 
UserWarning: Unknown extension is not supported and will be removed

-- Docs: https://docs.pytest.org/en/stable/warnings.html
=========================== short test summary info 
============================
FAILED tests/test_table_xlsx.py::TestXLSX::test_ambiguous_date - 
AssertionErr...
================== 1 failed, 22 passed, 11 warnings in 0.53s 
===================
autopkgtest [01:11:31]: test command1


-------------- next part --------------
A non-text attachment was scrubbed...
Name: OpenPGP_signature
Type: application/pgp-signature
Size: 495 bytes
Desc: OpenPGP digital signature
URL: <http://alioth-lists.debian.net/pipermail/debian-science-maintainers/attachments/20211124/0843ada8/attachment-0001.sig>