Crash complaining of tabulate() and preserve_whitespace

[mytskine]

Every command crashes with the message tabulate() got an unexpected keyword argument 'preserve_whitespace'.

Here is a session, with added blank lines to increase readability.

❯ mycli -u u -p p --myclirc /usr/lib/python3/dist-packages/mycli/myclirc db
Connecting to socket /var/run/mysqld/mysqld.sock, owned by user mysql
MariaDB 11.8.6
mycli 1.55.0
Home: http://mycli.net
Bug tracker: https://github.com/dbcli/mycli/issues
Tip — customize colors using the "[colors]" section in ~/.myclirc!

MariaDB u@localhost:db> select unix_timestamp('2047-02-01');
tabulate() got an unexpected keyword argument 'preserve_whitespace'

MariaDB mirabel@localhost:mirabel2> show tables;
tabulate() got an unexpected keyword argument 'preserve_whitespace'

MariaDB u@localhost:db> 

System

• I had just installed mycli with apt (Debian testing).
• My first session used an old custom myclirc, but nothing changed when I switched to the default config (which the command above uses).
• Launching with --checkup says everything is alright, except that fzf is not installed.

[rolandwalker]

Hi! Thanks for the report! Seems like dependency versions is something we should add to --checkup.

If you have the time, could you try these commands?

env PYTHONPATH= mycli -u u -p p --myclirc /usr/lib/python3/dist-packages/mycli/myclirc db

(and verify you have the same bug)

env PYTHONPATH= python -c 'import tabulate; print(tabulate.__version__)'

(and tell us the tabulate version number)

env PYTHONPATH= python -c 'import cli_helpers; print(cli_helpers.__version__)'

(and tell us the cli_helpers version number)

which tabulate

(and tell us if there is any output at all)

The guess would be that Debian installs a different version of tabulate that our software expects. tabulate recently made a release with a breaking change. Perhaps we should do some version probing as was initially suggested in dbcli/cli_helpers#107.