def _run_autocommit_on(cnx, db_parameters):
    """Run autocommit on test.

    Args:
        cnx: The database connection context.
        db_parameters: Database parameters.
    """

    def exe(cnx, sql):
        return cnx.cursor().execute(sql.format(name=db_parameters["name"]))

    exe(
        cnx,
        """
INSERT INTO {name} VALUES(True), (False), (False)
""",
    )
    cnx.rollback()
    res = exe(
        cnx,
        """
SELECT COUNT(*) FROM {name} WHERE NOT c1
""",
    ).fetchone()
    assert res[0] == 4