Additional tests for DriverSpecificSchemaTestBase

Problem/Motivation

Follow up from 🐛 Allow DriverSpecificSchemaTestBase::testChangePrimaryKeyToSerial to execute for non-core drivers Fixed from @mondrake

we could write a separate test (this one really driver specific) with different cases of inserting or not a value in a serial column, forcing a gap skip in the autonumbering etc

Steps to reproduce

NA

Proposed resolution

Write the tests

Remaining tasks

Write tests
Review

User interface changes

NA

API changes

NA

Data model changes

NA

Release notes snippet

NA