Tests that we can insert fields with values and defaults in the same query.
function testDefaultInsertWithFields() {
$query = db_insert('test')
->fields(array(
'name' => 'Bob',
))
->useDefaults(array(
'job',
));
$id = $query
->execute();
$schema = drupal_get_schema('test');
$job = db_query('SELECT job FROM {test} WHERE id = :id', array(
':id' => $id,
))
->fetchField();
$this
->assertEqual($job, $schema['fields']['job']['default'], 'Default field value is set.');
}