table data is lost after disconnect from db following truncate and repopulate

If you truncate a table, then repopulate that table and disconnect from db, the data in this table is lost.

I've attached a python script which demonstrates this behavior. The steps involved in the script:

1. drop existing test_mariadb table
2. create test_mariadb table and populate with zeros in each field
3. truncate test_mariadb table
4. repopulate test_mariadb table with ones
5. close connection
6. reopen connection
7. select and print table data, which shows an empty set

This same script run on a mysql server ultimately returns a populated set as expected.